Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
OpenGround Wiki How To Convert SQL Databases to Access format for use with the OpenGround Importer
    • Sign In
    • -OpenGround Wiki
      • -Applications
        • +Admin Portal
        • +Civil 3D Extension
        • +Data Collector
        • +Data Entry Module
        • +Excel Extension
        • +Launcher
        • +Power BI Connector
        • -Professional
          • Professional Release Notes
          • -Professional How To's
            • Changing the Default Quicklog Template
            • How can a GPS file be prepared for import
            • How Do Material Symbols (Legend Codes) Work
            • How is it Possible to Show the Coordinate System for the Project on Log Output
            • How Should I Be Using a 'Primary Controller' When Entering Data
            • How to add a SHP file
            • How To add a Watermark for 'DRAFT' to a log
            • How To Add Hatch Patterns to New Geologies
            • How To Adjust the Project Extents
            • How to Apply Column Sorting and Ordering
            • How to Apply Column Styling
            • How to Apply Grouping to Grids
            • How to Arrange and Customise the Interface
            • How To Assign a colour to geology codes
            • How To Assign Point Symbols and Connector Symbols to Picklists
            • How To Change the Appearance of Shape Files
            • How to Change the Data Report Type for Numeric Values
            • How to change the default logo that appears on a Template
            • How To Change the Location Symbols
            • How To change the range of depths displayed on each page of a log
            • How To Convert SQL Databases to Access format for use with the OpenGround Importer
            • How To create a Location Group
            • How To Create a Location Group from the Map
            • How to create a User Defined Field
            • How to create labels for location groups on the map
            • How to Determine CSV File Headers
            • How to do a basic Export of AGS data
            • How to edit or add items to a Picklist
            • How To Enable Additional Coordinate Systems for New Projects
            • How To Enable Environmental Laboratory Testing Grids
            • How to enter Pipe Records
            • How To Enter Special Characters
            • How To Exclude a document in an AGS Export
            • How to Export table from the model without associated picklists
            • How to Find a Project
            • How to freeze the columns within a grid
            • How to generate a Quick Log
            • How To Get a Laboratory XML file for Scheduling from KeyLAB
            • How To Get Started with the Grid Interface
            • How To Get Started with the Project Explorer Interface
            • How To Get Started with the Ribbon Interface
            • How To Import a Component File and Delete a Component File
            • How to import documents as bulk
            • How To Import Large Files
            • How To Import new Geology Code Images
            • How To Import Your Project Archive
            • How to jump to a specific grid page within a project
            • How To Manually add a coordinate system
            • How to move all data from one project to a new one based on a different configuration pack
            • How To Perform a Bulk Update
            • How to Search the Map
            • How to set a user up to be able to create projects and be the Project Manager of that Project
            • How To set up installation instrument drawing types
            • How to setup a security group that can create projects and edit the data
            • How To Show Mapping and Aerial Photography
            • How To Use a Case Sensitive Search to Create Geology Code 2 data automatically
            • How To Use Color Coding for Material Graphics
            • How to use FILE_FSET to export/import documents with AGS data.
            • How to use Grid Filters
            • How to use the Data Entry Feedback Tool
            • How to use the Project Explorer to Filter Data
            • How to Use the Reports Section of the Project Explorer
            • How to Work with Location Groups and Saved Searches
            • How to Work with Project Picklists
            • Adding your own Coordinate Systems manually in OpenGround Cloud
            • How to edit the Transfer Mapping should you need to map a field.
            • How To Remove the Project Locks for Import
            • How to Use Scheduleing and Chain of Custody in OpenGround
            • How to Manage Laboratories and Tests for Scheduling
            • How to use the Restrict User's Permissions on Project Creation
          • +Professional FAQ's
          • +Professional Common Issues
          • +Professional User Guide
        • +Template Studio
        • +Upload Portal
        • +Web API and Task Service
        • +Web Portal
      • +Guides and Learning
      • OpenGround Supported Platforms
      • +How To Contact Support
      • Component Center
      • Events
      • Training Guides
      • +Developer Resources

     
     Questions about this article, topic, or product? Click here. 

    How To Convert SQL Databases to Access format for use with the OpenGround Importer

    Explanation

    Users who have migrated over from previously used competitor software such as gINT or GeoDASY may find use of the OpenGround bulk import tool. In order for OpenGround to bulk import data from these applications, the database must be in Microsoft Access format. Therefore if you have a database that is in Microsoft SQL format, this will need to be converted to allow for OpenGround to read the data.

    Process

    Below are the steps on how to complete this;

    (Note that these steps are for Microsoft SQL Server Management Studio 2014, steps in other versions may vary but should follow the same process)so note that Microsoft Access is required on the machine that is running this process.

    1. Open Microsoft SQL Server Management Studio and login to the instance that contains the required database.

    2. Right click on the database name in the list and select Tasks -> Export Data.

    3. The SQL Server Import and Export Wizard will then appear, select Next.

    4. Select SQL Server Native Client 11.0 in the drop down list at the top and ensure the server\instance name is correct with the required authentication, and that the correct database is listed as below;

    5. Ensure that Microsoft Access (Microsoft Jet Database Engine) is selected from the top and select the browse button.

    6. When the browse window appears, find a suitable place to store the new database, then right click anywhere in the open window and right click -> New -> Access Database.

    7. Access will then open, ensure that the Type is listed as Microsoft Access Databases 2000 format (*.mdb) and click create. Close Access.

    8. Once this has been created, select the new database, then select open.

    9. Click on Next.

    10. Select Copy data from one or more tables or views, then select Next.

    11. Ensure that all of the tables of data that are to be exported are selected and select Next.

    12. Click Next again.

    13. Ensure that Run Immediately is checked and select Finish.

    The database should then export and all of the data be available to OpenGround Cloud.

    • Share
    • History
    • More
    • Cancel
    • Stephen Evason Created by Bentley Colleague Stephen Evason
    • When: Tue, Mar 23 2021 5:46 AM
    • Marie-Claude Dubé Last revision by Bentley Colleague Marie-Claude Dubé
    • When: Fri, Nov 26 2021 3:01 PM
    • Revisions: 2
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies