Database Administrators Asked by xirt on October 28, 2021
We have a "database" that stores historical data in what could effectively be called a highly compressed proprietary "flat file" format. Typically these are accessed and queried using some C++ code that accesses the files directly.
We would like to provide access to the data to a third party who would like to use SQL queries (e.g. MSSQL).
Are there tools, libraries, or software packages that we can use to present an interface, ideally something that could be connected to using MS SQL Server Management Studio to develop queries that when run, run against our flat file data (short of importing the data into a SQL database).
I have heard rumors of such tools but haven’t seen anything yet in practice.
Possible solutions:
On the other hand I don't think that compression you are using will be much better than columnstore compression, so I would advise to reevaluate storing this in SQL Server itself.
Answered by Piotr on October 28, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP