Currently I use a Access database. This is filled with data. I want to re-create the structure manually in MS SQL Server database (upsizing from within MS Access seems not to be a good way to do this).
How can I copy the content from Access to SQL Server 2005 database without loosing referential integrity?
- when a table in Access has an autoincrement field, when copying this field to MS SQL Server, the record value of the autoincrement field must remain the same.
- different fieldtypes must be copied (memo, integer, text, boolean, etc.).