Options

Batch Sync?

lnetzellnetzel Posts: 2
edited December 22, 2004 10:53AM in SQL Compare Previous Versions
Hi!

I'm in an enviroment where I sit on a developer SQL server 2000 database on a server.. and need to push the whole SQL structure onto several databases on another server.

Is it possible to synchronize to more than one database at the same time or do I need to compare and Synchronize for each one?

best regards/
Lars Netzel
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Lars,

    Thanks for asking. SQL Compare only works on a one-on-one basis. It can't reliable compare and synchronize multiple databases. You can save the script and run it manually on your other databases, assuming that they're exactly the same as the one you've compared against.
    · Share on Twitter
This discussion has been closed.