27 people following this project (follow)

Welcome to the SQL Server DAC Framework CodePlex project page!


The DAC framework provides a set of services for database developers and administrators and is currently available in two forms:

This project will contain reference implementations for both hosted services and client side tools. Check back often for updates to the downloadable samples and feel free to jump over to the forum if you need help.



Please select one of the links above to get started or continue reading if you are not sure which you should use.


Hosted Services
  • Pros
    • You do not need to install components locally and your machine is does not need to be connected to SQL Azure during import/export operations. The service tool is also xcopy deployable and has no dependencies on the DAC framework or any other components.
  • Cons
    • You have to put your bacpac in an Azure Blobstore separately (the tool does not do it for you). Additionally, the SQL Azure Import/Export unsurprisingly only works with Sql Azure. If you need to import or export to an on premise database you must use the client side tools.

Client Side Tools
  • Pros
    • Works against on-premise SQL Servers as well as SQL Azure. Additionally, also supports the file formats generated by the SQL Azure Import/Export Service so you can pass BACPACs back and forth between the client and the service.
  • Cons
    • You need to install several redistributable components on your local machine which will actually do all the work.

Last edited Sep 9 2011 at 5:30 AM by so22, version 8

Comments

daniii Jan 27 at 6:05 AM 
you have sensitive data in your line arguments (source). you know?

xmir Dec 20 2011 at 4:43 PM 
It looks there is a mistake/obsolete info on this page at "Hosted Services" >> "Cons" >> "You have to put your bacpac in an Azure Blobstore separately (the tool does not do it for you). ". The sample I downloaded (DACIESvcCli-source) seems to do that.