Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to rename a database
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00616146
Message ID:
00616164
Views:
28
>Hi all,
> six months ago I took our large body shop app and used most of it as a base for a new system for jobber stores. It was too much of a pain to change the database name becase there were about 70 tables in it. Now, of course, I have some prospects that would like to run a combination of the two. That part is easy. Just look in one system from the other when needed. The hard part is I don't think I can have the same database name in two places and have them both open at the same time.
>
>I was wondering if anyone could give me some advice on the following:
>
>1. Can I have two databases with the same name open at the same time reliably. They reside in two different directories. (I assume no but...)
>
>2. I am assuming that the best way to rename the database is to use GENDBC and rework the generated code with the new database name. Is there an easier or more reliable way?
>
>Thanks all.
>John.

1) Yes but be aware its not possible to distinguish between the two once they are open, which may cause problem with stored procedures etc. also tables with the same name could not be opened with Database!Table.

2) Don't think so.
Caroline
Previous
Reply
Map
View

Click here to load this message in the networking platform