Dennis Sorry I wasn't very clear, that is a great way for one table, but I have over 100 tables in my app. I need to Unload all of their data from 100+ tables to Load into my new app.
Marc ________________________________ From: Dennis McGrath <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, March 4, 2014 1:12 PM Subject: [RBASE-L] - RE: UNLOAD DATA..... Marc Drop all interfering primary and foreign keys Rename the table using the nocheck option so no references are updated. Create the new version of the table. append oldtable to newtable recreate indexes, primary keys and foreign keys rebuild any views referencing that table drop the old table Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From:[email protected] [mailto:[email protected]] On Behalf Of marc schluter Sent: Tuesday, March 04, 2014 1:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - UNLOAD DATA..... Hi I am looking for a better way to update users I need to update several users to my latest App but some of the users don't have all the newest columns I have added the past year. User A may have Column A,B,C user B may have A,B,C,D but my newest table has A,B,C,D,E. Also some tables have a computed column. In the past I would take my current DB and delete all the data,run a command file to Unload their data then Load their data into my empty DB. I would Unloading each table using a Column List, wait for an error, edit the command file to drop the column that gave the error until I don't have any errors. Thanks for any suggestions Marc
