Converting MS Access
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
- Edit mappings if needed
- Eg. save as SSIS package
- Review import report and finish import
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.
Labels:
None