{"repo":"ycherkes/OrcaSql","free":true,"listed":false,"github":"https://github.com/ycherkes/OrcaSql","clone":"git clone https://github.com/ycherkes/OrcaSql.git","description":"A C# parser for MDF files. Allows you to read tables, metadata and indexes from MDF files without it being attached to a running SQL Server instance.","language":"C#","stars":23,"topics":["sql","server","database","file","format","backup"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"This repository has reached the maintenance state: \" You need it, you fix it \". If you find a bug or need a new feature , please feel free to create a Pull Request. OrcaSql ======= OrcaSql is a parser for Microsoft SQL Server data files. It allows you to read SQL Server data files without the use of SQL Server. This solution is based on existing Mark's S. Rasmussen repository https://github.com/improvedk/OrcaMDF with the following enhancements: - modern data types support (Xml, HierarchyId, Geography, Geometry, DateTime2, DateTimeOffset); - improved formatting of the data shown in grid; - caching system tables only; - large databases support (tested on the Stack Overflow 2014 database https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/); - schema added to names of the tables and data types; - fixed some bugs (like usage of pg first - it works mainly for the sample DBs, but doesn't for real DBs, bug with multiple bit columns - https://github.com/improvedk/OrcaMDF/issues/32 etc.); - ability to generate an SQL script to fix corrupted page of database based on the page data from the file; - ability to export the data of the table from the backup to the SQL Server for further analysis; - columns with zero physical length (with default constraints); - skipping dropped column data; - skipping ghost ang ghost forwarded records; - external plugins support; - collation support; - SQL syntax highlighting; - similar to SSMS NULL value hig","default_branch":null,"files":null,"tree":[],"storefront":"/r/ycherkes","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ycherkes/OrcaSql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}