Compares and synchronizes SQL Server databases, backups and scripts.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong
I am usually use red gate for comparing data and database schema. But I need to synchronise database (schema and the data). both the database are in replication. Every time I want to synchronise, it give me error with an stored procedure. but the stored procedure does not need to synchronise as it is already matching. Can you please help me in this case?
Thansk & Regards
MS SQL Database Administrator
- Posts: 1
- Joined: Fri Feb 24, 2012 1:22 pm
- Location: London
I can't say specifically what the problem is with the stored procedure because there is no information here about the error or anything, but in general, SQL Compare is not able to synchronize replicated databases because it does not detect that columns are participating in replication and script an sp_dropreplcomumn rather than an ALTER TABLE. Sometimes you can get it to work in certain circumstances.
- Posts: 6670
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests