Hi all:
No nibbles on my message when I first posted it; so, figuring that it might have gotten lost in the shuffle, I'm going to try sending it out again and see what happens.
~~~~~~~~~~~~~~~~~~~~
Just wondering what everyone else has done when migrating from one version of VFP to another in regard to copying data from one database to another.
The situation I've got now is that I've got an application currently running under VFP6 and the client wants to migrate to VFP9. Normally, this wouldn't be a big issue, but the client doesn't want everyone moving to VFP9 all at once. They want to test things out first with one or two people, and then move everyone over after testing is done.
I'm trying to automate a process to move all data from the tables in one database to another, but I've hit a snag. The database itself is named the same, and I can't find any reference information on how to refer to two different databases that have the same name at the same time. I know that I can alias a table with no problem, but can I also alias a database?
Any suggestions on how best to accomplish this, short of changing the database name in the newer application, would be greatly appreciated.
Thanks,
Jon
©2007 Jon Westcot |