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
|
|---|