Ravi Shankar

SQL Server integration Services (SSIS) is the de-facto standard for data migration and ETL (Extract, Transform and Load) operations in the Microsoft BI suite of technologies. Nevertheless, SQL Stored Procedures are still the preferred choice in some of the applications for carrying out data migration activities like loading a delimited flat file into a SQL Server table. Teams involved in data migration activities with SQL Server Suite often come across the requirement of importing data from flat files. The initial Research and Development phase emphasizes two of common approaches: Import data using SSIS Packages. Import data using custom SQL Stored Procedures. Each of approach has its pros and cons and should be properly evaluated to ensure the most appropriate one is selected for the in-hand requirements during the analysis phase. Incorrect decisions taken initially ... (more)

Cross-Platform Data Migration

SOA & WOA Magazine This article provides a step-by-step approach to cloning the DB2 Universal Database (DB2 UDB) across platforms and describes the usage of DB2 utilities that help to accomplish the task. There is no direct support in DB2 UDB for cross-platform backup and restore operations. It means one cannot simply take a backup of your DB2 UDB running on the Windows operating system and restore it to DB2 UDB running on the Linux operating system. This simple restore operation will not work across platforms. The two DB2 utilities db2move and db2look can be used for cross-pla... (more)