Home Forums SQL Server 2005 Working with Oracle Converting Oracle DDL statments to SQL RE: Converting Oracle DDL statments to SQL

  • November 21, 2012 at 12:37 pm

    #1561379

    SQLCrazyCertified (11/21/2012)

    I need to create a sql database which works the same way in oracle....

    Basically, I have to mimic a database from Oracle to SQL server.

    I have the DDL commands from Oracle, anyone have any experince converting data from Oracle to SQL. Please advise, very urgent.

    Thanks,

    SueTons.

    you'll have to be a LOT more specific. do you want to take an existing Oracle database,and create it's equivalent in SQL server?

    There's a tool for that: SQL Server Migration Assistant for Oracle:

    www.microsoft.com/en-us/download/details.aspx?id=28766

    That will do the tables and views for you,creating the tables with teh best-matching data type equivalents.

    once it's in SQL, it's trivial to script out the objects and data.

    for all packages, procedures and functions, you will have to convert them manually...it's a +BIG+ job. some things have no equivilents, so you have to create functionalities that mimic whatever was being done instead.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!