In most cases, an existing database will be prepared for you, containing information that has been converted from a previous database or added under the guidance of your EventPro Training & Implementation Specialist. That database will be sent to you so that you can restore it.
Before restoring the database, however, this process requires that you first create a new database with the EventPro Database Utility. The new database you are creating here is essentially a placeholder. Later, you will restore your existing database over this new "placeholder" database.
1.Run the EventPro Database Utility Wizard by selecting EventPro Data Updater from your Start Menu, or double-clicking the EventPro Data Updater application file in the folder to which you installed it.
2.On the first page of the wizard, select Create a New Client Database, and click Next.
3.Target Database: Enter the target database information.
a.Database Type: Choose MS-SQL.
b.Server: Enter the SQL Server Named Instance, identifying the network name of the computer plus the instance name you specified earlier when installing SQL Server (i.e. "SQLEXPRESS").
It will look something like this: MYDBSERVER\SQLEXPRESS
c.Authentication: Select the Authentication checkbox, which indicates that User will use SQL Authentication to connect to the SQL Server instance.
d.Enter the User Name and Password of User1 (which you created above).
e.Database: Type in (don't select from the drop-down) the name of the new database you are creating, e.g. EventProData.
The Data Updater will create 2 databases:
i.This named database (i.e. EventProData), over which you will later restore the existing, prepared database from your Training or Support Specialist.
ii.An EventProMaster database to control licensing.
f.Client I.D.: Typically, you would use your six-digit License ID for the Client I.D.
g.Cloud Data: Leave this unselected, as you are performing a Network Install of EventPro.
h.Database Data Type: From the drop-down list, choose Blank or Standard.
i.Standard means the database will be populated with some basic default data, namely Statuses, Titles, Communication References, Booth Types, Budget Types, Payment Types, Location Features, and Location Setup Types.
Clients typically choose Standard, as they find it easier than starting from a completely blank database that has no frame of reference. The pre-entered status, titles, etc. can easily be edited to suit your organization's terminology.
ii.Blank means a completely blank database, with no pre-entered data.
If you are planning to restore an existing database over this new database, it doesn't really matter which data type you select.
i.License File: Click the ellipsis (...) and browse to your license file (Licence.ini). This is the license file you downloaded earlier.
j.When you have entered all of the target database information, click Next.
4.In the last page of the wizard, click Finish.
5.You can now proceed to Restore Existing Database over New.
