Updating Test DBC data from live DBC data

[BobMorris]

I've been working on an app in a test area. It's now ready for testing. Now, I need to get the live data into the test area.

I've have made many changes to the DBC, added tables, added fields, changed links between tables, etc.

What's the best way to get the data into the new tables from the old tables? Open both DBCs, open the respective tables, zap the new table and APPEND from the old table?

Will this work or could I break something in the new DBC doing this? Any gotchas I need to look out for here?

 

[weedz]

Check out

http://www.xcase.com.

Or write a routine to append all data from your live environment to your test environment. The problem is that when you changed data type of filed, you'll end up with wrong data.

HTH,
Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

And especially for VFP rookies:

http://fox.wikis.com/wc.dll?Wiki~VFPRookieMistakes~VFP

 

[dgrewe]

When I do something like that I create a convertion table.
The tables has all the fields in it from both tables, old and new.

Use convert
append from old
replace all new fieldnames with OldfieldNames
use new
append from convert. David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644