After I create a new store database in HQ Manager, export the store database from HQ Admin, and then import the database into the Store Database on the POS I have noticed that only the StoreID is updated correctly. The Store Name, Address, Zip, State, and phone numbers are still set to my master database that I use as a template. This is getting annoying as I am setting up 50 stores.
I tried to create a SQL Script to run on the POS in SSMS, which works EXCEPT for the zip code will not update and I do not understand why. The only thing I noticed is ZIP is varchar(15) not null in the Store table and it is nvarchar(15) not null in Configuration. There are no check constraints or triggers that I can see. Only a default value constraint of ''.
Here is my script: update Configuration set StoreName = S.Name ,StoreAddress1 = S.Address1 ,StoreAddress2 = S.Address2 ,StoreCity = S.City ,StoreZip = S.ZIP
from Configuration inner join Store S on S.ID=storeid