Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

RSS

dacpac (2) Versions 0.1.1

Deploys dacpac files

Berkshelf/Librarian
Policyfile
Knife
cookbook 'dacpac', '~> 0.1.1'
cookbook 'dacpac', '~> 0.1.1', :supermarket
knife cookbook site install dacpac
knife cookbook site download dacpac
README
Dependencies
Changelog
Quality 33%

Description

Provides database tools for deploy Visual Studio database projects. Use the DacServices tools of the SQL Server Data Tools package

Requirements

Platform

  • Windows 7
  • Windows 8
  • Windows Server 2008 (R1, R2)
  • Windows Server 2012
  • Windows Server 2012R2

Cookbooks

  • dacpac

Attributes

Resource/Provider

dacpac_deploy

Deploys a dacpac file to a database.

Actions

  • :deploy - deploy a dac package to a database.

Attribute Parameters

  • name - name attribute. Name of the process to be executed.
  • path - path of the dacpac file.
  • connection_string - SQL Server connection string. Example: "Data Source=localhost;User ID=sa;Password=***;"
  • database_name - name of the database where the dacpac file will be deployed
  • publish_file_path - path of the XML file that contains the deploy options. It could be in the cookbook files subdir, use the cookbook_file resource to extract it.

Examples

# deploy a dacpac file
dacpac_deploy "AdventureWorks" do
  path  "C:\\chef\chef_cache\\dacpac\\AdventureWorks.dacpac"
  connection_string "Data Source=localhost;User ID=sa;Password=***;"
  database_name "AdventureWorks"
  publish_file_path "C:\\chef\chef_cache\\dacpac\\database-deploy-options.xml"
  action :deploy
end

dacpac_backup

Backup a database using SQL Server Full backup method.

Actions

  • :backup - Makes a backup of a SQL Server database.

Attribute Parameters

attribute :instance, :kind_of => String attribute :login, :kind_of => String attribute :password, :kind_of => String attribute :database_name, :kind_of => String attribute :path, :kind_of => String

  • name - name attribute. Name of the process to be executed.
  • path - path where the backup file will be stored.
  • login - user name of the database
  • login - user name of the database
  • password - password of the user to login
  • database_name - name of the database where the dacpac file will be deployed

Examples

# backup a SQL Server database
now = Time.now.strftime("%Y%m%d%H%M%S")
database_name = "AdventureWorks"
dacpac_backup "AdventureWorks" do
  path  "C:\\DATABASES\\BACKUP\\#{database_name}_#{now}.bak"
  instance "localhost"
  login "sa"
  password "***"
  database_name "#{database_name}"
  action :backup
end

License and Author

Copyright:: 2015, SuiGeneris S.A.

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Dependent cookbooks

windows >= 1.34.6

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

dacpac CHANGELOG

This file is used to list changes made in each version of the dacpac cookbook.

0.1.0

  • [Alfonso Aguilar] - Initial release of dacpac

Check the Markdown Syntax Guide for help with Markdown.

The Github Flavored Markdown page describes the differences between markdown on github and standard markdown.

Collaborator Number Metric
            

0.1.1 failed this metric

Failure: Cookbook has 0 collaborators. A cookbook must have at least 2 collaborators to pass this metric.

Contributing File Metric
            

0.1.1 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Foodcritic Metric
            

0.1.1 failed this metric

FC017: LWRP does not notify when updated: dacpac/providers/backup.rb:26
FC017: LWRP does not notify when updated: dacpac/providers/deploy.rb:26
FC017: LWRP does not notify when updated: dacpac/providers/restore.rb:26
FC059: LWRP provider does not declare use_inline_resources: dacpac/providers/backup.rb:1
FC059: LWRP provider does not declare use_inline_resources: dacpac/providers/deploy.rb:1
FC059: LWRP provider does not declare use_inline_resources: dacpac/providers/restore.rb:1
FC064: Ensure issues_url is set in metadata: dacpac/metadata.rb:1
FC065: Ensure source_url is set in metadata: dacpac/metadata.rb:1
FC066: Ensure chef_version is set in metadata: dacpac/metadata.rb:1
FC074: LWRP should use DSL to define resource's default action: dacpac/resources/backup.rb:1
FC074: LWRP should use DSL to define resource's default action: dacpac/resources/deploy.rb:1
FC074: LWRP should use DSL to define resource's default action: dacpac/resources/restore.rb:1
Run with Foodcritic Version 12.0.1 with tags metadata,correctness ~FC031 ~FC045 and failure tags any

License Metric
            

0.1.1 failed this metric

dacpac does not have a valid open source license.
Acceptable licenses include Apache-2.0, apachev2, Apache 2.0, MIT, mit, GPL-2.0, gplv2, GNU Public License 2.0, GPL-3.0, gplv3, GNU Public License 3.0.

No Binaries Metric
            

0.1.1 passed this metric

Publish Metric
            

0.1.1 passed this metric

Supported Platforms Metric
            

0.1.1 passed this metric

Testing File Metric
            

0.1.1 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric
            

0.1.1 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number