Activity overview
Latest activity by ChrisGodfree
Column mapping problem
Hi,
We have come across a problem in the way SQL Compare maps columns which are being renamed which has resulted in data being moved to the wrong fields:
CREATE TABLE [dbo].[Old_Table_Structure]
(
...
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 ...
The given key was not present in the dictionary
I have suddenly started to get the error message "The given key was not present in the dictionary" when opening existing .sqlgen projects. I have looked at the log files but they don't show any err...
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...
How does SQL Compare work out dependency order?
Facing a strange problem when deploying database changes that we cannot figure out. We successfully deployed a number of database changes to production earlier this week. Among the change were two ...
Releasing from Source Control
Due to the restricted access we have to update our UAT and Production servers (by policy we have 'near to' db_owner rights) we cannot execute the SQL statements which add database-level extended pr...