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.
28 freelancers are bidding on average $1070 for this job
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.
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.
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.