I am trying to migrate SQL Server 2008 table records to an Oracle 11g database using the SQL Server Import and Export Wizard
. The Oracle Database is running Linux system
I did the following steps for the migration.
1. Select the SQL Database -> Right Mouse click
2. tasks - > export data
3. Choose a data source (keep the default options)
4. Click "Next" button
5. Choose a Destination: (Oracle Provider for OLE DB)
6. Select the table and click Finish Button
There are millions of records in the table, but after copying a couple of million records, SQL Server Import and Export Wizard is crashing.
Please let me know the bestion solution for requirement.