Access to SQL Server Express

Hi - is it possible to transfer an access database to SQL Server 2005
Express, while maintaining the primary/auto increment field numbers?
I've tried the upsizing wizard, and this didn't maintain indexes/keys,
I've also tried the new SQL Server Migration Assistant for Access CTP2 -
while this kept the column integrity intact, it appears to have
recreated the primary key, so where my autoincrement field in access may
have had:
1 toyota
2 citroen
3 vw
6 ford
8 audi
..after migration, the table is recreated as...
1 toyota
2 citroen
3 vw
4 ford
5 audi
..meaning the relationships between the tables are not maintained.
I have perhaps misunderstood what the migration tool is supposed to do,
but if anyone can help advise what tool will do what I'm looking for,
I'd appreciate it.
Thanks, Mark
*** Sent via Developersdex http://www.developersdex.com ***I haven't tried the ctp Migration Assistant, but there 'should' be an option
that allows the import of IDENTITY values.
--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."
"Mark" <anonymous@.devdex.com> wrote in message
news:u7YVVnOpGHA.2360@.TK2MSFTNGP05.phx.gbl...
> Hi - is it possible to transfer an access database to SQL Server 2005
> Express, while maintaining the primary/auto increment field numbers?
> I've tried the upsizing wizard, and this didn't maintain indexes/keys,
> I've also tried the new SQL Server Migration Assistant for Access CTP2 -
> while this kept the column integrity intact, it appears to have
> recreated the primary key, so where my autoincrement field in access may
> have had:
> 1 toyota
> 2 citroen
> 3 vw
> 6 ford
> 8 audi
> ..after migration, the table is recreated as...
> 1 toyota
> 2 citroen
> 3 vw
> 4 ford
> 5 audi
> ..meaning the relationships between the tables are not maintained.
> I have perhaps misunderstood what the migration tool is supposed to do,
> but if anyone can help advise what tool will do what I'm looking for,
> I'd appreciate it.
> Thanks, Mark
>
> *** Sent via Developersdex http://www.developersdex.com ***