-
MSDE + autonumbers
We have clients with Access databases. We are currently upgrading to MSDE and I have to come up with a data conversion program. Now, I can easily upsize it (but no data, it must be done at customer's site). However, how would I transfer the records with autonumber fields?? The records must be transferred by my conversion application.
Thanks,
-
in MSSQL the field is defined as Type = Integer, Allow Nulls = No, Identity = True.
You'll want to make sure that you SET IDENTITY INSERT ON first, before inserting the rows, that way the old Autonumber will come over proeprly.
-
Thanks,
Can I change it after that, so autonumber resumes?
-
Also, I only have MSDE installed and it doesn't come with Enterprise manager. How can I alter the Field's properties?
Thanks,
-
The identity in MSSQL is basically the same thing as Access's Autonumber...so you wouldn't want to turn it off.
-
Then how would I transfer the records preserving the autonumber values?
-
Try setting the field to an integer datatype...once the data has been transferred...then click the identity for that field so it will continue to increment the values.