Resource icon

How to import and export SQL server database?

How to import and export SQL server database?

To start the SQL server import and export wizard there are many ways to configure. In this article, let us see how to start in four ways such as
  • SQL server management studio
  • Start menu
  • Visual studio with SQL server data tools
  • Command prompt

  • SQL server management studio:
It is one of the most common method to start SQL server import and export wizard.
Step 1: Firstly, we need the connectivity of SQL database engine. So, get the connectivity with proper access.
Step 2:Secondly, we need to extend the database and from that choose which database will be processed properly.
Step 3: Just right click on it and then it shows the list of options. Choose the option task and from that it opens another menu.
Step 4: Below the screen, you have two choices import data and export data.
import1.png


Just click on it. It will automatically start the work.
  • Start menu:
Step 1:Click on the start menu, and type Microsoft SQL Server 2016.
Step 2: You will get two choices such as
  • SQL server 2016 import and export data (32-bit)
  • SQL server 2016 import and export data (64-bit)
You can use 64 bit until your system realizes 32 bit is needed
  • Visual studio:
Step 1: When you access visual studio simultaneously we need SQL server data tools too
Step 2: These two services helps to form integration services. On the top of the screen, the menus are listed horizontally.
Step 3: Choose the menu project and so, you will get the drop down list showing the first option as SSIS import and export wizard.
import2.jpg


Step 4: There is another option just search for the solution explorertab and right click on the SSIS packages.
Step 5: Now, you will get the option as SSIS import and export wizard
  • Command prompt:
Step 1: Open the command prompt and type the command as DTSWizard.exe
Step 2:
You will get two commands such as
  • C:\Program files (x86)\Microsoft SQL Server\130\DTS\Binn – This is for 32 bit
  • C:\Program files \Microsoft SQL Server\130\DTS\Binn – This is for 64 bit
Author
bhawanisingh
Views
2,732
First release
Last update
Rating
0.00 star(s) 0 ratings
Top