Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: COnvert Sqlserver Script to Oracle Script

    Hi,

    Can anyone plz let me know any link or free software to convert my sqlserver script or database to oracle script or database?

    I want all my constraints, Identity columns should be in the generated script.


    Thanks in advance...

    Mahesh....

  2. #2
    Join Date
    Feb 2009
    Posts
    62
    Oracle's SQL Developer comes with a migration suite to migrate from SQL Server to Oracle.

    This includes a script translation tool that supports T-SQL to PL/SQL, but I've never used it, and can't vouch for it's efficacy.

  3. #3
    Join Date
    Sep 2009
    Posts
    2
    Hi,
    Thanks for the reply,

    But i am not able to find that option in Oracle Developer....
    Can you please send me snapshot or any shortcut?


    THanks
    Mahesh.....

  4. #4
    Join Date
    Aug 2009
    Posts
    1

    Re:

    We will choose Oracle from the source database engines list. We can connect to our Oracle in two ways. If we have Oracle Client installed, simply typing the service name and specifying login info is all we need. However, when you don't want to install 100MB+ of OCI installation, we have a nice surprise! We can connect to Oracle using a direct TCP/IP connection. No OCI required. In addition to database name and login info, we would just need to specify server name or IP - and done.

Posting Permissions

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