i keep getting an error:
The upsizing wizard does not work with this version of SQL Server to which your access project is connected.
has anyone else seen this issue.
+3
A:
There is another version of the Upsizing Wizard: Migrating to SQL Server 2008
It's called the SQL Server Migration Assistant for Access (SSMA Access) and you can download here.
Mitch Wheat
2009-11-21 12:51:25
excellent . . .
ooo
2009-11-21 13:01:11
Technically speaking that's not a newer version although I've heard it's better. It's a totally different product created by the SQL Server produt group while the Upsizing w=Wizard is produced by the Access product group.
Tony Toews
2009-11-21 19:55:59
"Microsoft SQL Server Migration Assistant (SSMA) 2005 for Access is a tool for migrating databases from Microsoft Access to Microsoft SQL Server 2005." It does not support SQL Server 2008!
jinsungy
2010-03-18 13:13:55
jinsungy
2010-03-18 14:52:14
@ jinsungy: Thanks. I've updated. A comment would have been sufficient without the downvote to get me to change it! But thanks anyway.
Mitch Wheat
2010-03-18 15:17:07
@mitch, i see that you changed the link. thanks.
jinsungy
2010-03-18 15:18:56
@mitch, downvote removed.. i felt it was necessary since i downloaded/installed/ran the tool for 2005 !
jinsungy
2010-03-18 15:20:05
@jinsungy: apologies for any time you wasted.
Mitch Wheat
2010-03-18 16:22:43