Activity overview
Latest activity by commcare
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 ...
I now also realize that my problem with comparing scripts having CREATE vs ALTER has to do with how the scripts were generated. If I export the database structure I get CREATE. If I tell SQLCompare to synchronize a live database to a script and then copy the file generated, I get ALTER. Sorry, if this was obvious. / comments
I now also realize that my problem with comparing scripts having CREATE vs ALTER has to do with how the scripts were generated. If I export the database structure I get CREATE. If I tell SQLCompa...
I have since discovered that the file scripted out by SQLCompare does not have the double parentheses. Rather, they show up when SQLCompare reads the file in to compare it to a live database. While this happens consistently for individual databases, it does not happen with all databases. Also, I am still having the problem that single and double parentheses do not compare as the same, even when these are the only errors listed by the Compare Project. Currently this forces me to check quite a few files for mismatches if I want to be sure the script and the database actually compare as equal. / comments
I have since discovered that the file scripted out by SQLCompare does not have the double parentheses. Rather, they show up when SQLCompare reads the file in to compare it to a live database. Whi...
We only use Windows users. I copied the scripts outside of SQLCompare using Explorer while SQLCompare was not running. / comments
We only use Windows users. I copied the scripts outside of SQLCompare using Explorer while SQLCompare was not running.
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...