I need to copy tables to other database in mssql

[nikos101]

I need to copy tables to other database in mssql

I'm using

Microsoft SQL Server Management Studio 9.00.3042.00

Do you think the following is any good or do you recommend another.

http://www.sharewareconnection.com/copy-table-for-sql-server.htm

[Sankalan]

This is OK, you have one more solution as well.

Create SQL script of the table on db1 and run on db2. It will create the same table schema on db2.

To copy date, we can use this,

SELECT * INTO db1.dbo.tablename FROM db2.dbo.tablename

Thanks

Sankalan

Mindfire Solutions

[Mark.Gregory]

Free downloads of database manipulation utilities make me a bit nervous personally.

Definitely recommend the Select into as described above. A bit more info:

http://msdn.microsoft.com/en-us/library/ms190750.aspx

http://msdn.microsoft.com/en-us/library/ms188029.aspx

[Dan_Bracuk]

If they are on the same server, and you want the data to always be the same on both db's, rather than copying, you can just use the original table for the other database.

If it's a one time copy, ask your dba to back up the table to the new db.   That's what we do with both mssql and oracle.

[nikos101]

Thanks everyone