Link to home
Create AccountLog in
Avatar of hazemfadl
hazemfadlFlag for Egypt

asked on

Convert oracle database to MSSQL database

Hello,

I have an Oracle database and I need to conniver it to MMSQL database.

Any suggested software or techniques to active this goal???

Thank you
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Looks like MSoft provides an assistant for this:
http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx
You cannot convert the database from Oracle to MSSQL as such, hope you are aware.

There are tools in market which help you to convert Oracle objects to MSSQL objects and migrate data from one db to other db (that includes heterogenous sources)

one of them is swisssql http://www.swissql.com/

HTH

Avatar of hazemfadl

ASKER

Than u for quick reply ...

Do you have another software rather than SSMA?
As ajexpert mentioned there are a few.  I've only ever been around SSMA and never personally used it.  Google around.   I'm sure you'll find many.

Are you just migrating data or will you need to port/convert stored procedures/constraints/???
Yes,

I need to migrate all database objects.

ASKER CERTIFIED SOLUTION
Avatar of hazemfadl
hazemfadl
Flag of Egypt image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
No on gave me solution