Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server Export/Import Data From Local Database To Remote Database With MS SQL Server 2008

Export/Import Data From Local Database To Remote Database With MS SQL Server 2008

If you would like to migrate the data in a SQL Server Database from development server to production server or vice versa , there is a tool called DTSWizard which comes with SQL Server installation that import and export data between a Data Source and Destination Source.

These instructions below will show step by step on How to export data from a database to another database with SQL Server 2008.

Note: steps below are for the export data process, for import data process, the steps are the same, you just reverse the source and destination.

1. Open the SQL Server Import and Export Wizard.

Right-Click on a Database => Task => Export Data

Open DTSWizard From Database

Open DTSWizard From Database

— Or —

From Start Menu => Microsoft SQL Server 2008 R2 => Import and Export data (64-bit)

Open DTSWizard  From Start Menu

Open DTSWizard From Start Menu

— Or —

Open the wizard by finding the DTSWizard.exe executable file located on your SQL Server installation folder. It should be available at:

  • C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn
  • C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn

2. Click Next on the Welcome screen.

3. Assign database information for source includes: Server name, Username and Password if use SQL Server Authentication mode or Use Windows Authentication mode.

After that, Click Next

Assign database information for source

Assign database information for source

4. Assign database information for destination includes: Server name, Username and Password if use SQL Server Authentication mode or Use Windows Authentication mode.

After that, click Next

Assign database information for destination

Assign database information for destination

5. Select the first option: Copy data from one or more tables or views

Select Export Options

Select Export Options

Click Next

6. The next step will ensure we migrate the appropriate table data. Select on which tables you want to export.

Edit Mappings

Edit Mappings

Please make sure all desired tables are included and mapped accordingly.

Click Edit Mappings … for all tables:

Column Mapping

Column Mapping

Select “Delete rows in destination table”
And select “Enable identity insert”

Click OK

7. Repeat those steps for all tables in the transfer. Once complete click the Next button.

8. You need to select “Execute immediately”

Run Export Import

Run Export Import

Click the Next button.

The final stage of this transfer/export process will perform the task.

The tutorial is on MS SQL Server 2008, but it should be applied if you’re on MS SQL Server 2005 or even MS SQL Server 2000

Apr 19, 2011Hoan Huynh
Top Social Bookmarking Websites Support Do Follow LinkHow To Tracking Click Event With Google Analytics
You Might Also Like:
  • MSSQL Export A Table Data To CSV
  • Free Web Admin For Microsoft SQL Server And Oracle – 1ClickDBPro
  • How To Filter DataBase Name And Login Username In SQL Server Profiler
  • Save Table Structure Changes When Remote Access To SQL Server
  • Install ASP On Microsoft Windows Server 2008 IIS 7.0 and IIS 7.5
  • How To Export Google Analytics Report To PDF Or XML
  • Where MySQL Data Dir And Innodb Data Home Dir Location
  • SQL SERVER How to import Text/CSV file into table
  • ASP.NET C# Export Data To CSV And Prompt Download
  • Export Google Analytics Report To PDF In New Version
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

11 years ago SQL ServerDTSWizard, export data, import data1,086
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
24,455 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
21,836 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
17,652 views
JQuery Allow only numeric characters or only alphabet characters in textbox
14,986 views
C# Read Json From URL And Parse/Deserialize Json
11,719 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Things to Learn about Installingderm Loan Type S
  • Online Photo Editor – Free Photoediting Software
  • A Guide to Finding the Best Paper Sellers
  • Photoediting in Home Isn’t Hard to Do!

  • Free Photo Editor Online
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (27)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (647)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development