March 20, 2012 at 9:12 am
Hi,
I am working a Oracle to SQL Server 2008 (know this is forum is for 2k5..did not see a replicaiton 2k8 thread) replication build and have a question about custom schemas. The source databases are multiple instances of he same schema (one db for each location) and we want all of the data in one SQL Server database logically grouped by different schemas like show below.
Database.Schema1.table1
Database.Schmaa1.table2
Database.Schema2.table1
Database.Schmaa2.table2
When the publication is created and subscription is initialized the tables are assigned to the .dbo schema by default
Database.dbo.table1
Database.dbo.table2
That can be changed by a simple ALTER statement to Database.Schema1.table1…that is not the problem. BUT, when the subscription is reinitialized, its changes the alter schema name of Database.Schema1.table1 back to Database.dbo.table1
This is a problem because the source systems have the same table name.
Does anybody know of a way to change the publication or subscription properties to force it to always write to the custom schema of Database.Schema1.table1 and will remain that way even after a re-initialization and snapshot rebuild?
I know I can make separate databases for each source databases, but I want to know if there is a way to do it in one database and using schemas to group them.
Thanks
March 20, 2012 at 11:29 am
Doh....you have change the article properties for each table, article level changes get reverted....
Thanks anyway!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply