A schema-only collection of (Yu-Gi-Oh) definition of objects for SQL Server such as tables, stored procedures, views etc.
For continuous deployment of the ygo-database packaged as 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.
Sql Database Project should installed by default. Make sure you have SSDT(SQL Server Data Tools) installed before attempting the steps below.
$ git clone https://github.com/fablecode/ygo-database.git
- Build the solution
- Right click the ygo.database.scripts project
- Click Edit
- Follow the steps and add a connection string to the target database server
- Click publish
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>"- Visual Studio 2017
- SSDT(SQL Server Data Tools)
- Visual Studio Team Services for CI and deployment.
This project is licensed under the MIT License - see the LICENSE.md file for details.