How to copy whole database (including tables) ?
| Author |
Message |
|
Gregory Ada
#1 / 8
|
 How to copy whole database (including tables) ?
One thing to explore is RUN Xcopy ...... which I believe with the correct options copies the subdirectories as well
Hello,
maybe a stupid question, but how do I copy a whole database (.dbc),
including all tables, memo fields, stored procedures, ... ?
"copy to " I only can use for tables, and I have to do this
for every table which belongs to a database.
Doing a copy using the DOS-Prompt or Windows-Explorer will work, but
there I also have to know every table, which belongs to the database.
Any tiny command, which does what I want (and knows, which
tables belong to a database)?
Many thanks for your help!
Best regards
Juergen
Sent via Deja.com http://www.*-*-*.com/
Before you buy.
|
| Sat, 22 Feb 2003 15:42:00 GMT |
|
 |
|
kicker3..
#2 / 8
|
How to copy whole database (including tables) ? Hi, Unfortunately, there is no simple command to copy an entire database. The easiest thing to do is to move all of the database files (*.DBC, *.DBX, *.DBT, *.DBF, *.CDX, *.FPT, *.IDX) into a seperate folder. Then when you want to duplicate the database, you can simply copy the folder. - Keith
Quote: > Hello, > maybe a stupid question, but how do I copy a whole database (.dbc),
> including all tables, memo fields, stored procedures, ... ?
> "copy to " I only can use for tables, and I have to do this
> for every table which belongs to a database.
> Doing a copy using the DOS-Prompt or Windows-Explorer will work, but
> there I also have to know every table, which belongs to the database.
> Any tiny command, which does what I want (and knows, which
> tables belong to a database)?
> Many thanks for your help!
> Best regards
> Juergen
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Sent via Deja.com http://www.deja.com/ Before you buy.
|
| Sat, 22 Feb 2003 21:41:41 GMT |
|
|
|
Maya Roseli
#3 / 8
|
How to copy whole database (including tables) ? Hey guys,
Let's not forget about GenDBC.prg!
Look for this prg that ships with VFP
wherever you've installed it. This
handy little thing will create code that
will generate a DBC with DBF's, CDX's, etc.
from an open database.
HTH,
Maya
Quote: > Hello, > maybe a stupid question, but how do I copy a whole database (.dbc),
> including all tables, memo fields, stored procedures, ... ?
> "copy to " I only can use for tables, and I have to do this
> for every table which belongs to a database.
> Doing a copy using the DOS-Prompt or Windows-Explorer will work, but
> there I also have to know every table, which belongs to the database.
> Any tiny command, which does what I want (and knows, which
> tables belong to a database)?
> Many thanks for your help!
> Best regards
> Juergen
> Sent via Deja.com http://www.deja.com/
> Before you buy.
|
| Sat, 22 Feb 2003 23:13:56 GMT |
|
|
|
sut..
#4 / 8
|
How to copy whole database (including tables) ?
Quote: > Hello, > maybe a stupid question, but how do I copy a whole database (.dbc),
> including all tables, memo fields, stored procedures, ... ?
> "copy to " I only can use for tables, and I have to do this
> for every table which belongs to a database.
> Doing a copy using the DOS-Prompt or Windows-Explorer will work, but
> there I also have to know every table, which belongs to the database.
Check out the help for the ADBOBJECTS() function. This can tell you all the tables in a DBC, and from there you can copy DBFs, CDXs, and FPTs for the given tables. Then, copy the DBC, DCT, and DCX for the database container itself, and you should be all done! Quote: > Any tiny command, which does what I want (and knows, which
> tables belong to a database)?
ADBOBJECTS() should help a lot. Good luck! JoeK
Sent via Deja.com http://www.deja.com/
Before you buy.
|
| Sat, 22 Feb 2003 23:31:58 GMT |
|
|
|
Trey Walpol
#5 / 8
|
How to copy whole database (including tables) ? One thing I would suggest - put the database and all it's tables together in their own directory. Don't put any tables that don't belong to the database in this directory. This will make maintenance a LOT easier in the long run. Then to copy, just use COPY FILE *.* TO \newdir\*.*
Quote: > Hello, > maybe a stupid question, but how do I copy a whole database (.dbc),
> including all tables, memo fields, stored procedures, ... ?
> "copy to " I only can use for tables, and I have to do this
> for every table which belongs to a database.
> Doing a copy using the DOS-Prompt or Windows-Explorer will work, but
> there I also have to know every table, which belongs to the database.
> Any tiny command, which does what I want (and knows, which
> tables belong to a database)?
> Many thanks for your help!
> Best regards
> Juergen
> Sent via Deja.com http://www.deja.com/
> Before you buy.
|
| Sun, 23 Feb 2003 09:53:19 GMT |
|
|
|
Alan Sheffiel
#6 / 8
|
How to copy whole database (including tables) ? There is only one problem with the "gendbc" idea. The program gendbc.prg is
not very smart and if you have enough tables/views in your database it will
generate a program that is too large for vfp to run. Needless to say the
resulting program is useless. And if the program is small enough to run you
may still have a problem. If you have views that are based on other views
you have no guarantee that gendbc will create them in the proper order. Thus
if view B required view A gendbc might try to make view B first you have no
control over this.
BUT, all is not lost. If you look at gendbc.prg you can see what commands it
issues and create your own program to record/create a new copy of your
database. I have one that scans the views and creates a program to recreate
them. That way if I add columns to my database I don't have to revisit each
view to make sure I did not break it 8-)
Alan Sheffield
www.sheffieldsystems.com
Quote: > Hey guys, > Let's not forget about GenDBC.prg!
> Look for this prg that ships with VFP
> wherever you've installed it. This
> handy little thing will create code that
> will generate a DBC with DBF's, CDX's, etc.
> from an open database.
> HTH,
> Maya
> > Hello,
> > maybe a stupid question, but how do I copy a whole database (.dbc),
> > including all tables, memo fields, stored procedures, ... ?
> > "copy to " I only can use for tables, and I have to do this
> > for every table which belongs to a database.
> > Doing a copy using the DOS-Prompt or Windows-Explorer will work, but
> > there I also have to know every table, which belongs to the database.
> > Any tiny command, which does what I want (and knows, which
> > tables belong to a database)?
> > Many thanks for your help!
> > Best regards
> > Juergen
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
|
| Mon, 03 Mar 2003 03:00:00 GMT |
|
|
|
Anders Altber
#7 / 8
|
How to copy whole database (including tables) ?
Quote: > There is only one problem with the "gendbc" idea. The program gendbc.prg
is
> not very smart and if you have enough tables/views in your database it
will
> generate a program that is too large for vfp to run. Needless to say the
> resulting program is useless. And if the program is small enough to run
you
That's been changed. The current version doesn't create a single procedure that can beak the 64K-byte limit, it consists of lots of small procedures on for each table or view. -Anders
|
| Wed, 05 Mar 2003 03:00:00 GMT |
|
|
|
Alan Sheffiel
#8 / 8
|
How to copy whole database (including tables) ? Quote: > That's been changed. The current version doesn't create a single procedure
> that can beak the 64K-byte limit, it consists of lots of small procedures
on
> for each table or view.
> -Anders
That's good to hear. Most of the I got frustrated with the 5.0 versions limits a while ago and never looked into the 6.0 version. I just kept using my own code. Alan
|
| Fri, 07 Mar 2003 03:00:00 GMT |
|
| |
|
