Merging Databases in PCRecruiter

Before doing anything to the database that is outside of normal usage, it is highly recommended that you have a current backup of the database. When doing this procedure we recommend that you are not logged into the database. The merge may take considerable time depending on your database size, so you may wish to start the procedure at the end of a day or before a weekend.

If you are merging existing data into a blank database, you'll need to start by creating a blank database. Follow the appropriate instructions on creating a blank database below:


PCRecruiter Windows Version

New Access format database:

1. Log into PCRecruiter
2. Open the 'Utilities' menu
3. Select 'Create New Database'.
4. Click the Red Square and use the BlankNR database.
5. Click the Blue Square and give the new database a name. This is the name that will appear in the dropdown on the login screen.
6. Click the Orange Square and select a location for the database file. Give the new database a name. Use the same name as in the previous step.
7. Click Green Square to complete the process.
8. You may now use the "Select Another Database" item in the "Database" menu to test out your new database connection.

New SQL format database:

1. Log into PCRecruiter
2. Open the 'Utilities' menu
3. Select 'Create SQL Connection'.
4. Click on the 'Create Database' tab.
5. Fill in the following information:
   1. Description: Give the database a name. This name will appear in the dropdown menu on the login screen.
   2. Server: Enter the server’s IP address (e.g. 192.168.0.1)
   3. Database Name: Select the name for the database. This can be the same as the name selected for the 'Description' above. This is also the name that this database will bear in the SQL Enterprise Manager.
   4. Database Path: Use the 'Default' path in the dropdown.
   5. Backup UNC: Use the automatically defined path or specify a location.
   6. Click 'OK'
6. You will be prompted to enter your SQL password as provided to you by Main Sequence Technologies.
7. You may now use the "Select Another Database" item in the "Database" menu to test out your new database connection.
   

PCRecruiter Web Version

New Access format database:

1. In the PCRecruiter Web application, click "System" in the main menu.
2. Select the "Console: Data Locations/System Setup/Utilities" option.
3. Choose "Create New Database"
4. Select "Create New MS-Access® Database" and fill in the fields as follows:
   1. Database Description: Give the database a name. This name will appear in the dropdown menu on the login screen.
   2. Database Name: Select a name for the actual database file, usually the same as the description entered above.
   3. User Name: Create an administrative username for the new database
   4. Password: Choose a password for the selected username
   5. Copy from Other DB: Select an existing database to use as a template if you wish, or select 'Use Blank Database'.
5. Click "Save" to complete the process.

New SQL format database:

1. In the PCRecruiter Web application, click "System" in the main menu.
2. Select the "Console: Data Locations/System Setup/Utilities" option.
3. Choose "Create New Database"
4. Select "Create New SQL Server® Database" and fill in the fields as follows:
   1. Database Description: Give the database a name. This name will appear in the dropdown menu on the login screen.
   2. Database Name: Select a name for the actual database file, usually the same as the description entered above. This is also the name that this database will bear in the SQL Enterprise Manager.
   3. Network: Select "TCP/IP" unless otherwise instructed.
   4. Server IP/Name: Enter the name or IP address of your SQL server
   5. SQL User Name: Enter the SQL administrator name (default is "SA")
   6. SQL Password: Enter the password for the username entered above.
5. Click "Save"
6. The screen will reload with the database path and backup path filled in.
7. Enter the authorization code provided to you by Main Sequence Technologies.
8. Click "Save" to complete the process.

Merging Databases

1. Inside the Program Files Folder is the PCRecruiter folder. Look for a program named merge.exe or merge. Double click and open it.
2. Select the original database from the drop down menu of the source.
3. Select the new database from the drop down menu of the target.
4. Click 'Next'.
5. Everything on the list here should be checked except for 'keyword' records.
   DO NOT check this.
6. Leave the third tab as is.
7. Click 'Begin'.
8. When the process is completed, your old data should be in the new database.
   
   
   If you have any questions, contact our technical support department: support@mainsequence.net or (440) 946-5214
   
   This document is provided for information only. The information contained in this document is the position of Main Sequence Technologies as of the date of publication. This information is not a promise or guarantee nor is the accuracy of any information generated after this item is published guaranteed.
   
   This document is provided AS IS without warranty of any kind, express or implied, including but not limited to merchant ability, fitness for a particular purpose, and freedom from infringement.