Jon Westcot wrote: > 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 > > > >
Jon, You'll have to create a temporary database and use that as the interim if the source/target databases are named the same. There's no other way that's good due to VFP not being good at handling multiple databases named the same opened at the same time. Found that out with VFP6 back in the late 90s. -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
