Lowell (11/21/2012)

---

SQLCrazyCertified (11/21/2012)

---

I need to create a sql database which works the same way in oracle....

Basically, I have to mimic a database from Oracle to SQL server.

I have the DDL commands from Oracle, anyone have any experince converting data from Oracle to SQL. Please advise, very urgent.

Thanks,

SueTons.

you'll have to be a LOT more specific. do you want to take an existing Oracle database,and create it's equivalent in SQL server?

There's a tool for that: SQL Server Migration Assistant for Oracle:

www.microsoft.com/en-us/download/details.aspx?id=28766

That will do the tables and views for you,creating the tables with teh best-matching data type equivalents.

once it's in SQL, it's trivial to script out the objects and data.

for all packages, procedures and functions, you will have to convert them manually...it's a +BIG+ job. some things have no equivilents, so you have to create functionalities that mimic whatever was being done instead.