Ygo-database

A schema-only collection of (Yu-Gi-Oh) definition of objects for SQL Server such as tables, stored procedures, views etc.

Why?

For continuous deployment of the ygo-database packaged as a DACPAC.

What is a DACPAC?

A collection of definitions of objects that one could find in a SQL Server database such as tables, stored procedures, views plus some instance level objects such as logins. Official Microsoft definition:

A DAC is a self-contained unit of SQL Server database deployment that enables data-tier developers and database administrators to package SQL Server objects into a portable artifact called a DAC package, also known as a DACPAC.

Prerequisite

Sql Database Project should installed by default. Make sure you have SSDT(SQL Server Data Tools) installed before attempting the steps below.

Installing

 $ git clone https://github.com/fablecode/ygo-database.git

1. Build the solution
2. Right click the ygo.database.scripts project
3. Click Edit
4. Follow the steps and add a connection string to the target database server
5. Click publish

Deploy with SqlPackage

SqlPackage.exe is a command line utility that automates the following database development tasks. Here's what my command line syntax would be:

  SqlPackage /Action:Publish 
   /SourceFile:"ygo.database.scripts.dacpac" 
   /TargetDatabaseName:ygo 
   /TargetServerName:"<YourDatabaseServer>"

Built With

• Visual Studio 2017
• SSDT(SQL Server Data Tools)
• Visual Studio Team Services for CI and deployment.

License

This project is licensed under the MIT License - see the LICENSE.md file for details.