Interesting scenario. I work for a large franchise where we have a mix of corporate owned and franchisee owned stores. One of store owners operates 6 franchises. Unfortunately he knew enough to be a bit dangerous with a Store Operations implementation at a new store. He has taken a backup copy of one of his other stores and then used it to restore and create a new database at the new store before anything was created in HQ. I am now in the position of trying to create and sychronize the new store to HQ. My initial thought is to do the following:
Does anyone have any thoughts on this procedure?
Mabuhay Sir Craig,
Your step is okay also, Id like to ask if He named the store on what format? Basically Store Code and Name is changeable not unlike on StoreID. For us it would be;
1, Create the Store in HQ
2. Rename it as it was a new store then confirm if the store that has been restored on their database is similar to whats we create on HQ.
3. If its not then try to backup the said database on the store and restore as it was the official name for the franchise.
3. Then Request Data Upload?
4. Check now on HQ if their sales and data is now transmitted.
Your steps looks ok except you do not need to renumber the storeid if it is only going to be used as a template.
I would try the following -
Take a backup of HQ Database first.
1. Create the store in HQ. Set-up store connection schedule as needed.
2. Use the existing Store database as template
3. Export the new store DB from HQ
4. Restore the newly created Store database. Connect the newly created Store database to HQ using HQ Client and it will automatically synchronize the first time it connects to HQ.
6. Run a 401.
7. test all is ok with the new Store database. Backup and restore the database at Store.
I'm not sure that that is enough to go on. There are so many things that could go wrong with this. If it were me, I think I would create a new store like normal and have them do a physical inventory and reconcile it. HQ is touchy enough!
That would probably prevent him from creating this mess again, too! ;-)
Jeff HobbsCheck Point Software
The new store database will not have any inventory or sales info. (It is a new store database).
So the next step at the store is to do physical inventory.
But the Store database will sync with HQ.
Thanks for all the feedback. Jeff, I agree that there are many things that could go wrong with this. One part of this scenario that I failed to include was the fact that he had store staff adding items directly into the store operations manager. I am fortunate that I have a fully functioning test environment (SQL, HQ and Store Ops) so I think I will recreate what has been done and then attempt to fix/create/synchronize. I will post back when I complete some testing.
As always the comments and help are greatly appreciated. I also agree with the idea of having the owner do a full inventory but I will see how far I get with the solutions presented here.
Yes, once an owner makes a mess like this they tend to only do it once ;-)
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13