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 2008 Forums
 Transact-SQL (2008)
 Moving a single table from one database to another

Author  Topic 

mikeallenbrown
Yak Posting Veteran

72 Posts

Posted - 2013-09-25 : 12:01:59
How can I move a single table from one database to another ...the other database is on a different computer BTW.

Mike Brown

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-09-25 : 13:10:31
Use Import/Export Wizard. In SQL Server Management Studio, right-click on the database name (source or destination) and select tasks ->import data (or export data) and follow through the instructions of the wizard.
Go to Top of Page
   

- Advertisement -