Thursday, March 29, 2012

Copy local sql 05 DB to production machine

Hi SQL folks,

I've googled for this the whole yesterday and I couldn't find a complete solution.

I'm having a sql2005 database in my development machine and I need to copy all the content "Tables, Diagrams, PK columns and other data" to the remote production machine.

Using the Import/Export method didn't copied the relationships between tables, also it turned the PKs into just a standard columns

Can anyone help?

The only missing thing now is the relationships, How can I copy it?

I've copied the DB diagram but the relationships simply disapeared!

sqlsql

No comments:

Post a Comment