http://www.perlmonks.org?node_id=419620


in reply to SQL table recreation

You need a SQL solution.

You can "script object to..." in Query Analyzer and Enterprise Manager.

You can also BCP data out and back in.

And from the command line...

...\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s server /d database /P password /f textfile