INTERNET APPLICATION DEVELOPMENT
MID MARKET ERP DEVELOPMENT
by Sheila Zhang
Exporting data from a database quite often is requested by a line of business or for data warehouse data updating.
For simple data transfer:
You can use the SQL server import/export wizard if the data is transferred from the source to the destination “as is” without any modification.
For complex data transfers, that the source data needs to be manipulated to fit the destination, such as the ETL process (extract – transform – load), you can use SSDT (SQL Server Data Tool) to develop an SSIS solution.
The import/export wizard is straight forward. You can follow the step-by-step process to create a SSIS package.
Step 1. Select data source. It can be a file, different type of databases.
Step 2. Choose the destination. It can be a file or different type of database as well.
Step 3. Optional. You can create a new database at this point.
Step 4. Select if you want to get the data from existing data tables/views or write a query by yourself.
Step 5. Optional. If you choose to copy data from data tables/views in step 5, you can define the destination data table name and column mappings.
Step 6. It is better to select “Do not save sensitive data.”
Step 7. If you select to save the SSIS package, it will ask for the name and path to save it.
Step 8. Click Finish, the process will start immediately.
The last screen shows the processing and results.
SSDT is coming in a future blog post. If you have questions on exporting data from a database, please contact me.