Migration of data between versions

[Doering William T]

I have looked into something slick to migrate from one version to another.  From the Access experts I’ve talked to, you don’t want to import tables, queries, forms or reports from the old version.  We have added tables, changed things in queries, etc.  If you import, at best you would have the old version, at worst you will corrupt your data. 

 

What I’ve done is to open both databases and starting with the stand-alone tables like Access, Authentication_Method, Database_Type, etc. copy and paste data cells from the old version to the new version.

Second, On other tables, those which contain fields which link to other tables, start copying and pasting fields which do not link to other tables and selecting from drop-boxes, the data which needs to link to other tables.

 

This sounds all very manual and cumbersome, which it is, but it took me a half day and I was done.  A student could do some of this work as well.  With the money from the Coutts Award, coming up with a cleaner migration strategy is number one on my list.

 

If other users have found a better way to migrate, I’d love to hear it.

 

 

William Doering

Systems, Catalog & Digital Initiatives Librarian

Murphy Library

University of Wisconsin - La Crosse

1631 Pine st.

La Crosse, WI  54601 USA

(608) 785-8399

(608) 785-8639 (fax)

doerin...@uwlax.edu

Library website: http://www.uwlax.edu/murphylibrary/

Library catalog: http://laclib.wisconsin.edu/

Digital Library: http://murphylibrary.uwlax.edu/digital/

ERM website: http://murphylibrary.uwlax.edu/ERM/

 

[Norma Dowell]

Another way would be to append information onto the tables William is talking about, especially if you have added content.
Import just adds new tables and you may notice the tables are renamed with a number at the end of them.  If you append to existing, it is possible to keep a lot of your information.  One caution though is that you should look at the structure of the new tables in the new version to look for changes in file headings and content.  If there are new columns, you would be well to manipulate the table headings in your old version before appending to the new version.

It takes less time, but one must be careful as they go.

Norma J Dowell

--
You received this message because you are subscribed to the Google Groups "ERMes" group.
To post to this group, send email to erme...@googlegroups.com.
To unsubscribe from this group, send email to ermeserm+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/ermeserm?hl=en.