Unanswered: Changing the start value for auto-increment field
Hopefully this is an easy question for one of you gurus. I have an auto-increment field, and I would like the start value to be different than 1 (Because it will later be migrated to SQL Server, along with another database collecting the same data, and we don't want to end up with duplicate keys). Any thoughts or assistance are appreciated.
If your second database have an auto-increment key, you'll not end with duplicates key. The first record (with the number 1) will have his value auto-incremented to whatever your second database field is at, so it could become 546 if your second database have 545 datas in it