table snapshots - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

table snapshots

Author

Topic

ronin2307
Posting Yak Master

126 Posts

Posted - 2008-07-07 : 12:32:06

hi,

not sure how to approach this problem, so i am hoping to get some direction here.

Our ERP system has a glaring hole in its structure as it doesn't allow the capture of snapshots of certain tables. Where that would come really handy is the reporting of the WIP. the problem in my situation is that our accounting does some backdating at the end of the month because some things do get shipped on the last day of the month, but they don't close the jobs until the next monday or so. (not Enron style backdating :-) )

anyway, so my idea was this:
1. take a snapshot of the few tables in question at the last day of the month, close to midnight
2. store the tables outside of the ERP database into my own DB, created specifically for this purpose
3. run the WIP report i create at will

problem is, i have no idea if this is a smart way of doing this, or if there is a better way

any help will be appreciated

thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-07 : 23:38:10

I think that's only thing you can do in sql2k.