Solved

error in exporting data from sql server2008 to oracle

Posted on 2011-09-13
4
271 Views
Last Modified: 2012-08-13
when i try to export records from sql server 2008 table(about 1300000 records) to oracle 11g  using the wizard in sql server 2008 management studio, and after exporting about 30000 records the export is stopped and get the below error :

not enough storage is available to process this command (system.drawing)
0
Comment
Question by:Balshe
  • 2
4 Comments
 
LVL 1

Author Comment

by:Balshe
ID: 36528120
Hi ,anybody here?
0
 
LVL 10

Accepted Solution

by:
sqlservr earned 250 total points
ID: 36528426
better try to send 600000 record and 6000000 records in two phases
0
 
LVL 1

Author Comment

by:Balshe
ID: 36528554
dear,
While i am using the wizard,so i think  i could not do what you advised
0
 
LVL 13

Assisted Solution

by:khairil
khairil earned 250 total points
ID: 36530043
Hi,

Instead of running the wizard directly, save it to text file first then double click to execute later. The UI use Execute Package Utility might be less demanding on hardware.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now