Sage 100

2018 Premium. The customer wants to renumber the ShipToCode associated with the SO_ShipToAddress. He has identified all of the tables that contain the ShipToCode and he wants to run some SQL queries over the weekend to make the changes, and lots if them. Is there a utility that can renumber ShipToCodes? If not what's the worst case scenario if we run the SQL queries to change the ShipToCode?

I *guess* that would work if everyone's out of the system and they work with the proper keys. I would run ApexSQL Search (https://www.apexsql.com/sql-tools-search.aspx) after they're done to confirm that they got the old ShipToCode everywhere.

Thanks @SteveIwanowski

SELECT c.name AS 'ColumnName' ,t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%MyName%' ORDER BY TableName ,ColumnName;

The ""safe"" method would be to capture the old code in a UDF (table by table) before running the updates... that way you could always undo a change if something goes wrong. A typo in a SQL update command can have devastating consequences. Always run the script in a test company (and verify results) before running Live.

Thank you for the information @KevinMoyes .