Post reply

Moving Oracle tables to SQL Server

  • July 29, 2006 at 3:35 am

    #67772

    Hi,

    I'm about to enter a project where I need to move an ASP app with its db on an Oracle platform to SQL Server.

    Is there an easy way to move the Oracle table objects to SQL Server?

    Moving the data is fine its just that I don't want to create lots of tables manually.

    Any tips welcome.

    Thanks in advance,

    Eamon

  • July 31, 2006 at 2:47 pm

    #652469

    Tables and data are doable through DTS import/export.  Essentially your data source would be Microsoft Oracle OBDC and your destination SQL Server.   Choose the tables you want to copy and let her rip.

    The real work will be the other object types:  Triggers, views, indexes, stored procs, functions, etc.   I believe there are tools out there for doing such a conversion but i have no experience in this.

    Is this an vendor supplied system or something custom?   If it is a standard system you should be able to get the schema and object creation scripts through the vendor.  I leveraged these in an oracle to SQL conversion for DOCSOPEN.   Essentially i created a shell schema and then used sql tools to transfer the data.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply