Oracle WorkAround

Aug 22, 2008 at 8:33 PM
Edited Aug 22, 2008 at 8:38 PM

YacGen is just for MSSQL for now, if you got a big project that uses Oracle, you can still use YacGen

But you need to make a little effort, the idea is to port temporally your DB to MSSQL

Fisrst of all download this converter:   (ORACLE TO MSSQL)
 http://www.fileheaven.com/descargar/oracle-to-mssql/31164.htm

is a trial version but migrates all the database metadata so is just rigth what we need..

Then Download the MSSQL Server Express (like 50MB)  and install it

http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&DisplayLang=en

then Just Run the migration tool...
it will ask you to set the source Oracle Server, I was able to do it with the Data definitions of windows, and to set the target MSSQL server, I was able to doit with the name of my Machine and the sid SQLEXPRESS.

machinename\SQLEXPRESS..

a few other clicks...

and Walla...

populate your dao file and use it when the time is rigth jeje

then you can delete MSSQL or something....

Hope this Help...

Regards

Marcus