After moving the entire Dynamics GP DYNAMICS & Company DB’s to a new Dynamics GP server, all the maps are still pointed toward the old server. You can manually delete the old entries and add the new ones, but each and every map needs to be opened and edited. Is there a faster way?
Yes, you can update the TenantBase table to point to the new SQL server. The update statement you will run is:
Update [SmartConnect]..[TenantBase] set ServerName='New Server' where ServerName='Old Server'
Replace ‘New Server’ with the nameinstance of the new server, and replace ‘Old Server’ with the nameinstance of the old server.