Moving tables & diagrams to different dB

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Moving tables & diagrams to different dB

Author

Topic

jojo13
Starting Member

3 Posts

Posted - 2007-12-31 : 16:48:34

HELLO
I need to know how can I move my tables and diagrams(from a database) to different database. Any suggestion will appritiated
Many thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-12-31 : 17:12:45

Backup/restore

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-12-31 : 22:44:17

In case you want to keep existing objects in target db, you can copy tables with data import/export wizard or bcp or t-sql statement but can't copy diagrams.

sqlsquirrel
Starting Member

21 Posts

Posted - 2008-01-02 : 13:49:37

More specifically if you are using SQL Server 2000 then DTS or SQL Server 2005 then SSIS to move your tables. If you are using SQL Server 2000 copy over the dtproperties table. That contains the information for your DB diagrams.

Brett Davis
Senior SQL Server DBA
For more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/

m_casamayor
Starting Member

8 Posts

Posted - 2008-01-02 : 13:54:49

Maybe you don't need those diagrams if you have dynamic and browseable diagrams with Nautilus (http://sourceforge.net/projects/nautilus/)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources