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.
Bu iş için 28 freelancer ortalamada $1070 teklif veriyor
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 Daha Fazla
Hi, I have experience with this project I happily if work with you in this project. Best Regards
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 Daha Fazla
I can do this. I have great experience with data conversion. Could You send me file examples so I can give You final estimate.
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 Daha Fazla
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.
Please send me a sample. Do you want it with the same Database Scheme or altered?
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
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 Daha Fazla
Hi , I am expert in SCADA System and database for SCADA . I hope you get me for this project . Please check PM
We have extensive experience in data processing and analysis, as well as in development for and administration of MS SQL Server. In this project we will use Python for binary files processing and pymssql module for Daha Fazla
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.
I'm happy to work with this project , Thank You.
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 Daha Fazla