copy table from one db to another in same server

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

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

copy table from one db to another in same server

Author

Topic

fabianus76
Posting Yak Master

191 Posts

Posted - 2005-10-15 : 06:51:00

Hello!

I would like to copy a table from one db to another db of the same SQL-Express-Server.

Thank you very much for any code for that!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

Kristen
Test

22859 Posts

Posted - 2005-10-15 : 06:55:16

SELECT *
INTO TargetDatabase.dbo.MyTable
FROM SourceDatabase.dbo.MyTable

This will not create indexes, foreign keys or the like, and it WILL copy the data, as well as creating a new table

Kristen

fabianus76
Posting Yak Master

191 Posts

Posted - 2005-10-15 : 07:08:41

Hallo Kristen!

thank you very much for this prompt reply!

This helps me a lot!

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources