How to get a script for full rebuid DB ?

Brian DonahueBrian Donahue Posts: 6,590 New member
edited February 7, 2005 1:38PM in SQL Compare Previous Versions
Hello Alex,

Thaks for posting your question. This is possible -- you can create a new, blank database on a server and compare your database to the blank one. That will cause SQL Compare to generate a script that can re-create the entire database. SQL Packager can also re-create a whole database, including the data.

Comments

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

    It certainly has been suggested before -- to drop objects and re-create them the same way that Enterprise Manager does. It would incur a big performance hit, though.
This discussion has been closed.