What are the challenges you face when working across database platforms? Take the survey

Feature Request: Standalone Snapshot Tool

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 25, 2005 9:55AM in SQL Compare Previous Versions
Hi Fred,

That's a good suggestion. It would also be easy to write a small command
line utility to create snapshots if you've got a Toolkit licence already. We
might do some 'spin-off' projects based on Toolkit in the near future for
very specific tasks like these.


Brian Donahue
Red Gate Technical Support

"Fred" <No@Thanks.com> wrote in message news:81dY8VT4DHA.1600@server53...
> Can't you just create an empty database? Script the production DB against
> this one will give you the 'snapshot script'. Create an empty database on
> your dev-server, run the script et voila...Not as easy as a stand alone
> tool, but it saves you another tool (I'm referring to the learning curve,
> not the money ;-)
> Gtx,
> Fred
> "Alec" <nospamme@nospam.com> wrote in message
> news:IdUZpGu3DHA.1600@server53...
> > Often times, for security reasons, we cannot directly link between a
> > development SQL Server and a production SQL server. It would be great
> > there was a small stand-alone tool that just created snapshots that we
> could
> > install on the real servers to get a snapshot of the schema and then
> compare
> > on our dev server.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    This is now possible without writing your own application using the command-line version of SQL Compare. The program will allow you to create a snapshot at a remote location and save it to a file. The licensing would allso allow you to run the command-line utility on two machines without purchasing an additional licence.
This discussion has been closed.