Ullan P
asked on
How to migrate a table data from SQL Server 2008 to Oracle 11g database?
Hi Experts,
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.
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.
Thank You
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.
Thank You
ASKER
The wizard just crashed with out showing any error message..
Earlier tried your first solution, but in my environment, the entry <supportedRuntime version="v4.0"/>. does not exist in the file.
There is one corretion : The SQL Server version is : 2005
Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Earlier tried your first solution, but in my environment, the entry <supportedRuntime version="v4.0"/>. does not exist in the file.
There is one corretion : The SQL Server version is : 2005
Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
you may need to install latest
--
what is the error you got?
\
check this solution:
Edit the file "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWiz
more
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1d04568e-283d-466c-858e-d1fe6f79a6f0/importexport-wizard-crashes-on-sql-express-2008-r2-installed-on-windows-7-32bit?forum=sqlexpress