Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Autoinc not migrating correctly.. |
Sat, Jun 23 2018 7:10 PM | Permanent Link |
Ian Branch | Hi Team,
This may be one for Tim. As you are aware I am migrating a set of Apps and Database from ADS to EDB. Several of the tables have an ADS AutoInc field. After the migration into EDB all bar one of the autoinc fields has come across correctly as a Generated field. The one that doesn't comes across as an Integer only. By observation I note that the one that didn't, does not have complete sequential records in the Table. All the others do. Now, this is not insurmountable as I just use RESTART to reset the record that incrementing starts at once I have set the field correctly. So, the question is - Why doesn't this one table/field come across 'correctly'? Regards, Ian |
Sun, Jun 24 2018 3:07 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
> By observation I note that the one that didn't, does not have complete sequential records in the Table. All the >others do. Dim memory of my own migrations says this shouldn't be a problem > So, the question is - Why doesn't this one table/field come across 'correctly'? A few thoughts: - The ADS table is corrupted / its metadata is screwed - there are nulls in there causing havoc - Its not defined as an autoinc - There's some weird set of circumstances that Tim hasn't allowed for You're probably right and its down to Tim |
Mon, Jun 25 2018 4:39 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< As you are aware I am migrating a set of Apps and Database from ADS to EDB. Several of the tables have an ADS AutoInc field. After the migration into EDB all bar one of the autoinc fields has come across correctly as a Generated field. The one that doesn't comes across as an Integer only. >> My guess is that ADS isn't setting the field types properly. EDB uses the ADS TDataSet components to do its work, so it relies on ADS setting its field types to ftAutoInc, etc. and, if they don't, then EDB has no way of knowing whether the information it is being provided is correct or not. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |