Hi Anand,
Assuming that you are satisfied with your existing table structures
all you have to do is:
- For each existing table create a delimited or fixed length file.
(Just do whichever is easier for you.)
- Use a utility program of some kind that can produce table
descriptions and write them out to a file. (One for Xbase and one for
SQL Server.)
- Edit the table descriptions and convert them into Oracle CREATE TABLE
and CREATE INDEX statements. (After I finish editing I like to divide
this file up and create one file per TABLE. My naming convention is to
use the table name with a .sql extension so that I can run them from
interactive SQL in step 5.)
- Copy the files you edited in step three and edit the copies to form
Oracle SQL Loader control files. In order to prevent confusion use the
naming convention filename.ctl.
- Fire up Oracle log into interactive SQL as the table owner and run
the scripts you created in step 3. (The command is @filename or, if
you prefer, START filename.)
- After cleaining up any errors start loading your tables with the
loader. Assuming you are on an NT fire up an MS-DOS session and
just issue the command SQLLDR user/password control=filename.ctl
- Save off both the .sql files used to create your tables and indexes
and the .ctl files used by the loader so that you will have them if you
decide to reorganize your database after you gain more experience with
Oracle.
Regards
Jerry
Anand K. Anumolu wrote:
>
> Hi All:
>
> I was asked to help migrate MS-SQL Serverdatabase and XBASE data to
> Oracle8 in Windows NT 4.0 environment. Can somebody outline what is
> involved, specifically how to migrate the data to Oracle8.
>
> Please respond to ananda_at_mcs.com
> Thanks
>
> --Anand
Received on Sat Feb 14 1998 - 00:00:00 CST