creating new data base

Questions and Answers about the POS Pizza 6 & 7 Databases
Member
Posts: 11
Joined: Sun Jun 03, 2018 3:07 pm

creating new data base

Postby franke » Sun Jan 27, 2019 2:44 pm

I have created a new data base with Data Base creator tool, I want to move my menu to it so I have my orders start over, I've entered many orders on the original data base testing. I cannot find the new data base in utility management, that I created. I need to figure out how to start the data base and import my menu?
I tired to figure it out thru the Manager Pdf.

Site Admin
User avatar
Posts: 2203
Joined: Wed Apr 16, 2003 4:35 pm
Location: Western PA

Re: creating new data base

Postby Scott » Mon Jan 28, 2019 5:43 am

By creating a new database, you will also lose your entire list of customers and employees. Optionally, you can purge the order history from your existing database by using the database maintenance tool which is in the Management Utility. This will only delete the previous order history back to a certain point like 6 months or 1 year ago, or your can choose to delete the entire order history too. This will leave all of the rest of your data such as customers, employees, and menus in tact. You can also purge customers who haven't ordered within the last 2 years (or other time range) using the same tool.

----

If you still want to start from scratch, and move your menus, follow the steps below.

1. Log into the management tool and export your current menu using the Menu XML Export tool.
2. Run the server admin tool and stop the server.
3. Rename the file pospizza.PZ6 ( found in C:\POSPizza6\Server ) to old_database.PZ6
4. Delete any other .PZ6 files, but do not delete your old database (old_database.PZ6)!
5. Run the database create tool and create a new empty database.
6. Run the server admin tool and start the server.
7. Run the management tool and import your menu XML file using the Menu XML import/export tool.

Again, following the steps above, you will need to add all of your employees from scratch, and you won't have any current customers. Customers will be created with new orders.

Scott

Member
Posts: 11
Joined: Sun Jun 03, 2018 3:07 pm

Re: creating new data base

Postby franke » Mon Jan 28, 2019 6:16 pm

Thank you Scott.

Return to Database Help and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest