This content has been marked as final. Show 9 replies
SQL Developer can migrate from Microsoft SQL Server 7.0, 2000, 2005, but, unfortunately, SQL Developer is unable to hande the migration
from SQL Server 2008.
Support for SQL Server 2008 is already planned for a future version, but no date has been yet published.
To migrate your SQL Server database, you will have first to export it and import in a lower, supported version.
That really doesn't soun like much of a migration .. it sounds more like a periodic transfer of data. A migration would imply leaving one databse inorder to start using another.
The short answer to your question is no. It is not the design of SDMWB to migrate automaitcally (assume you mean like a periodic job). It would require a manual launch on the migration.
If you want to move data from SQL Server every so often you can, you will just need to manually interface with SQL Developer.
It always better to open a new thread than add to an older one, as it easy to miss.
To migrate from SQL*Server 2005 you can use the SQL*Developer migration workbench.
Full information, documentation, examples are available from these sites -
SQL*Developer main site -
Oracle SQL Developer Migrations: Getting Started -
Oracle Database Migration Technology -
Migrating from Microsoft SQL Server to Oracle -