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 |
|
holymac
Starting Member
13 Posts |
 Posted - 2004-10-22 : 02:01:17
|
| Hi there everyone.I would like to know how to do replication over sQL SERVER 2000.Is there anyone has a tutorial or article that teaches me how to do replication step by step.1. Can replication be done in the same server but different db.2. I have a db1 with tables named A,B and C[only 3 tbl]. I have another db2 with tables named D[only 1 tbl]. Now can i perform replication on db1 tbl A and db2 tbl D. Is there any tutorials for this.Thank you for all of your assitance in advance.Hoping to learn replication through all your assitance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-22 : 13:18:47
|
| Yes you can do replication from one database to another database on the same server. I don't know of any tutorials, but SQL Server Books Online is an excellent resource. You'll first need to decide which type of replication that you want to implement: Snapshot, transactional, or merge replication. Most common one used is transactional. Once you decided the type, you'll then want to decide which server will be the distributor. Typically, for performance reasons, the distributor is some other SQL Server that is not involved in the publishing or subscribing. Then you'll want to configure the distributor. Once done with that, you create the publisher then the articles. You then can push the articles to the subscriber. For details on how to do all of this, check SQL Server Books Online. You probably have it installed if you've got SQL Server server installed or just the SQL Client tools.Tara |
 |
|
|
|
|
|
How to do replication??