Sage 100

Have a customer wanting to migrate Sage 100 Premium from Sage 2014 to Sage 2018 and upgrade SQL at the same time. His concern is losing all of his custom views/stored procedures/tables. During a previous upgrade, we had the same issue, but not near as many as this customer has. So, we just scripted them to new queries and recreated them. Does anyone know of a method to upgrade while retaining all of these custom views/stored procedures/tables?

You have to script all the custom stuff and run the scripts after the upgrade. In SQL Manager, right click on the database, choose Tasks, Generate scripts and it will let you pick all your custom objects and script them either with or without the data, and as one script overall or one script per object. When replaying the scripts, do tables, then views, then stored procedures.

What @PhilMcIntosh said. And when you pull your custom tables (side note, I like to use a custom schema for those), make sure you change the Generate Scripts, Advanced, Types of data to script to Schema and Data (https://stackoverflow.com/questions/11884965/generate-script-for-both-schema-and-data)

Thank you Phil and Steve. I'll relay the information

It should all be there after the restore of the database for that company. copy the database to MAS_XXX_Old so if you need something it will be there. then you can rescript if needed.