June 11, 2019 at 8:36 am
Good morning everyone,
As an upgrade path for an old application developed with Access 2003 (adp project) & SQL Server 2000, I have successfully upgraded the database from version 2000 to 2008 and wish to complete upgrade up to version 2017.
The Data Migration Assistant has found some inconsistencies on data types as some tables are using TEXT and "These data types are checked as deprecated. In some cases, using TEXT, IMAGE or NTEXT might harm performance.".
As the Access 2003 IDE will not allow managing table properties since the SQL Server upgrade, I am quite confident no big problem should arise, until the data type TEXT will be dropped.
Of course a complete rewrite of this project is required!
Butt in the meanwhile, at least we have switched an old Windows Server 2003 to 2019 and SQL Server will update from version 2000 to 2017, if possible.
Since I have read this article, apparently in place upgrade is supported, but I am wondering if other issues may arise as for the upgrade from 2008 to 2017.
Your thoughts?
June 12, 2019 at 9:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply