[SQL] Archival of Live database to Historical database

2001-02-03 Thread miss
Hello all I have been watching with some interest the "problem" of not being able to work with more than one database. My muse is aimed at creating an incremental backup for a very low usage database - say several hundred transactions per day Back in my days of DOS about v3 I used to use the >>

Re: [SQL] Archival of Live database to Historical database

2001-01-30 Thread Stef Telford
Richard wrote: > > Hello everyone, > > I have hit on a limit in my knowledge and i am looking for > > some guidance. Currently I have two seperate databases, one for > > live data, the other for historical data. The only difference really > > being that the historical data has a Serial in it so th

Re: [SQL] Archival of Live database to Historical database

2001-01-30 Thread Richard Huxton
From: "Stef Telford" <[EMAIL PROTECTED]> > Hello everyone, > I have hit on a limit in my knowledge and i am looking for > some guidance. Currently I have two seperate databases, one for > live data, the other for historical data. The only difference really > being that the historical data has a

[SQL] Archival of Live database to Historical database

2001-01-29 Thread Stef Telford
Hello everyone, I have hit on a limit in my knowledge and i am looking for some guidance. Currently I have two seperate databases, one for live data, the other for historical data. The only difference really being that the historical data has a Serial in it so that the tables can keep mo