I am trying to set up transactional replication on a MS SQL 2008 database that has two Schemas, both schemas have some tables with the same names.
My first problem is actually configuring Replication on the publisher using the wizard. It fails when selecting all tables from both Schemas, even when I set it to 'Copy-file group associations'.
I get the following error for every table in Schema B that has the same name as a table in Schema A:
- SQL Server Management Studio could not create article 'Customer' Cannot create if this object represents an existing object in the server
Does anyone know why it seems to ignore the fact that the tables with the same names are in different schemas?
I have 200+ tables in both schemas and dont want to have to select each table individualy from Schema A, then Select each table from Schema B to create two publications, everytime I want to set up replication. There doesn't appear to be a way to select all tables from a specific Schema.
Any help appreciated
Thanks in advance