If all 200 databases are identical, then you can automate the process
by creating the destination database in SQL Server and using SSIS (SQL
Server Integration Services) to create a package that you could call
from the command line. However, if they're not, then each one is going
to require some tweaking. Here's a list of resources, starting with
the SSMA site:
SQL Server Migration Assistant for Access (SSMA for Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
TechEd Online Panel:
Go to http://msdn.microsoft.com/en-us/events/teched/cc676818.aspx and
search for:
"Are we there yet? Successfully navigating the bumpy road from Access
to SQL Server"
Microsoft Access or SQL Server 2005: What's Right in Your
Organization?
http://www.microsoft.com/sql/solutions/migration/access/sql-or-access.mspx
Optimizing Microsoft Office Access Applications Linked to SQL Server
http://msdn.microsoft.com/en-us/library/bb188204.aspx
What are the main differences between Access and SQL Server?
http://sqlserver2000.databases.aspfaq.com/what-are-the-main-differences-between-access-and-sql-server.html
"The Best of Both Worlds--Access MDBs and SQL Server"
http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp
FMS Upsizing Center
http://www.fmsinc.com/Consulting/sqlupsizedocs.aspx
--Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/dp/0672319446
On Wed, 15 Oct 2008 02:31:01 -0700, Damien Larroumets <Damien
Post by Damien LarroumetsI have to migrate about 200 Access databases, is it possible to call
SSMAforAccess with a command line to automate the process ?
thanks a lot