Hello, I have a SQL Server 2005 installed and I should import datas from .EDBTbl files (I also have .EDBIdx files).

Is it possible to import data in a SQL Server database from the physical files?

Or is it possible to export data in some compatible way from ElevateDB?

Thank you.

Are you end-user whose application has these files? You should contact original author of the application as they might have done something for this already.

Generically though If it's just a one time migration then EDB has a built-in export capability where the table can be exported into a delimited files (CSV for example) and then you just import it direct into SQL. Easiest to do this would likely be just to use the EDBManager.

If you need a regular process then EDB has a ODBC and .net data provider available that would allow live table access using those technologies.

Raul


<<FabioSigma wrote:

Hello, I have a SQL Server 2005 installed and I should import datas from .EDBTbl files (I also have .EDBIdx files).

Is it possible to import data in a SQL Server database from the physical files?

Or is it possible to export data in some compatible way from ElevateDB?

Thank you.
>>

I need to migrate datas from physical files to anything else (the final step will be to move them in SQL Server, but I have no problem to have them on CSV files or something else).

The datas are my properties, but I have no access to EDB tools or server because I'm now without the author of it.

You can download a eval copy of the EDBManager from this address  :
http://www.elevatesoft.com/download?category=edb

It allows data export/import to comma delimited file.

(you will need to register i think) and then look for ElevateDB-ADD
download. There are number of versions so i do not know what version
your data is and whether it's unicode or non unicode version so i would
start with latest (2.09 build 1) and try both versions.

Note that optionally EDB allows data encryption using password - if in
your case password is in use then you'd need to obtain the password from
developer.

Raul


On 9/5/2012 10:06 AM, FabioSigma wrote:
> I need to migrate datas from physical files to anything else (the final step will be to move them in SQL Server, but I have no problem to have them on CSV files or something else).
>
> The datas are my properties, but I have no access to EDB tools or server because I'm now without the author of it.
>