Comments
Sort by recent activity
Hi,
It took me a while to get to the right information and the best source I have found is here: http://www.red-gate.com/supportcenter/C ... _in_the_cl
At the simplest level you need this
"c:\Program Files\Red Gate\SQL Compare 10\SQLCompare" /db1:<source database> /s1:<source database server> /db2:<target database> /s2:<target database server> /sync
Hope this helps!
Chris / comments
Hi,
It took me a while to get to the right information and the best source I have found is here: http://www.red-gate.com/supportcenter/C ... _in_the_cl
At the simplest level you need this
"c:\Progr...
For anyone who faces this in the future, Brian was spot on - columns which were used in our project had been dropped from the source tables. Debugging will help to identify the problem columns but as the project won't open you will need to manually edit the .sqlgen (I simply removed the whole table definition). / comments
For anyone who faces this in the future, Brian was spot on - columns which were used in our project had been dropped from the source tables. Debugging will help to identify the problem columns but ...
Thanks James, looks like it is permissions.
The GUI behaves the same as the CL but if I'm using a Source database where I only have db_datareader and View Definition on schemas then I find the problem. I did notice that if I right-click on an object and attempt to View Dependencies in the Source database then no results are returned - i.e. no error message. A quick Google search comes back with this which makes sense: Requires VIEW DEFINITION permission on the database and SELECT permission on sys.sql_expression_dependencies for the database. By default, SELECT permission is granted only to members of the db_owner fixed database role.
We can work around the issue so no problem, just slightly frustrating! / comments
Thanks James, looks like it is permissions.
The GUI behaves the same as the CL but if I'm using a Source database where I only have db_datareader and View Definition on schemas then I find the prob...