Search code examples
sqlsql-serversql-server-2005smodts

How to transfer SQL Server DB structure to another server

Tell me please what's the best way to copy db structure to another server?

I'm trying to generate a script in Management Studio and then run that script on the remote machine. And I hate that thing. It works unpredictable, you have to fix manually a lot of crap in the generated script. I guess that isn't the best solution.

Then I tried to generate SSIS package with DTSWizard.exe but I know nothing about that stuff, and I couldn't find a way to copy only the structure without data.

Maybe there is a way somehow to break entire db structure into smaller pieces and work with them - first do all the tables, then views, then functions etc.

Or there is another, normal way to do that without so much headache?

Solution

  • Try SQL Examiner Suite: http://www.sqlaccessories.com/SQL_Examiner_Suite/ - you can copy both schema and data with this tool