SQL script to oracle

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  December 20, 2007 at 3:48 am

  #182153

  Does anyone know of any methods in which you can convert a sql script (create table) into oracle syntax?

  I am looking at replicating a few tables accross to Oracle and the replication fails trying to create the table, but doing them manually means going through each table and converting it manually, i was just hoping there was an easier method

  Thanks

  John

• Sanjay Pandey-195693

  Valued Member

  Points: 68

  More actions

  December 21, 2007 at 1:06 am

  #761992

  I have used Export Import Data utility which comes along with MSSQL and it works fine.

• majorbloodnock

  SSCrazy Eights

  Points: 9389

  More actions

  December 21, 2007 at 1:57 am

  #762004

  Depends how much it's worth to you, John. There is a product called SwisSQL (http://www.swissql.com/products/sql-translator/sql-converter.html) that will do what you want. It's shareware, but full license is just shy of $400, so might not be worth it for just a few tables. However, if it's a regular thing, it may well be something to look at. I've not used it, so can't vouch for its accuracy personally.

  Semper in excretia, suus solum profundum variat