How to get a script for full rebuid DB ?
Brian Donahue
Posts: 6,590 Bronze 1
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.
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.
This discussion has been closed.
Comments
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.