Thread: [Squirrel-sql-users] Can SQuirreL be used to export a relatively large resultset (for a desktop)?
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: KARR, D. (ATTCINW) <dk...@at...> - 2009-08-28 19:48:54
|
I have a Teradata table with over 900k rows that I need to import into Oracle. Would SQuirreL have any trouble getting this done? I can see the various pieces are available, but I'm not sure how memory-efficiently this gets done. Would I have to increase the maxmem for this? I'm running on Windows, so I can't get much more than about 1536m (I could probably squeeze more, but I usually stop there for safety). |
From: Robert M. <rob...@gm...> - 2009-08-29 02:12:36
|
If you are referring to DBCopy plugin (that is, "Copy table" / "Paste table"), there are probably several configurations you would be interested in. The "ResultSet fetch size" controls how many records are loaded into memory at one time. If you have large BLOBs, then there is also setting to use a file buffer instead of memory. These are both located in the "DB Copy" tab in Global Preferences. Rob On Fri, Aug 28, 2009 at 3:48 PM, KARR, DAVID (ATTCINW)<dk...@at...> wrote: > I have a Teradata table with over 900k rows that I need to import into > Oracle. Would SQuirreL have any trouble getting this done? I can see > the various pieces are available, but I'm not sure how > memory-efficiently this gets done. Would I have to increase the maxmem > for this? I'm running on Windows, so I can't get much more than about > 1536m (I could probably squeeze more, but I usually stop there for > safety). > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |