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

    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
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    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
  •