Open Source
Cryptography
Enigma MachineModern keyless cryptography using an emulated Enigma machine
CSS / SCSS
Sfumato SCSSCLI tool for generating CSS utility classes from your markup
Hosting & Deployment
FdeployCLI tool for deploying ASP.NET Core websites quickly with offline messaging
Namecheap DNSAdd and remove TXT records using the Namecheap DNS API
SQL Server
DataStoreSQL Server ORM framework for .NET Core/Standard projects
SqlPkg for SqlPackageMake Microsoft’s SqlPackage a better backup/restore tool
Statistics
BenfordExplore how Benford’s Law can detect falsified data in text or images

Open Source

Explore our contributions to the open source community.

Project Index

SQL Server

SqlPkg for SqlPackage

Database
SQL Server
Backup
CLI
Mac / Win / Linux
x64 / Arm64

SqlPkg is a 64-bit .NET command line (CLI) wrapper for the Microsoft SqlPackage CLI tool with the goal of making common backup and restore operations easier and more powerful. It does this through new Backup and Restore actions that provide additional features like the exclusion of specific table data in backups and destination prep prior to restore.

Visit the repository to see how you can install this tool to begin using it right away.

New Action Modes:

/Action:Backup
This mode is equivalent to Action:Export to create a .bacpac file, with the following differences.

Specify one or more /p:ExcludeTableData= properties to exclude specific table data from the bacpac file. The table name format is the same as the /p:TableData= property.
/SourceTrustServerCertificate: defaults to true.
/SourceTimeout: defaults to 30.
/CommandTimeout: defaults to 120.
/p:VerifyExtraction= defaults to false.
Destination file paths will be created if they do not exist.

/Action:Restore
This mode is equivalent to Action:Import to restore a .bacpac file, with the following differences.

The destination database will be purged of all user objects (tables, views, etc.) before the restoration.
If the destination database doesn't exist it will be created.
/TargetTrustServerCertificate: defaults to true.
/TargetTimeout: defaults to 30.
/CommandTimeout: defaults to 120.
Destination file paths will be created if they do not exist.

/Action:Backup-All
This mode will back up all user databases on a server.

Provide a source connection to the master database.
Provide a target file path ending with 'master.bacpac'. The path will be used as the destination for each database backup file, ignoring 'master.bacpac'.
Optionally provide a log file path ending with 'master.log'. The path will be used as the destination for each database backup log file, ignoring 'master.log'.
Accepts all arguments that the Backup action mode accepts.

/Action:Restore-All
This mode will restore all *.bacpac files in a given path to databases with the same names as the filenames.

Provide a source file path to 'master.bacpac' in the location of the bacpac files. The path will be used as the source location for each database backup file to restore, ignoring 'master.bacpac'.
Provide a target connection to the master database.
Optionally provide a log file path ending with 'master.log'. The path will be used as the destination for each database backup log file, ignoring 'master.log'.
Accepts all arguments that the Restore action mode accepts.

When not using SqlPkg special action modes, the entire argument list is simply piped to SqlPackage and will run normally. So you can use sqlpkg everywhere SqlPackage is used.

How can we help?

Whether your organization is big or small, book a conference call or request an estimate and let’s see how we can help.

Powered by Umbraco CMS with Sfumato and Tolnedra

© 2024, Fynydd LLC

Privacy Policy

By using this website you accept our privacy policy. Choose the browser data you consent to allow:

Only Required
Accept and Close