Anatomy of SQL Server tenth Orcamdf Studio release + feature Recap (translated)

Original: Anatomy of SQL Server tenth Orcamdf Studio release + feature Recap (translated)

Anatomy of SQL Server tenth Orcamdf Studio release + feature Recap (translated)

http://improve.dk/orcamdf-studio-release-feature-recap/

Since I last made a orcamdf feature overview, 2.5 months have passed.

It's only been 2.5 months since I last had a orcamdf feature overview. I've been busy since then. Top three meetings of SQL Server:sqlbits,sqlpass,SQL Rally

Everyone is very enthusiastic about the orcamdf, and received some feedback from them, thank you all!

Although always busy, but I try to make sure not to leave Orcamdf development work

Compared to the domestic, SQL Server related meetings are too few

"SQL pass Beijing 2014 first offline activity"

New features

The following is a simple list of features that have been started since the last release

Support for multi-data file databases

Exposing meta data via standard SQL Server DMVs

Optimized performance: Byte arrays use lighter, while sharing all rows between singleton table schemas

In addition, I have added support for some additional data types

Money
SmallMoney
uniqueidentifier
User-defined Type

These new features are just a little thing, and then there's a bigger thing orcamdf Studio

Orcamdf Studio

I get some information from these feedback: it's a great project! I definitely want to try this software, but I don't have time to use it.

To be honest, the trial orcamdf will be more troublesome, you must download the source code, and compile him, but also to use their own program to call Orcamdf

I did not consider the direct end user, this is not my concern. However, in order to get more feedback on the use of orcamdf I have to improve the Orcamdf

So I decided to create Orcamdf studio-which is a UI built on top of orcamdf allows you to query user tables, DMVs, system tables without needing to look directly at the source code

What you see below is the content of the product table in a standard AdventureWorks 2008 database that Orcamdf displays for you:

system tables

Orcamdf Studio shows all the system tables (currently supported and resolvable), just like normal tables

User tables, indexes, and schemas

Finally, Orcamdf also shows all the user tables, including their schemas, Index and index schemas

Error Reporting

Whether it's orcamdf or Orcamdf Studio, the distance to the production environment is still relatively remote, you may encounter unsupported scenarios or some common mistakes

If you run into it, Orcamdf Studio will report it and save the stack information in the program directory. Here is an example of a typical error

Attempt to open a table with an unsupported XML data type column

If you look at the ErrorLog.txt file inside the program directory, you will see the following exception

 -- One- . xx: A: +----------System.ArgumentException:Unsupported Type:xml (-1) at OrcaMDF.Core.MetaData.DataColumn. ctor (string name, String type, Boolean nullable)inchD:projectsorcamdfsrcorcamdf.coremetadatadatacolumn.cs:line135At OrcaMDF.Core.MetaData.DataColumn. ctor (string name, String type)inchD:projectsorcamdfsrcorcamdf.coremetadatadatacolumn.cs:line -At OrcaMDF.Core.MetaData.DatabaseMetaData.GetEmptyDataRow (String tableName)inchD:projectsorcamdfsrcorcamdf.coremetadatadatabasemetadata.cs:line155At OrcaMDF.Core.Engine.DataScanner.ScanTable (String tableName)inchD:projectsorcamdfsrcorcamdf.coreenginedatascanner.cs:line toAt OrcaMDF.OMS.Main.loadTable (StringTable)inchD:projectsorcamdfsrcorcamdf.omsmain.cs:line158

Pop up a completely anonymous error prompt, and if you encounter an error, I would appreciate you sending ErrorLog.txt file to me to debug a potentially problematic program

All questions, bug reports, software requirements can be emailed to me

Database version Support

Orcamdf began to develop and test SQL Server R2, and some operations can be used on SQLSERVER2005

There are many errors, however, because the SQLSERVER2005 system table structure is somewhat different from the SQL Server R2 system table structure

Orcamdf is not treated differently for different versions of SQL Server, and when you use different versions, later I add an abstraction layer to support other versions of SQL Server

Open a running database

Orcamdf Studio must obtain a read lock on the database file. SQL Server holds an exclusive lock on the data file, which means that you cannot open a running database

You only have to detach the database, take the database offline, backup-restore-detach, or use a database that is not yet attached.

For subsequent releases, I will add an automatic VSS snapshot feature

System Operation Requirements
Orcamdf is built on. NET 4.0, so you need to install. NET 4.0 orcamdf Studio to work, Orcamdf Studio can run on 32-bit and 64-bit machines

Disclaimer

Once again, Orcamdf and orcamdf Studio are software for experimental use. No warranties are made as to the use of any of his risks.

Orcamdf won't write anything into your disk, so it won't modify your database files in any way. However, I strongly recommend that you do not use him on the production database

Orcamdf do not know and do not care about information security, Orcamdf no permission system, no matter who owns the schema and objects, Orcamdf will parse him

This parsing does not require a user name and password. However, Orcamdf does not support data that is transparent to the database to encrypt TDE, so the data in the TDE library is not supported

Download

You can download the binary release code for ORCAMDF studio from the GitHub project page. Please do not download orcamdf from other places, as these places above the

Orcamdf source code may have been modified by others. You should always get the source code from the GitHub project page

Once you download the orcamdf, you need to execute the OrcaMDF.OMS.exe program

Note: This is the debug version of the PDB file in debug mode. The debug version is slightly lower than the release version, but he allows me to get a complete stack trace when the exception occurs.

Once the ORCAMDF has stabilized, I will provide debug and release versions

End of the tenth chapter

Anatomy of SQL Server tenth Orcamdf Studio release + feature Recap (translated)