A variation of this question came up a few weeks ago on a mail list that I subscribe to and it seems to come up a lot. "Can SQL Server distinguish a which connections use connection pooling?" The answer depends on how you ask the question, and I've tried to ask it in such a way […]
Bob Beauchemin
SQL Server Blog
SQL Server and Pooled vs. Non-pooled connections
Posted on: May 26, 2012 5:08 pm
DACFx 3.0 – Import and Export with BACPACs
Posted on: May 22, 2012 10:12 am
The last piece of the DAC puzzle (at least for now) is import and export. Export makes a non-transactionally consistant copy of database content that uses the BACPAC format (schema and data) and Import creates a new database with the BACPAC schema and data. Currently, its the most-used method of backing up and restoring a […]
DACFx 3.0: The new file formats
Posted on: May 17, 2012 11:58 am
In the last posting, I talked about the differences between DACFx 3.0 and previous versions from an API point of view. This time, I'll look at the files in a DACPAC and see how those differ. DACPAC really stores a database model, that can be used to recreate the database and server (3.0 only) objects in the […]
DACFx 3.0: The new programming API
Posted on: May 16, 2012 12:10 pm
Looking at the API and at the serialized form (i.e. the DACPAC), it turns out that DACFx 3.0 is not just "DAC V-next". It's an entire quantum change from all other versions, including DAC 2.0, the version that introduced the BACPAC (serialized schema and data). This has some interesting repercussions with compatibility. Let's start with the […]
Scripting SQL Server databases sans SMO Scripter
Posted on: May 10, 2012 11:38 am
I can script out a database schema (and optionally data) from SQL Server databases. Any version from 2005 and beyond, as well as SQL Azure Database. And most all instance level objects. And I'm not the SMO scripter object. Or a DBA. Who am I? I would be DACFx 3.0. And I can do some things (unlike […]
