Timeline for SQL Server Replication - Can destination db have stored procedures that source db lacks?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 30, 2017 at 16:01 | vote | accept | Scott Oliver | ||
| Jan 23, 2017 at 17:19 | comment | added | db2 | To add to that slightly, be careful about creating objects (i.e. views or functions) with the SCHEMABINDING option. This can prevent the subscriber table from being dropped and recreated when reinitializing the subscription. Your options there are to either drop and recreate the schema-bound objects, or tweak the publication options to reinitialize without dropping (which may not work if you're pushing schema changes to the subscriber). | |
| Jan 23, 2017 at 15:47 | history | answered | Nic | CC BY-SA 3.0 |