Extracting data

[tonisyb]

I need to extract about 800 tables from a sybase system 11 database to DB2. How do I go about doing this without having to extract each table separately.

Thanks

 

[grega]

What platform are you running on? Unix/Windows? Are you planning to use bcp to extract the tables?

Greg.

 

[qyllr]

hello,

you can do a database dump if the database consists of the 800 tables you mentioned... if you are picking and choosing you have to bcp it out individually... create the individual schemas in DB2 then use DB2 bulk copy version to load the tables...or use DB2's rendition of a load database...

the best thing to do is to consult the migration strategies written by sybase...

you can find this in

http://www.sybase.com

or check out the DB2 sites for recommendations...

hth,
q.

 

[tonisyb]

thanks for the advice....i actually dont know where to start....how do I dump the Sybase database in order to be able to load it into DB2?

thanks

 

[grega]

Have a look here. May be some useful info or links.

http://www-3.ibm.com/software/data/db2/migration/

Greg.