Jump to content

Database Upgrade - Archiving Old Data


physixz
 Share

This topic is 2287 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi, I have been given the task of upgrading and improving our solution at work which consists of 9 files. I've started by identifying the problems such as data loss or unexpected things happening and have focussed on one file to start with. In an offline file I have made my changes and the file is much more robust and easier to use but the problem is I've made changes on the relationship graph so the data is broken. This is not a major problem as because the data was incorrect it would have taken too much effort to fix but what we would like to do is archive the data, kind of like take a snapshot at which the data can then no longer be changed but can be viewed for traceability. The file is used as a stock database and has all of the transactions for each item. With my changes the transactions are lost, they are in a separate table. I was thinking if I renamed the table and then create a portal on a new table called archived I could then copy the table and delete the data from the new table and make my changes. Would this work?

 

I have attached an image of part of the relationship graph, the table is called Stock entry and it only has one occurrence as shown

 

SDB.JPG

Link to comment
Share on other sites

This topic is 2287 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.