Importing Access?

If I import an MS Access 2002 database into SQL Server, will it carry over
all my tables and table structures and my relationships, or will I need to
make major changes to them after?
Does it change the data types of fields as appropriate to match SQL data
types or make them all a generic one?
Thanksit depends on how you do it. if you are using the upsizing wizard then you
will get your tables, and data, etc. however you will have to go back in and
do a check to make sure everything is right. I have had varying degrees of
success with it and relationships ususally need to be recreated. Sometimes
drops the primary keys and indexes as well. you will also need to do some
coding. If you are using DTS than you can use the transforms in DTS to add
constraints, create indexes, etc. and this will give you better control over
how the data comes accross. but more control = more work upfront.
good luck
Neil MacMurchy
"Keith" <@..> wrote in message news:O13iNZcBEHA.3568@.tk2msftngp13.phx.gbl...
> If I import an MS Access 2002 database into SQL Server, will it carry over
> all my tables and table structures and my relationships, or will I need to
> make major changes to them after?
> Does it change the data types of fields as appropriate to match SQL data
> types or make them all a generic one?
> Thanks
>