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...
lttleastig 4 Junior Poster in Training
buddylee17 216 Practically a Master Poster
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.
lttleastig 4 Junior Poster in Training
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?
buddylee17 216 Practically a Master Poster
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.
lttleastig 4 Junior Poster in Training
Thank you verry much solved my prob
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.