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.

Previous Step

Manually Installing the SQL Server (Jolly Server)

Installing the default Jolly Server (Basic Installation)

Next Step

Connecting your groups to the Jolly Server

Have more questions? Submit a request

Comments

Powered by Zendesk