avanade / dbex Goto Github PK
View Code? Open in Web Editor NEWDbEx provides database extensions for DbUp-inspired database migrations.
License: MIT License
DbEx provides database extensions for DbUp-inspired database migrations.
License: MIT License
Something like
command: init
for generating schema, stored procedures, tables etc.
This issue was automatically created by Allstar.
Security Policy Violation
Found 1 outside collaborators with admin access.
This policy requires users with this access to be members of the organisation. That way you can easily audit who has access to your repo, and if an account is compromised it can quickly be denied access to organization resources. To fix this you should either remove the user from repository-based access, or add them to the organization.
OR
If you don't see the Settings tab you probably don't have administrative access. Reach out to the administrators of the organisation to fix this issue.
OR
This issue will auto resolve when the policy is in compliance.
Issue created by Allstar. See https://github.com/ossf/allstar/ for more information. For questions specific to the repository, please contact the owner or maintainer.
Hey @chullybun
in readme there's a section for schema:
The schema scripts must be marked as embedded resources, and reside under the Schema folder within the c# project. Each script should only contain a single Create statement. Each script will be parsed to determine type so that the appropriate order can be applied.
The Schema folder is used to encourage the usage of database schemas. Therefore, directly under should be the schema name, for example dbo or Ref. Then sub-folders for the object types as per Azure Data Studio, for example Functions, Stored Procedures or Types\User-Defined Table Types.
but in code the schema scripts are also read directly from file system
DbEx/src/DbEx/Migration/DatabaseMigratorBase.cs
Lines 304 to 314 in 6142d38
Additionally the recommendation is to create a directory structure under Schema
folder, but DbEx.Test.Console
doesn't follow that:
DbEx/src/DbEx/Migration/DatabaseMigratorBase.cs
Lines 366 to 379 in 6142d38
Line 366 mentions .sql
files but 379 looks for .yml
and .yaml
The current Readme is very detailed, but misses "quick start" section.
How to start?
Add nuget dependency? Clone the repositry?
How to script an existing DB with dotnet run scriptnew
?
When DBEx is executed it outputs a full connection string with the password to standard output with many lines of logs.
The ability to limit logs to errors only or to disable them all together would be nice.
Data imported from Assemblies
needs to be reversed as described by the console output. Attempts to add, for example master data before corresponding reference data has been added.
When using nTangle I'm getting the following error when trying to generate code for a table that contains "smalldatatime". Please add support for it.
System.InvalidOperationException: 'Database data type 'smalldatetime' does not have corresponding .NET type mapping defined.'
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.