Archived copy. This page was recovered from the Internet Archive snapshot of /display/KB/Database Preservation MS Access taken on 2013-08-01. The original wiki at wiki.opf-labs.org is being decommissioned.

Database Preservation MS Access

Created by Janik Vestergaard Jensen on Feb 09, 2012 · last edited by Hartwig Thomas · on Apr 05, 2012 (view history) · 6 versions

Converting MS Access

Converting MS Access

MS SQL Import

Install
Import
SQL checks

DatabaseInformation
Row count
Show keys - primary - foreign keys
Convert to SIARDK

Tips quick start mto access the import wizard

SIARD Access Import

AccessToSiard

MS SQL Import

Install

Import

Create new database

Task->Import Data

It starts a wizard:

Select database product
Select data source
Use defaults
Select tables to import
1. Edit mappings if needed
Eg. save as SSIS package
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

Open Source (http://sourceforge.net/projects/accesstosiard/)
SIARD Suite install dependency
- Automatically handles visibility of system objects and setup of ODBC connection

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.