Documentation

Table of Contents:


    Accessing file repository (.dataedo file) directly

    2018-06-07 2018-06-15
    Applies to: 7.1 (current), Article available also for: 6.3, 5.2

    Dataedo file repository is just an SQL Server Compact database - a limited edition of SQL Server that store databases in files and does not require an active instance to operate.

    You can access tables in a file repository directly just as in a server repository.

    To connect to database in .dataedo file you will need a Microsoft package, and an additional 3rd party tool.

    We highly recommend using ErikEJ's SQL CE Toolbox, as it works as a standalone application.

    To connect to your repository file, run the extracted app, then right click on the connection list and choose Add SQL Server Compact 4.0 Connection:

    Add SQLce connection

    On the next screen click Browse:

    Browse for .dataedo file

    In the bottom right change SQL Server Compact database (.sdf) to All files (*.*) , then find your .dataedo file and double click it.

    Then click Close on the bottom of the window:

    Close new connection window

    The connection list should now contain your file. You can expand it to see an object list, or right click it and choose Open SQL Edtor to run queries.

    Open editor

    Do note that in most cases you can only run a single query at a time.

    Execute queries

    Found issue with this article? Comment below
    Comments (0)