CODEWITHSUNDEEP
sql-serverms-access
leora
leora

Reputation: 196469

upsizing ms access 2007 db to sql server 2008

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.

Upvotes: 1

Views: 1612

Answers (2)

jinsungy
jinsungy

Reputation: 10835

You can use DBWScript to generate sql scripts, such as CREATE TABLE.

Upvotes: 0

Mitch Wheat
Mitch Wheat

Reputation: 300549

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.

Upvotes: 5

Related Questions