Data transformation processes data by cleaning and transforming them into a proper storage format/structure for the purposes of querying and analysis.Data extraction involves extracting data from homogeneous or heterogeneous sources.The ETL process is often used in data warehousing. When you are finished with the report, click Close.According to Wikipedia, “Extract, Transform, Load (ETL) is the general procedure of copying data from one or more data sources into a destination system which represents the data differently from the source(s). If any data did not migrate, click the row that contains the errors, and then click Details. When the migration is complete, the Data Migration Report appears. For more information on connecting to SQL Server, see Connecting to SQL Server For more information on connecting to DB2, see Connecting to DB2 Database (DB2ToSQL)įor connecting to the target database SQL Server, enter the connection credentials in the Connect to SQL Server dialog box, and click Connect.

In the Connect to DB2 dialog box, enter the connection credentials, and then click Connect.

You can also migrate data for individual objects or categories of objects: Right-click the object or its parent folder select the Migrate Data option. Right-click Schemas in DB2 Metadata Explorer, and then click Migrate Data. To migrate data or omit individual tables, first expand the schema, expand Tables, and then select or clear the check box next to the table. To migrate data for all schemas, select the check box next to Schemas. In DB2 Metadata Explorer, select the objects that contain the data that you want to migrate: You have synchronized the converted objects with the SQL Server database.

The DB2 providers are installed on the computer that is running SSMA. Otherwise, from the View menu, select Output. To view migration messages, make sure that the Output pane is visible. The number of rows loaded into SQL Server in each transaction is configured in the project settings. Migrating data is a bulk-load operation that moves rows of data from DB2 tables into SQL Server tables in transactions. The Client-Side Data Migration Engine resides inside the SSMA application and is, therefore, not dependent on the availability of the extension pack.

Downloading a db2 table to a flat file