December 20, 2007 at 3:48 am
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
December 21, 2007 at 1:06 am
I have used Export Import Data utility which comes along with MSSQL and it works fine.
December 21, 2007 at 1:57 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply