[AccessD] sql server migration assistant

Hi John,

I used it about a year ago.  What I liked about it was that I got
descriptive error and warning messages if tables didn't upsize.

By the way, look here 

http://www.databasejournal.com/features/msaccess/article.php/3697256/Migrati
ng-Access-Apps-to-SQL-Server.htm

for information about upsizing, including a utility to convert access
queries to stored procedures - that looks good too!

Dan
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, May 21, 2010 12:26 PM
To: Access Developers discussion and problem solving; Sqlserver-Dba
Subject: [AccessD] sql server migration assistant

Has anyone used the SQL Server Migration Assistant for SQL server 2008?
Pros / cons / comparisons 
to the upsizing wizard?

I just looked at it today for the first time and it seems pretty good, but I
haven't done an 
extensive eval.

-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com