Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lisakrebs
Starting Member
10 Posts |
 Posted - 2011-10-31 : 12:49:40
|
| Need to setup replication between two databases. Any documentation available and how do I determine if it is working properly.Thanks,Lisa |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-31 : 13:01:16
|
| It's pretty easy to do - depending on the type - snapshot,merge,transactional, log shipping, push, pull,...Where do you want the distributor?You can test it on a dev instance (or two) on your desktop. It test it by changing some data and seeing if it replicates and also by looking at the monitor.It's useful to have a test system for changes and replicating issues.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Database replication