Note: several of the how to guides were written for a specific Jolly product, but the concepts and techniques discussed in each guide typically apply to other Jolly products.

SQL Server Installation
  1. Download SQL Server 2008 R2 Management Studio
  2. Select ‘New installation…’ as indicated below:

                           moving_1.png

  3. Select ‘Next,’ keeping the default ‘New installation…’ option selected:

                           moving_2.png

  4. Accept the terms and select ‘Next’:

                           moving_3.png

  5. Keep the defaults and select ‘Next’:

                           moving_4.png

  6. Give the server instance a name of your choice and select ‘Next,’ here we have entered ‘TrackDatabase’:

                           moving_5.png

  7. Keep the defaults and select ‘Next’:

                           moving_6.png

  8. Set your choice of username and password authentication methods, here we allow ‘Windows authentication mode’. Select ‘Next’:

                           moving_7.png

  9. Select ‘Next’:

                           moving_8.png

  10. Installation is complete, select ‘Close’ and exit the installer:

                           moving_9.png

 

 

Importing Data from the Internal Jolly Server

Selecting a Data Source (Windows 32-bit)

  1. From the Start menu, select ‘Import and Export Data (32-bit)’:

                           moving_10.png

  2. Select ‘Next’:

                           moving_11.png

  3. Select ‘Microsoft Access’ from the data source menu. Browse to the internal Jolly Server database file, this is located at C:\Program Files (x86)\Jolly Technologies\YOUR_SOFTWARE_HERE\Sample Databases\Sample Database.mdb. Select ‘Next’:

                           moving_12.png

Selecting a Data Source (Windows 64-bit)

  1. From the Start menu, select ‘Import and Export Data (64-bit)’:

                           moving_13.png

  2. Select ‘Next’:

                           moving_14.png

  3. Select ‘Microsoft Office 12.0 Access Database Engine OLE DB Provider’ from the ‘Data Source’ drop-down box. Select ‘Properties’:

                           moving_15.png

  4. Type the location of the internal Jolly Server database file into the ‘Data Source’ box. The database file is located at C:\Program Files (x86)\Jolly Technologies\YOUR_SOFTWARE_HERE\Sample Databases\Sample Database.mdb. Select ‘OK’:

                           moving_16.png

  5. Select ‘Next’:

                           moving_17.png

Selecting a Data Destination

  1. Select the server name from the drop-down box. Choose the name that includes the instance name you chose earlier and enter the username and password information you set earlier. Select ‘New’:

                           moving_18.png

  2. Name the database; here we use the name of the software. Select ‘OK’:

                           moving_19.png

  3. Select ‘Next’:

                           moving_20.png

  4. Keep the default selection and select ‘Next’:

                           moving_21.png

  5. Select the top checkbox to select all tables:

                           moving_22.png

  6. Select ‘Next’:

                           moving_23.png

  7. Select ‘Next’:

                           moving_24.png

  8. Select ‘Finish’:

                           moving_25.png

  9. The data has been imported, select ‘Close’:

                           moving_26.png

 

 

Adjusting Table Primary Keys

  1. From the Start menu, open ‘SQL Server Management Studio’:

                           moving_27.png

  2. Select the server name from the drop-down box; use the option that includes the server instance name. Enter the username and password settings you chose earlier, and then select ‘Connect’:

                           moving_28.png

  3. Navigate to the ‘Tables’ folder:

                           moving_29.png

  4. Navigate to the ‘Columns’ folder of a table you intend to use. Here we use the ‘Employee’ table:

                           moving_30.png

  5. Right-click the ‘IDNumber’ field and select ‘Modify’:

                           moving_31.png

  6. Right-click the ‘IDNumber’ field and select ‘Set Primary Key’:

                           moving_32.png

  7. Scroll down in the ‘Column Properties’ area and expand the ‘Identity Specification’ field. Change ‘(Is Identity)’ to ‘Yes’:

                           moving_33.png

  8. Repeat steps 4-7 for each table you intend to use (do this for all tables if you are unsure).
  9. Save the changes:

                           moving_34.png

  10. If you see the following error message, select ‘Cancel’ and follow the remaining steps in this section. If you do not see an error message, exit and continue to the next section.

                           moving_35.png

  11. Open Tools > Options and navigate to ‘Table and Database Designers’:

                           moving_36.png

  12. Uncheck ‘Prevent saving changes that require table re-creation’ and then select ‘OK’:

                           moving_37.png

  13. Save the changes and exit.
Point the Software to the SQL Server
  1. Open the software to the main menu using an administrator account.
  2. Open the group properties:

                           moving_38.png

  3. Keep note of the table name displayed at the end of the existing settings box and then select ‘Configure’:

                           moving_39.png

  4. Select ‘OLE DB: Connection String’ from the Database Type drop-down menu then select ‘Build’:

                           moving_40.png

  5. Select ‘SQL Server Native Client 10.0’ and then select ‘Next’:

                           moving_41.png

  6. Select the server name from the drop-down box; use the option that includes the server instance name. Enter the username and password settings you chose earlier. Select the database from the list and select ‘OK’:

                           moving_42.png

  7. Set the login/password information, select the table name that was recorded from the settings menu previously, and then select ‘OK’:

                           moving_43.png

  8. Select ‘Yes’:

                           moving_44.png

  9. Select ‘No’:

                           moving_45.png

  10. Select ‘Yes’:

                           moving_46.png

  11. Select ‘Ok’ and setup for this group is done:

                           moving_47.png

  12. Repeat steps 2-11 for each group that you have in the software.
Contact Us

1510 Fashion Island Blvd, Ste 102
San Mateo, CA 94404
US Tel: 650 594 5955
EMEA Tel: +44 0115 853 2698
AU Tel: +61 1300 857 750

Office Locations