Introduction:

In this article we will explain how to copy data with database structure from another database in sql server with example step by step.

Description:

Several times, we need to copy SQL Server table schema and data from one database

to another database. In this tip, I show how to do this using wizard in SQL Server.

Step 1: create a database using query like as below.

CREATE DATABASE Articles

Step 2: Right-click on the database name, then select "Tasks" > "Export data..." from                  the object explorer.

How to copy tables from one database to another in SQL Server


Step 3: Provide authentication and select the source from which you want to copy the data; click "Next"

 

 How to copy tables from one database to another in SQL Server

Step 4: Provide authentication and select the database where you want to copy the

 data; click "Next"

How to copy tables from one database to another in SQL Server

Step 5: Copy data from one or more tables or view; click "Next"

 How to copy tables from one database to another in SQL Server

Step 6: select table which you want to copy; click "Next"

 How to copy tables from one database to another in SQL Server

Step 7: select Run immediately; click "Next"

 How to copy tables from one database to another in SQL Server

Step 8: click "Finish"

 How to copy tables from one database to another in SQL Server

Step 9: click "Close"

 How to copy tables from one database to another in SQL Server

Now see below fig UserProfile table copy.

 How to copy tables from one database to another in SQL Server


I hope it will help to you.

0 comments


Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.

you may also like