Posts
Sort by recent activity
Can't generate insert scripts without Primary Key
Hi,
I'm trying to generate insert scripts for a database. I need to run the script across the live servers. The way I have done it is to create an empty table on a test database, then compare the...
SQLCompare when sychronising is not copying over case
We have an sproc which fails on the server because the sproc is in mixed case. I can see that our scripts folder has the sproc in all upper case. However after sync has completed, if I check the ...
SQLCompare is hanging on 'Getting latest version of db'
Hi,
I am having a problem with SQL Compare. When I do a database comparision with my SQL scripts folder, the SQL compare process dialog pops-up and hangs on the 1st 'Getting latest version of datab...
Changeset doesn't pop-up after db sync
Hi,
I don't know if something has changed with my setup, but I used to have SQL changeset pop-up automatically when I synced to my database scripts folder. The folder is registered with ChangeSet,...
How to change primary key column in database and preserve da
Hi,
I'm having trouble after some substantial re-factoring work to our database schema. I've had change the primary key column on about 10 tables. When I run the SQL Compare I get high warnings o...
Compare brings up View objects as different but are the same
I've just ran an SQL Compare against a SQL Scripts folder.
I've noticed that a VIEW object has been identified as different. However when I click on the view object, in the differences pane there ...
Does SQL Compare compare Database Views?
Hi,
I currently am using the evaluation version of SQL Compare.
However it doesn't seem to be comparing Views between both database. I would expect to see views either in the differences pane or eq...