|
 |
asp_databases thread: send information from one table to another archive by date
Message #1 by "Dovidas, Mark" <Mark.Dovidas@b...> on Wed, 24 Oct 2001 10:06:22 -0400
|
|
Can anyone point me in the right direction?
I have to transfer all fields from one database table to another (archive
table, exactly similar) after either 90 days, and have an option to do it
manually, and have the possibility of searching either the main database, or
the main and archive database. The two are exactly the same except of
course one is the archive, one is for new memos.
Message #2 by Simon Newton <simonn@h...> on Thu, 25 Oct 2001 06:56:56 +1000
|
|
Mark,
Wots the DB?? SQL??
-----Original Message-----
From: Dovidas, Mark [mailto:Mark.Dovidas@b...]
Sent: Thursday, 25 October 2001 12:06
To: ASP Databases
Subject: [asp_databases] send information from one table to another
archive by date
Can anyone point me in the right direction?
I have to transfer all fields from one database table to another (archive
table, exactly similar) after either 90 days, and have an option to do it
manually, and have the possibility of searching either the main database, or
the main and archive database. The two are exactly the same except of
course one is the archive, one is for new memos.
Message #3 by Greg Griffiths <griffiths@x...> on Wed, 24 Oct 2001 22:10:19 +0100
|
|
You could set up some sort of scheduled job on the server to run the SQL.
At 10:06 24/10/01 -0400, you wrote:
>Can anyone point me in the right direction?
>
>I have to transfer all fields from one database table to another (archive
>table, exactly similar) after either 90 days, and have an option to do it
>manually, and have the possibility of searching either the main database, or
>the main and archive database. The two are exactly the same except of
>course one is the archive, one is for new memos.
>
>
>
Message #4 by David Cameron <dcameron@i...> on Thu, 25 Oct 2001 09:14:18 +1000
|
|
If you have SQL server, look at running a scheduled DTS job.
If not I guess you could schedule a script or program to run and do it for
you.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: Dovidas, Mark [mailto:Mark.Dovidas@b...]
Sent: Thursday, 25 October 2001 12:06 AM
To: ASP Databases
Subject: [asp_databases] send information from one table to another
archive by date
Can anyone point me in the right direction?
I have to transfer all fields from one database table to another (archive
table, exactly similar) after either 90 days, and have an option to do it
manually, and have the possibility of searching either the main database, or
the main and archive database. The two are exactly the same except of
course one is the archive, one is for new memos.
|
|
|
View Cart
