April 20, 2009 at 3:07 am
Hello
I've been asked to create an SQL job that archives the BAM Primary Import table that comes with Biztalk 2006. I believe that a stored procedure will be executed to transfer data to the BAMArchive table but I don't know if this is right. Does anyone know how to create this job?
Regards
m
April 20, 2009 at 5:43 am
Is there not facility within the application to schedule backups of the databases on a regular basis?
April 20, 2009 at 5:52 am
Well, I'm not intrested to back up the database. Only to clear some tables in the database and transfer it to an archive database.
April 20, 2009 at 6:21 am
If you are just looking to archive then create the new table with the same schema as the old.
Insert into that table based off of some incrementing timestamp value, delete everything before that timestamp on the original after checking the data matches up.
Wrap that in a procedure and it's all good.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply