As the title goes how can i transfer a table from one DB to another
but first i need to delete the table1 from DB1 coz table2 from DB2 has the same
name as table1...

7 Years
Discussion Span
Last Post by lttleastig

There are probably around 100 ways to do this.

If you are new to SQL Server, the easiest way will probably be the export data task.

From the Management Studio, right click on the database of the source table. Hover over "Tasks" and then select "Export Data..." Follow the instructions.

Post back if you have any issues.

Edited by buddylee17: n/a


ok followed steps now it says copy all tables or write a query to specify data to transfer what kind of query do i need to just copy one table?


Select "Copy data from one or more tables or views". On the next screen, click the checkbox for the table that you want to export. Also, verify that the destination table is correct.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.