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


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]

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

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

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]

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
>

Raul


I was going to suggest that but version 3. Was it around then?

Roy Lambert

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
>

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

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]