I need to import data that is in an Access database via code to Sql Server. My software that is made in C # for many years has been integrated into an Access database. From now on we are migrating to Sql Server and the intention is that in the upgrade to the next version the system will only work with Sql Server. I think at first of creating a Sql database with the same names of tables and columns and the software read the Access tables and save the data in the Sql database. Is there any other more practical way to do this via code ?
I've been searching and found just tools ready, but nothing via programming.