Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Mishefske, John
  New Posts New Posts RSS Feed - Metamorphosis Demo
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Metamorphosis Demo

 Post Reply Post Reply
Author
Message
John Mishefske View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2009
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote John Mishefske Quote  Post ReplyReply Direct Link To This Post Topic: Metamorphosis Demo
    Posted: 30 Jun 2009 at 1:28am

Metamorphosis Demo
http://www.tigeronomy.com/Downloads.aspx#link_metamorphosis

When distributing a new app version to existing clients you may have a need to migrate existing data into a new Back-End database. I use Metamorphosis to do this. Its a class module that migrates data from a user selected database file. You can define table and field mappings in code or you can have Metamorphosis prompt for an XML file. This allows you to provide custom table/field mapping definitions to clients who have custom database schemas. This demo includes four examples of moving data from a legacy back-end. It includes four sample XML data mapping files and exhibits several useful features like the use of SQL as a source or destination, the LITERAL feature for assigning a literal value to a new field and the TRANSFORM feature that runs custom code for fields during the data migration.

A very handy tool for updating existing Microsoft Access back-end .mdb or .accdb database files for existing installations.

John Mishefske
Microsoft MVP 2007 - 2009
Tigeronomy Software: http://www.tigeronomy.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.