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 |
|
paulangulo
Starting Member
3 Posts |
 Posted - 2004-05-12 : 11:56:01
|
| When I have had a go at setting up replication, I choose a table and it says "Identity Property Not Transferred to Subscribers" and it mentions creating a custom SQL script to run before the initial snapshot which creates the subscription table manually with the "Not for Replication" option. Do I have to do this for every table on the subscription database? Even doing this in a script it would be time consuming wouldn't it? Does anyone have a link to a sample script that would do this?Also, if the subscription tables haven't got any data in yet, is it possible to just go into the table properties and change the Identity to "Not for replication" that way?Apologies these seem like daft question but I am new to this game!CheersPaul. |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2004-05-12 : 17:37:26
|
| Which type of replication have you chosen? Merge, transactional, or snapshot?Also will some subscriptions get some tables and some subsriptions not get some tables?DanielSQL Server DBA |
 |
|
|
paulangulo
Starting Member
3 Posts |
Posted - 2004-05-13 : 05:04:33
|
| Well even though the subscription DB is only going to be used for failover, I was going to use Transactional as suggested by our software suppliers who said it would have less impact on system performance. But then I need to think about getting the data back to the Live db when it is available so wondered if Merge maybe more appropriate?I was going to just have one subscription getting all tables.ThanksPaul. |
|
|
|
|
|
|
Replication