Home Forums SQL Server 2005 Administering script out a database (fully functional create script) ?? RE: script out a database (fully functional create script) ??

  • You could use a modeling tool like CA Erwin Data Modeler, or PowerDesigner DataArchitect. Both will let you reverse engineer your database and generate scripts. You can download a fully functional trial of either one (or both) if it's a one time deal. I use DataArchitect on an almost daily basis and have been quite pleased with it. It also lets you compare two schemas, and generate scripts to make them the same. They aren't cheap, however.

    If you're on a budget, and are familiar with Linux there is a free modeling tool you can use (sorry, the name escapes me). I had it loaded on Ubuntu at one time, but never used it.