Re: migrating tables from Oracle to Sybase

aptime (aptime_at_imaginet.fr) wrote:
: I'd like to migrate data from Oracle 7.3 to Sybase System 11.
: Does anyone know what tool would be the most accurate ?
:
: I've tried "bcp" (Sybase), "Infomaker" (Powersoft/Sybase), "defncopy"
: (Sybase),
: and "Data Manager" (Oracle), but so far I have not succeeded.
: Maybe I don't use these tools the proper way. Usually I've got ODBC
: errors, or
: file formats that are not recognised by one of the 2 DBMS.

I don't know of any tools -- I'm sure there are some, I'm just not familiar with them. :-)

But of the utilities you mentioned, you should be able to do what you need. To unload data from Oracle, you have to use SELECT statements and spool the output to a file. That would give you ASCII files that could, then, be loaded into Sybase using bcp. You need documentation on bcp which you can find in the Utilities Manual. If you don't have access to the documentation, it's available on-line at http://sybooks.sybase.com/cgi-bin/nph-dynaweb Section 1 has a short write-up on basic syntax. Chapter 2 explains how to use format files, etc.

But before you can load the data, you need to recreate your tables. Do you have those scripts available so you can rewrite them if necessary? You might be able to use a CASE tool like ER-win or System Architect to reverse engineer your Oracle schema and then convert it to Sybase syntax. I know they reverse engineer, but I'm not sure if they can help you with the conversion part. But, if you don't have the scripts that were used to create your Oracle objects, it could save you a lot of typing and investigating.

defncopy is a utility to load and unload SQL code for stored procedures in a Sybase environment. If you have procedures and/or packages in Oracle that you want to migrate, you will probably have to just endure the process of porting the code -- rewriting them.

				Good luck,
				Teresa Larson

     _________________________________________________________________
    /  Teresa A. Larson                 http://www2.ari.net/jmasino/ /
   /  Group 1 Software                        Voice: (301) 918-0896 /
  /  4200 Parliament Place, Ste 600                tlarson_at_ari.net /
 /  Lanham, MD 20706-1844                    teresa_larson_at_g1.com /
/________________________________________________________________/
                      #include <std_disclaimer>