Featured post
sql server 2005 replication article conflict -
i have sql server 2005 database want setup replication for. problem database has 2 schemas both of have table same name in it.
for reason though tables in different schemas replication creation fails when done through management studio due conflicting article names (i assume trying create same name both tables in different schemas).
is there workaround doing in studio, can write script or program 1 thign bit annoying , wont allowed run in production.
perhaps there hot fix or i'm not aware about?
cheers,
there doesn't appear way around purely using new publication wizard in ssms - article name table name without schema-qualifier, , can't customised wizard - although there work-around if use scripting options.
go through wizard normal, @ end of process, untick "create publication" option , select "generate script file..." option.
once file created, open , edit article names no longer conflict, execute script in publication database.
- Get link
- X
- Other Apps
Comments
Post a Comment