0
I created a diagram on sql-server, where it automatically creates the entire database structure, only that I will have to migrate to Oracle.
I can migrate the whole structure (tables, Fks, Pks, etc.) with some tool?
Note. 1: There is no data yet in the tables.
Note. 2: I am using sql-server-2008 and the oracle-11g.
2
There is the Microsoft SQL Server Migration Assistant for Oracle that can help you. It lists the objects that can be migrated natively and possible errors. Some items like encrypted objects it does not perform reading.
0
Oracle has a migration guide with videos and textual instructions where all the steps to migration are explained:
http://www.oracle.com/technetwork/database/migration/sqlserver-095136.html
Browser other questions tagged sql sql-server oracle
You are not signed in. Login or sign up in order to post.
Are you currently worried about migrating only the database, correct (from SQL Server p/ Oracle)? That is, taking objects from one side to the other. Applications that use SQL Server and will use Oracle are part of this migration?
– humungs
There are also other tools that make this service as for example fullcopyconvert.
– user18771
Although the post is a little old I will leave my contribution. There is Fullcopyconvert, follow the link to download. www.fullcopyconvert.com.br/download
– Eber