Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a database file on disk called project.mdf. I want to import this into IBM DB2. How do I import this database?

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

Migrating between platforms is not always an easy task. Besides the changes in schema and SQL code, the data itself may not be an exact fit between platforms. For example, a TIMESTAMP in SQL Server is not the same as a TIMESTAMP in Oracle.

Microsoft offers the SQL Server Migration Assistant, but that is for getting data into SQL Server, not for exporting to other platforms.

The only company I know that offers tools and knowledge for migrating from SQL Server to DB2 is Ispirer. I've never used their tools however, but you may want to start with them.

HTH

share|improve this answer
add comment

You would need to do a DDL extraction (not sure how) and that you could then run against DB2.

The data you could export in CSV format and then use db2import to bring the data in. You would probably want to make note of the codepage the data is in, in case you need to do codepage conversion with the import operation.

share|improve this answer
1  
And all that assumes you run a "stupid" database. The moment you have logic in there - triggers, stored procedures - the DDL Extraction turns into a "transpose different sql dialects" nightmare. –  TomTom Oct 31 '13 at 13:43
    
@TomTom - very true. My mindset was thinking mostly about the data and the tables it resides in. –  Chris Aldrich Oct 31 '13 at 15:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.