Accessing file repository (.dataedo file) directly

Applies to: Dataedo 8.x versions, Article available also for: 10.x (current), 9.x, 7.x, 6.x, 5.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 10.x (current).

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
There are no comments. Click here to write the first comment.