migration from sqlserver to oracle
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: migration from sqlserver to oracle

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi friends,
    I have just migrated tables from ms sql server into oracle using MS DTS.
    I log into oracle and see all the tables but when i select from a migrated table it says table or view does not exists.

    After migration so i need to do any thing else.so that oracle recognises the MS SQL table format.please help

    cheese
    anandkl
    anandkl

  2. #2
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    I've seen something similar before. When you migrate tables with mixed case table and column names the DTS preserves the case by using "" around the definition. Since oracle tools are generally case insensitive when you type:

    SELECT * FROM my_table;

    it won't find a match. What you need to do is type:

    SELECT * FROM "My_Table";
    or
    SELECT "My_Column" FROM "My_Table";

    To solve this do the following:

    RENAME "My_Table" To my_table;

    The table reference should now be fixed. If you have columns with this problem you will have to recreate the table.

    Where I can, I force developers to always use lowercase names for tables and columns. DTS seems to deal with these OK.

    Alternatively use DTS to produce the schema creation script. Edit it manually and use this to create your schema. Once done you can use DTS to transfer the data. Not tried this second approach recently so don't quote me

    Hope this helps.

    [Edited by TimHall on 01-23-2002 at 07:48 AM]
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    thanks timhall,
    Thats was great.....thanks once again

    cheese
    anandkl
    anandkl

  4. #4
    Join Date
    Apr 2002
    Posts
    3
    HI
    Is there any easier way to migrate from MS SQL to oracle coz i have the stored procedures which use MS transaction server?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width