Import one SQL Database into another

In this article we’ll learn how to “Import one SQL Database into another”. To start the SQL Server Import and Export Wizard using SSMS, go to Object Explorer, right click on a database for which want to export or import data; from the context menu under the Task sub-menu, choose the Import Data or Export Data option:

Import one SQL Database into another

Once you’ll click on “Import Data” Following screen will appear to you. Here you need to select following

Source Database configurations:

Please follow below instructions for Source database

Import one SQL Database into another
  • “Data Source” options (as shown in below image). 
  • Server Name which you want to connect.
  • SQL authentication – pass Username and password.
  • Select the source database name from which you want to import the data.
  • Now click the Next button.

Destination Database configurations:

Please follow below instructions for Destination database

Import one SQL Database into another
  • “Data Source” options (as shown in below image). 
  • Server Name which have destination DB.
  • SQL authentication – pass Username and password.
  • Select the destination database name in which you want whole data.
  • Now click the Next button.

On next following screen will appear which have following two options.

  • Select first option which import data to destination DB.
  • Second’s option is for creating the Scripts.
Import one SQL Database into another

On click on NEXT button of above screen following will appear where you need to select the Tables/ views etc. whose data you want to import. 

Import one SQL Database into another

Select the required tables name and click next. Following window will appear where you can select “Run Immediately” and click on Next button in below screen.

Import one SQL Database into another

Above Screen will give brief information of what data will get imported. Click FINISH and you will see below screen which shows status against each database object.

Import one SQL Database into another

Click Close and you are done with IMPORT of data.

Now check your destination DB you will see the tables and view which you have selected to import.

Below in destination DB I can see table and views which I have selected to import in to this DB.

Import one SQL Database into another

I hope with this article you got information that how you can import data from one DB to another using SQL.

Import one SQL Database into another

I hope with the article you’ll get understanding of how to import/export the SQL Database into another. For additional information you can refer link HERE

For more knowledge of MS SQL, you can check this section HERE

Posted in SQL

Leave a Reply

Your email address will not be published. Required fields are marked *