New version of SQL Server Migration Assistant for Access available for download

SQL Server Migration Assistant for Access 1.2  - Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server.

Published Saturday, May 26, 2007 11:42 AM by Tony
Filed under: ,

Comments

# re: New version of SQL Server Migration Assistant for Access available for download

Be sure you have primary keys on all tables, otherwise the tables will be locked from editing after migrations.

make sure there are no "-" in objects names, as these will be converted to "_" during migration and the application will have to be edited.

Friday, July 06, 2007 9:47 AM by ToddO

# re: New version of SQL Server Migration Assistant for Access available for download

Also Access likes a DateTimeStamp aka RowVersion column on each table.  

Friday, July 06, 2007 12:49 PM by Tony

Leave a Comment

(required) 
(required) 
(optional)
(required)