Posts
Sort by recent activity
Unable To Move SQLCompare 6 To New Machine
I initially installed SQL Compare 6 on the wrong machine. Following advice from the forum, I uninstalled it and reinstalled it on a second machine. Now the second machine is being monopolized by ...
Two Requests - Save Button & Sort Order on Compare Projects
Since I serially create/edit many projects in a row, it would be nice if I could save a project without having to actually do the compare and then close the project. Currently I am forced to: 1) d...
Changing Both Servers On A Comparison Project
I wanted to create projects to compare an additional environment, so I copied the project files for the Dev to QA DB compare into a new directory. I then opened Compare Projects, switched to that ...
Application Failure When Synchronizing To Remove Schemas
I was comparing a SQL2000 SQLCompare script to a live database. The script had somehow gotten schemas. I tried to automatically synchronize from the live database to the script to remove the sch...
Application Lockup When Serially Editing Many Projects
I copied a dozen compare projects (script to a live database) to a new directory and opened the Compare Projects dialog box. I then changed directory to the one where I had just copied the project...
Mismatch Re Brackets Comparing Script To Live Database
When I script a database out to a file using SQLCompare it uses brackets around identifiers, e.g., [dbo].[StoredProcName]. However, when I compare this script to a live database, the live database...
SQL 2005 Schemas Show Up When Using Only SQL 2000
I am comparing databases and scripts using only SQL Server 2000. The scripts were made from SQL 2000 databases. Somewhere along the way I started getting the error that one side had schemas (corr...
Procs Scripted With ALTER When Scripting A Database
When scripting a database using File | Save Data Source To A File Format, SQLCompare scripts procs with ALTER so that are not equal to live databases which are scripted with CREATE.
Also, when scri...
Synchronization Scripts Use ALTER For Temporary Tables
When creating a synchronization script between a script file and a live database SQLCompare uses ALTER for temporary tables within a proc whereas it should use a CREATE. So, you may want to script...
Extra Characters At Beginning Of Generated Synchronization S
After comparing two databases I click on the Synchronization Wizard, click Next on Direction, leave Include Dependencies checked, click on Next, click on View SQL Script... and finally click on Sav...