Monday, July 25, 2016

EXPORT DATA FROM SQL SERVER 2014 WIZARD

EXPORT DATA FROM SQL SERVER 2014 WIZARD

Hi all,
Today i came across with different type of requirement, Sometimes we need to move/Copy our NAV data from one Database to others, OR One server to other server.
we can do also this task using "Departments -> Administration -> Application Setup -> RapidStart Services for Microsoft Dynamics NAV -> Config. Package Card.
But in this scenario, BLOB fields are not copied, Due to overcome this we have to do using SQL Server.


Run the SQL Server Import and Export Wizard to copy data between a variety of sources and destinations.
If you don't have Microsoft SQL Server installed on your computer, you can install the SQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). 
Steps for exporting table data from one server to another server database table.
Step 1:
In SQL Server Management Studio, connect to an instance of the SQL Server Database Engine, expand Databases, right-click a database, point to Tasks, and then click one of the following options [See the bellow screenshot].



Step 2:
Click NEXT Button and select the Source, See the bellow screenshot for better understanding.





NOTE:
After clicking Next button, you will get destination wizard, here you have various option to export the data.
Like: MS Excel, MS Access, Flat File destination, Sql Server e.t.c, In my demo i select SQL SERVER.



Step 3:
In this wizard select the Destination (Client, Server Name, Authentication, Database) And then click on NEXT Button,  See the bellow screenshot for better understanding.



Step 4:
Specify weather to copy one or more tables/views or to copy the results of the query from the data source.
In this wizard we have 2 options.
Option 1:             Copy data from one or more tables or views
Using this option, We can copy multiple tables/views data at a time, but in this we can't filter data.
Option 2:             Write query to specify the data to transfer
Using this option, we can filter the data, but in this option we can copy single tabale data ata time.
In my demo i used 2nd option where we can write query, And click on NEXT Button, See the bellow screenshot for better understanding.




Step 5:  Provide a source query for fetching the data from source server And then click on NEXT Button, see the bellow screenshot.



Step 6:  Select Source tables/views for mapping the data to destination.3





NOTE:
First verify the Destination Tables is selected or not, if not then, manually click and select the correct table or you can write also, Then Click on Edit Mapping, And Map your fields Source to destination, you can also skip the filed(s) that you don't want to copy, In my case, I skipped the timestamp field.
Once Mapped fields then click on OK button.
You can also verify your data by clicking on Preview [Optional].
Now Click on NEXT button, see the bellow screenshot.




Step 7:  Save and Run Package,
In this wizard we can run our query for transferring the source data to desatination.
We can also save our package for further execution or documention.
In my demo i select both option RUN & Save, you can ommit the SAVE option if you don’t want to create package.
If you selected Save option then only Save dialog will display, See the bellow screenshot for better understanding.





Click on NEXT button. A Complete the Wizard dialog box display, now click on Finish button, see the bellow screenshot.



After successfully executing the all query, A completion report will display, You can save your report,or  Email.









Popular Posts