Database Preservation MS Access

Skip to end of metadata
Go to start of metadata

Converting MS Access

MS SQL Import

Install

Import

Create new database

  • Task->Import Data

It starts a wizard:

  1. Select database product
  2. Select data source
  3. Use defaults
  4. Select tables to import
    1. Edit mappings if needed
  5. Eg. save as SSIS package
  6. Review import report and finish import

Youtube example guide

SQL checks

DatabaseInformation

Row count

Show keys - primary - foreign keys

Convert to SIARDK

Create script to output the data from a single table as SIARDK XML

Tips quick start mto access the import wizard

  • Path to import wzard: c:/Program Files/Microsoft SQL Server/100/DTS/Binn/DTSWizard.exe

SIARD Access Import

AccessToSiard

  • Binary file (C script and JavaScript code)
    • JavaScript to easy connect to MS products
    • bat script runnable with Java 32/64 bit switch to start SIARD Suite with selected Java
  • Documentation is part of the SourceForge project mentioned above.
Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.