I think what I'd do is project a temporary table, do the "unload all /
noschema" on the temp table, run the file in the new database, and then append
to the permanent table
Hmm, this sounds like a winner. I have tooling that dumps each file into a
separate DAT file. If I first PROJECT the temp table, dump that table into the
DAT file, and add an APPEND command to the end of that file then I should be
able to load the data into my new database reliably. In addition to columns
added to the end of the table I could handle changes in ordering and columns
missing from the middle of the table as well. It would fail on columns that
have changed names, but we never do that.
Thanks, I'm going to update my tooling to try it this way.--Larry#yiv4756229982
#yiv4756229982AOLMsgPart_2_a2621ceb-1931-41ee-af27-1d1d010a4f37
td{color:black;} _filtered #yiv4756229982 {panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered #yiv4756229982 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}
_filtered #yiv4756229982 {font-family:Garamond;panose-1:2 2 4 4 3 3 1 1 8
3;}#yiv4756229982 .yiv4756229982aolReplacedBody
p.yiv4756229982aolmail_MsoNormal, #yiv4756229982 .yiv4756229982aolReplacedBody
li.yiv4756229982aolmail_MsoNormal, #yiv4756229982 .yiv4756229982aolReplacedBody
div.yiv4756229982aolmail_MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv4756229982
.yiv4756229982aolReplacedBody a:link, #yiv4756229982
.yiv4756229982aolReplacedBody span.yiv4756229982aolmail_MsoHyperlink
{color:blue;text-decoration:underline;}#yiv4756229982
.yiv4756229982aolReplacedBody a:visited, #yiv4756229982
.yiv4756229982aolReplacedBody span.yiv4756229982aolmail_MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv4756229982
.yiv4756229982aolReplacedBody p.yiv4756229982aolmail_msonormal0, #yiv4756229982
.yiv4756229982aolReplacedBody li.yiv4756229982aolmail_msonormal0,
#yiv4756229982 .yiv4756229982aolReplacedBody
div.yiv4756229982aolmail_msonormal0
{margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv4756229982
.yiv4756229982aolReplacedBody span.yiv4756229982aolmail_EmailStyle19
{color:windowtext;}#yiv4756229982 .yiv4756229982aolReplacedBody
.yiv4756229982aolmail_MsoChpDefault {font-size:10.0pt;} _filtered
#yiv4756229982 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv4756229982
.yiv4756229982aolReplacedBody div.yiv4756229982aolmail_WordSection1 {}
_filtered #yiv4756229982 {margin-bottom:0in;}#yiv4756229982
.yiv4756229982aolReplacedBody ul {margin-bottom:0in;}
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
