tags:

views:

120

answers:

1
Q: 

Redgate's SQLCompare Schema Comparison Not Removing or Adding Objects Via Command Line

I have a saved SQLCompare project which I use to synchronize my local database with another "master" database. When I run the project via the GUI, everything works fine. However when I run it via the command line, only objects that exist on both sides get synchronized. For example, if a column is added to or removed from a table, that change will get propagated. But if a whole table was added or removed, that change does not get propagated to my local database. Is there some way to get the command line to synchronize everything? I want my local database to match the master database exactly.

I'm running version 8.1. Here's the command line I'm using:

SQLCompare.exe /project:SynchSchemaToLocal.scp /synch /v
+2  A: 

In the UI project, make sure you have 'green ticks' in the 'include in synchronization' column for each of the groups you want to sync'.

This will ensure that all objects in that group will be included when synchronizing.

 2009-08-24 10:48:50
That seems to have been my issue. However, if there are no differences at the time the project is created, the group checkboxes are not available. If the project is saved in that state, changes are made, and then the project file is executed via the command line, the differences are not synchronized. So it seems there must be at least one difference when the project file is created so the boxes can be checked. Not quite what I would expect, but I'll proceed like this for now and see if it continues to work. Thanks.
Todd Ropog  2009-08-25 03:12:46
You're right, it's not the ideal implementation. If you have any suggestions on how you would like this to be better solved in the product we'd really appreciate it if you could send your suggestions to feedback at red-gate.com or simply use the Provide Feedback link in the product's Help menu. Thanks and kind regards, David Atkinson, Product Manager, Red Gate Software
David Atkinson  2009-10-26 13:30:16

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL