Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 15 total |
automating "Copy Table" operation |
Mon, Oct 26 2009 4:30 AM | Permanent Link |
kubi | Hello,
I want to copy version 3 .dat (and related .idx) files. I can do it with dbsys.exe with GUI. How can I do it with command line in a .bat file? Thanks Kubi |
Mon, Oct 26 2009 4:52 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | kubi
Just use a DOS style copy command. Make sure you copy .dat, .idx and .blb The .blb's only exist where there is a memo field in a table. Roy Lambert [Team Elevate] |
Mon, Oct 26 2009 5:55 AM | Permanent Link |
Jan Ferguson Data Software Solutions, Inc. Team Elevate | Kubi,
You might find this web site helpful. http://home.att.net/~gobruen/progs/dos_batch/dos_batch.html -- Regards, Jan Ferguson kubi wrote: <<Hello, <<I want to copy version 3 .dat (and related .idx) files. I can do it <<with dbsys.exe with GUI. << <<How can I do it with command line in a .bat file? << <<Thanks <<Kubi >> kubi |
Mon, Oct 26 2009 7:53 AM | Permanent Link |
kubi | Thanks Roy,
the dat and idx files are being used by ~40 users on the network and continously 7x24. As far as I know, copying "open" files could may result to "unstable" files. I am new to dbisam and I want to make warm backups of .dat/idx files that are 7x24 used. What is your suggestion to get stable file copies of dat/idx files that always in use? kubi |
Mon, Oct 26 2009 9:30 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | kubi
Making a copy of a table (or any file) that's in use is never to be encouraged. Whatever is used HAS to stop input at least for the time its copied, and if there are relationships between tables that essentially means that you have to stop input across all the related tables. Are you using client/server or fileserver? If the former then the best approach would be to mod the server to add a timed backup (ie stop input and do a copy), if the latter the best bet is one of those backup apps that claim to take a snapshot (eg Acronis) Roy Lambert [Team Elevate] |
Mon, Oct 26 2009 9:41 AM | Permanent Link |
"Raul" | You're probably better off using the built-in backup then. See section in
manual called Backing Up and Restoring Databases (http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=r&version=2007&category=1&topic=13) It does not create the dat/idx/blb files but if you want that then just create a utility that does a backup followed by restore into your destination folder. Do note that backup requires a read lock on your table while it runs - generally it'll be a very short lock (unless you table is huge). Raul "kubi" <khusmeno@hotmail.com> wrote in message news:08C3A983-D056-4C90-A946-732B48E6F95F@news.elevatesoft.com... > Thanks Roy, > > the dat and idx files are being used by ~40 users on the network and > continously 7x24. > As far as I know, copying "open" files could may result to "unstable" > files. > > I am new to dbisam and I want to make warm backups of .dat/idx files that > are 7x24 used. > > What is your suggestion to get stable file copies of dat/idx files that > always in use? > > kubi > |
Mon, Oct 26 2009 10:10 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Raul
I was going to suggest that but version 3. Was it around then? Roy Lambert |
Mon, Oct 26 2009 10:13 AM | Permanent Link |
"Raul" | While i don't have a v3 available i'm pretty sure it had backup/restore.
Raul "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:AA0EC398-5438-47BF-BF64-735643CE8CE5@news.elevatesoft.com... > Raul > > > I was going to suggest that but version 3. Was it around then? > > Roy Lambert > |
Mon, Oct 26 2009 11:17 AM | Permanent Link |
kubi | Raul and Ray,
I only know vb6 and vb.net/C#. Can I write a program to backup version 3 files? Or is it possible to backup tables with command line of dbsys.exe for version 3 ? (By the way can you please reply to http://www.elevatesoft.com/newsgrp?action=openmsg&group=5&msg=63281&page=1) Thanks a lot Kubilay |
Mon, Oct 26 2009 12:15 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | kubi
>Raul and Ray, >I only know vb6 and vb.net/C#. >Can I write a program to backup version 3 files? Yes - see below. >Or is it possible to backup tables with command line of dbsys.exe for version 3 ? No, but since you get the source you can copy the backup code from DBSys into your own app. >(By the way can you please reply to http://www.elevatesoft.com/newsgrp?action=openmsg&group=5&msg=63281&page=1) Nope, only Tim can do that. Roy Lambert [Team Elevate] |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |