Monday, July 25, 2016
EXPORT DATA FROM SQL SERVER 2014 WIZARD
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.
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].
Click NEXT Button and select the Source, See the bellow screenshot for better understanding.
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.
In this wizard select the Destination (Client, Server Name, Authentication, Database) And then click on NEXT Button, See the bellow screenshot for better understanding.
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
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.
Hi all, Today i came across a different type of query,where Some customers may not want to use Departments menu available. We need to h...
Walkthrough: Implementing New Workflow Events and Responses Introduction Microsoft Dynamics NAV 2016 Workflows enable you to model rea...
New Workflows added in NAV 2017 Hi All, Today i came with amazing article in NAV 2017. First of all, I would like to say t...
DATA MIGRATION IN NAV 2016 FROM NAV 2009 Hi all, Today i came across with different type of requirement, Sometimes we need to move/Cop...
Add a QR Code to a Dynamics NAV 2015/2016 in Report Header Hi All, This article will demonstrate how to add a QR Code to a NAV 2016. ...
Hi, All Today one of my client wants to Export the data from NAV to MS Word, for that i prepared documentation, you can also use, its work...
Hi All, Today I'm going to describe how you can do the bellow requirements using NAV 2016. 1. Open Outlook Application. 2. Att...
Item Unit Price Change Approval Workflow in NAV 2017 Hi All, Today, I came with amazing article in NAV 2017 i.e. Setup workflow ...
Add Users in NAV 2016 from SQL Server Hi all, Today i came across with different type of requirement...
FILTER OBJECT ID’s 👋 Hi all, Today i came across with different type of requirement, Sometimes you might be need to filter ob...