New feature idea

DanAvniDanAvni Posts: 65 Bronze 2
edited April 21, 2007 12:24AM in SQL Compare Previous Versions
from time to time i come across the need to compare my Dev DB to a DB on a production server i have very little access to. in some cases the Production server DB is huge and taking a backup to the Dev server for comparison is irrational. since i have a license for SQL Compare on the Dev platform, i think there should be some free utility that i can run on the production server that will only take a snapshot of the SQL structure. i will then move this snapshot to the dev server and compare my dev DB to the production DB easily.
Dan Avni


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Dan,

    This is possible -- if you have a professional edition licence for SQL Compare, you can distribute the command-line version to your clients after it has been activated on your computer (the distribution instructions are in the command-line help file). If you distribute the proper files and a batch command to run SQLCompare.exe to the client, you can use the /makesnapshot switch to create a snapshot file that they can then email back to you so you can compare the snapshot against your on-site reference database.
  • DanAvniDanAvni Posts: 65 Bronze 2

    if i understand you correctly then the client will not need any activation? if this is the case then i am going to upgrade to the pro version.

    Dan Avni
Sign In or Register to comment.