Open a RockWorks16 Project Folder - SQL Server

Each project you work with in RockWorks must have its own folder, called a Project Folder, on your computer. If you are working with a local database, the project folder is where the database resides, along with various setup files, program-generated models and graphics, etc. If you are working with a SQL Server database, this folder does not contain the data, but instead the connection to the server where the database resides. (RockWorks Advanced only.)

• To open a local (MDB-based) RockWorks16 project, the program will create a new project folder, and the MDB database from RockWorks16 will be copied and updated to the new SQLite format in the new folder. This is described in a separate topic.
• 
  
• To open a SQL-Server-based RockWorks16 project, the steps to follow are slightly different; they involve creating a new project folder in RockWorks20, and creating a new SQL-Server database, updated to the newer format. These steps are detailed below.

! This process creates a new database on the server, so if you are sharing this database with others, only one of you needs to follow these steps. Once the database has been updated to the RockWorks20 format, your colleagues can either just create a new RockWorks20 project locally and connect to that database, or (if you all share the same project folder) follow the connection steps outlined at the end of this topic.

! Any RockWorks16 datasheet (.rwDat), grid (.rwGrd), solid model (.rwMod), 2D graphic (.rw2D), 3D graphic (.rw3D) and ReportWorks (.rwRpt) files are fully usable between versions. After the project is updated, just copy these files from the RockWorks16 project folder to the RockWorks20 project folder.

! See the Troubleshooting topic for errors and warnings that you may see.

Step-by-Step Summary
Important Notes

Step-by-Step Summary

Follow these steps to open a SQL-Server-based RockWorks16 project into RockWorks20:

1. Click on the Project Folder | Create New Project menu option.

   

   
   
2. Folder tab:
   1. New Project Folder: Enter a name for a new folder where the RockWorks16 project information will be updated and re-saved. Typically this is a sub-folder in the RockWorks20 Data folder.
      ! Do not save the RockWorks20 project in the RockWorks16 project folder.
   2. Database Engine: Choose Customize the Database Engine.
   3. New Project Settings: Choose Create New Project with Data or Settings from Existing Project.
   4. Click Next.
      
3. Database Engine tab:
   1. Database Engine: Choose Microsoft SQL Server.
   2. Server: Select the name of the server where the RockWork16 database is stored.
   3. Edit Data Connection: Click this button if you wish to view the connection to the server database.
      • Click the Edit Data Source if you would like to assign a different name to the database. The default name will match the New Project Folder name from above.
      • Click OK to close the Edit Database Connection window.
   4. Click Next.
      
4. Project Template Tab:
   1. Base the New Project on the Following Project: Use this prompt to browse for the name of the RockWorks16 project folder you wish to update.
   2. To update all of the data in the RockWorks16 project, choose Use the Database structure, types tables, and borehole data.
      • Choose All boreholes to bring in all of the borehole data (enabled and disabled holes).
      • Activate the Copy Project Support Tables checkbox to bring in accessory tables such as custom color tables, cross section location tables, and similar.
      • Activate the Copy Project Menu Settings checkbox to copy over all of the menu settings from the old project.
   3. Click Next.
      
5. Project Coordinates Tab:
   1. These settings will be hard-wired to match those in your RockWorks16 project.
      
6. When you have made all of your selections, click the Finish button to proceed.
   
   The existing RockWorks16 database will be copied to the new name on the SQL Server, with all of the new-version table updates. The new project folder will be created, with the connection to the SQL Server, menu settings and other support files. You'll see the boreholes in that project now listed in the Name pane, and their data loaded into the data tables.
   
7. The next time you wish to access this project folder, simply use the Project Folder | Open Existing Project menu option.
   
8. If additional users need to access this database, please refer to the Connection Steps here.
   
   
   1. If you all share the same project folder and if you do not use separate INI files:
      • Each user can simply use the Project Folder | Open Existing Project menu option to open the new RockWorks20 project folder. This will contain all of the connection information they will need to access the new server database.
      • 
        
   2. If you all share the same project folder and if you DO use separate INI files:
      • Manually make a copy of the "menus.ini" file inside the project folder's System sub-folder.
      • Rename the "menus.ini" to have the user-specific prefix they use (example: mm_menus.ini).
      • Edit the user's INI file for any additional login and password information that your system may require.
      • Repeat this for all additional users (e.g. aa_menus.ini, mw_menus.ini, jr_menus.ini).
      • Then each user can use the Project Folder | Open Exiting Project menu option to open the new RockWorks20 project folder, and can select their specific INI file as the project is being loaded.
      • 
        
   3. If you do not share the same project folder:
      • Each user will use Project Folder | Create New Project, and create a new local project folder which will connect to the new database. They will specify Microsoft SQL Server as the database engine, select the name of the server, and use Edit Data Connection to specify the name of the database. (The default database name will match that of the project folder.)
      • 
        

Important notes:

• Models, Graphics, etc.: Note that none of the accessory files in your RockWorks16 project folder will be copied into the new project folder.
  • File Formats: The model and graphic file formats, and their file name extensions, have not changed between RockWorks16 and RockWorks20. RockWorks20 can read RockWorks16 files with no conversions. See RockWorks File Types for details.
  • Manually Copy: If you want to copy your grid models (.rwGrd files), solid models (.rwMod files), 2D graphics (.rw2D files), 3D graphics (.rw3D files), and Reportworks graphics (.rwRpt files) into the new project folder, you can do so using Windows Explorer.
  • 
    

Back to the RockWorks Projects - Overview

RockWare home page