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

How to get a script for full rebuid DB ?

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
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.


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.