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 |
|
abhijittikekar
Starting Member
2 Posts |
 Posted - 2010-07-16 : 17:02:24
|
| Hi,I have a rather simple question. In Mysql, I can do show variables like '%server%' and confirm a database as a master if it's id is 1.How can I achieve this in Sql Server? Is there any query which can tell me if the database is a Master or a Slave.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
abhijittikekar
Starting Member
2 Posts |
Posted - 2010-07-17 : 14:30:08
|
| Hi,My apologies for the confusion.In MySql, a Master would be the database which would hold the original data being entered, like a Production database. Now, a slave would be the one to which the data is replicated from the master. Anything entered manually directly into the slave would break the replication. Is it similar in Sql Server too? I guess in SQL Server, we have the concept of subscriber.Thanks, |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2010-07-25 : 22:40:38
|
| Hmmm - I figure that in using Merge Replication, if anything is manually entered into the slave (subscriber) that the master (publisher) would be updated too. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
|
|
Identify Master and Slave