I have millions of old measurement records in my database, which has now grown to 20GB. I would like to move records older than two years to another database and do so on a monthly basis. It seems silly to unload the database to a new database and the delete all records younger than two years from than (newly-created) database. Is there another way to do this?
If you created a second database, and set that as a Remote Server on your original database, you could then create an event in your original database to copy all the old rows into the second database, perhaps check that the same number have arrived(!) and then delete those from the original. That process could be completely automatic if you wanted.
Look at the "Working with Remote Servers" and "Automating Tasks Using Schedules and Events" topics in the help.
NB the term "Remote Server" can be confusing, it can be another database on the same server!
answered 12 Dec '11, 07:03