Ravi Shankar

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-platform backup and restore operations. The db2move command helps accomplish the movement of database tables and the db2look command helps transfer other database objects, such as triggers, indexes, sequences, constraints, buffer pools, and tablespaces. b2look command helps to capture the data d... (more)

SQL Server Data Migration Approaches

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:... (more)