Linglom's blog

Export Data Wizard

On Part 1: Introduction, I mentioned about error messages when you try to restore a database from SQL Server 2008 to SQL Server 2005. You can see the first solution at Part 2: Generate SQL Server Scripts Wizard. Now let’s see the second solution to solve the problems.

On this post, you see how to export tables on ‘Northwind’ database from SQL Server 2008 to SQL Server 2005 using export data wizard.

Step-by-step

1. On Microsoft SQL Server Management Studio, connects to SQL Server 2008. Right-click on the database that you want to export data -> select Tasks -> Export Data.
   
2. On Welcome to SQL Server Import and Export Wizard, click Next.
   
3. On Choose a Data Source, select the source from which to copy data. Set Data source to SQL Server Native Client 10.0. Verify that Server name is the source of SQL Server 2008 that you want and select Database as ‘Northwind’. Click Next.
   
4. On Choose a Destination, specify where to copy data to. Set Destination to SQL Server Native Client 10.0. Type the Server name to the destination of SQL Server 2005 that you want. You can also click Refresh to verify if you can connect to the specify server name. Currently, I don’t have ‘Northwind’ database on SQL Server 2005 so I will create a new one, click New.
   
5. On Create Database, type name as ‘Northwind’ and click OK.
   
6. Back to Choose a Destination, I have created ‘Northwind’ database so select it as Database. Click Next.
   
7. On Specify Table Copy or Query, select Copy data from one or more tables or views and click Next.
   
8. On Select Sources Tables and Views, select tables that you want to export. On this example, I select all tables on ‘Northwind’ database.
   
9. On Save and Run Package, click Next.
   
10. On Complete the Wizard, you can verify the choices made in the wizard. Then, click Finish.
    
11. Wait until the wizard finishes execution.
    
12. Now I have exported tables of ‘Northwind’ database from SQL Server 2008 to SQL Server 2005 successfully.