Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Stalybridge, Manchester

    Unanswered: Scripting Oracle into SQL Server

    I have been given a couple of text files containing

    A. Primary & Foreign Key scripts
    B. Oracle Tables scripts

    Is there anyway I can use these and recreate the database in SQL Server?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Not directly. It will take some serious updating. Especially around numeric data. Numeric can be changed to Int, but numeric(10, 2) would remain numeric (10, 2). Varchar2 would become varchar or nvarchar, depending on whether you have international character data. Tablespace clauses would have to be replaced by filegroup clauses.

    In short, it will take some time, and a number of tries to get it just right.

Posting Permissions

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