Convert DAT & IDX Files into MS SQL Server

Closed

Description

This is for an old customer using old windows-based SCADA system (should be around 1996) and have these file extensions. This system stored database in these DAT and IDX old file extensions. The software vendor is no longer around and we would like to do some data extraction. We do not know what software to use to read the data files. We do not know what database they are using.

The old system has a function to store all their data into these DAT and IDX file extensions as database for up to 3 months only. They want us to extract the data files and convert into MS SQL Server database otherwise the files will be deleted after 3 months auto purging.

Phase 1 is to convert DAT and IDX data files into MS SQL Server database. I will provide you a sample DAT and IDX data files to try.

Phase 2 is to sync DAT and IDX data live with MS SQL Server. Every insert, delete and update on the DAT and IDX data files will be immediately sync to MS SQL Server.

Please bit for phase 1 first for this case. Thank you.

Skills: Data Processing, PLC & SCADA, SQL

See more: dat idx, dat idx database, idx sql server, idx dat, dat idx files, sql idx file, convert idx sql, sql server idx file, dat file idx file, database dat idx, convert idx files, convert dat database sql software, sql server dat idx, idx dat files, idx sql, sql server idx files, convert dat file sql, convert idx file sql file, convert dat idx sql, idx file sql server, extract files, convert dat sql, convert dat idx files sql server, idx file sql, dat files sql server

Project ID: #4456466

28 freelancers are bidding on average $1070 for this job

Eliteprog

Hi, I am available to complete this work, I have expertise in MS Sql server files and it will not be a problem for me to implement functionality in test area. You can assign me this task and I will complete it wit More

$1181 USD in 12 days
(2 Reviews)
4.5
expertcoder1vw

Pls see PM.

$1237 USD in 5 days
(10 Reviews)
4.5
winnet21

Hi, I have experience with this project I happily if work with you in this project. Best Regards

$787 USD in 10 days
(5 Reviews)
3.6
feninsoftech

Hi, This can be achieved by designing a SSIS package that will read that files and push data in SQL Server database. SSIS package can be scheduled to run on schedule basis. I have 8 years experience in SQL Server More

$1100 USD in 20 days
(3 Reviews)
3.5
rajanlengde

I can do it well, please see PMB

$787 USD in 15 days
(5 Reviews)
3.5
ndivjak

I can do this. I have great experience with data conversion. Could You send me file examples so I can give You final estimate.

$1100 USD in 7 days
(1 Review)
2.8
FLinCanada

Depending on how the DAT files are formatted this should be possible. The IDX files may be important but are perhaps not critical. Please provide a sample of both files (a matching pair) if you can. If not, then at More

$1237 USD in 3 days
(9 Reviews)
2.8
melsayedhasan

Hello please see my message

$1100 USD in 10 days
(3 Reviews)
2.7
Reza2012

Hi I have more than nine years experience in Database Administration and Data Migration from any Database to SQL Server or Oracle. Please see PM. Thanks.

$880 USD in 10 days
(2 Reviews)
2.5
permourikis

Please send me a sample. Do you want it with the same Database Scheme or altered?

$1365 USD in 25 days
(1 Review)
1.9
srdas2012

Hi We are Expert in Database Convertion,We can give you a Aplication Either in Vb6/Vb.Net Or C# to convert the same ,Please see PMB

$772 USD in 10 days
(1 Review)
1.7
AliSafder

Hi, Please consider my proposal for this task.

$825 USD in 10 days
(2 Reviews)
1.2
tuanlm101

Hi, I have 5 years of experience with database development, data processing, query optimization, with strong T-SQL ablity. Also I have 2 years working as system programmer, expertise in reverse engineering and data fil More

$800 USD in 10 days
(1 Review)
1.1
Yefimchenko

I have an experience with conversion, converting and processing of the SCADA databases of systems.

$825 USD in 5 days
(0 Reviews)
0.0
maitrien

Hi , I am expert in SCADA System and database for SCADA . I hope you get me for this project . Please check PM

$825 USD in 5 days
(0 Reviews)
0.0
RAVICHOKKAM

I will be able to do this project. please provide the sample files of DAT and IDX so that I can extract and give it to you so that you will get confidence. Please see my private message for more details on professional More

$1375 USD in 20 days
(0 Reviews)
0.0
jwbart10

I worked worked with legacy files to SQL Server for the past 5 1/2 years. Working with all sorts of flat files and Index files. I would definitely like to see the trial files and see what we are working with.

$1100 USD in 7 days
(0 Reviews)
0.0
pedjaa

I think I can do it but first I would like to get DAT and IDX sample files.

$880 USD in 9 days
(0 Reviews)
0.0
rmullen57694

Hi, please send me a sample of the .DAT and .IDX files so I can examine them, I have bid low as I am trying to build my reputation up on this site. Regards Robert.

$825 USD in 14 days
(0 Reviews)
0.0
vickramsandeep

I'm happy to work with this project , Thank You.

$825 USD in 7 days
(0 Reviews)
0.0