SSMA problem

H

Hans Baele

Dear All,

It concerns the migration of access 2000 tables to sql server 2005
tables:SSMA is the prodoct of microsoft for the conversion.

The SSMA message is "cannot migrate data from access table with double key
to sql table with single key"
At access level the original table has only a single key (at access level).
At SSMA gui the original access table has a double key!How is this
possible???
(The gui show the first key green and the second key gray)
At sql server management studio the created sql table has only a single key
and the table is empty because there was no migration

Has anyone a solution?

Many thanks
Hans Baele
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Upsize and SQL Server Migration Assistant 2
How do I make an unsecured copy of my database? 2
Migration Access97 *.mde db in SQLServer2005 9
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
SSMA Migration to Master 5
SSMA - Query Conversion to Stored Procedures. 17
Fixing up field with a row number to become PK 1

Top