Where communities thrive

Join over 1.5M+ people
Join over 100K+ communities
Free without limits
Create your own community

Explore more communities

DbUp/DbUp

DbUp is a .NET library that helps you to deploy changes to SQL Server databases. It tracks which SQL scripts have been run already, and runs the change scripts that are needed to get your database up to date.

People

Repo info

Activity

Joe Phillips

@phillijw

does anyone actually have it working? how?

Adrian Clark

@AdrianJSClark

I just cloned and built on my laptop without any errors (that was just the master branch).

If it is complaining about a framework dependency perhaps you are missing an SDK?

Joe Phillips

@phillijw

I was able to build no proglem on Win10 Pro / VS2017 Pro

but failed all over the place with Win10 Home / VS2017 Community

I don't recall manually installing any SDKs on my win10 pro machine.....

so no clue what it would be missing

Joe Phillips

@phillijw

heck yes: DbUp/DbUp#330

kind of an ugly fix but I'm not sure how else to do it :\

(without rewriting ... everything)

i'm honestly not sure how that problem wasn't affecting all sorts of other things

#169

Robert Wagner

@droyad

Which version of VS2017 do you have on each machine?

Also what are the results of dotnet --version

Pretty sure it's a .NET Core SDK problem

Joe Phillips

@phillijw

2.1.104 is dotnet --version

clrver is v4.0.30319

Joe Phillips

@phillijw

when do PRs get merged?

Paul Welter

@pwelter34

any interest in a complete EnsureDatabase feature via PR? I see that a PR was rejected before, but i feel this really does belong in DbUp.

Paul Welter

@pwelter34

nevermind, guess its there under the EnsureDatabase.For

Robert Wagner

@droyad

Any Oracle people have thoughts on https://github.com/DbUp/DbUp/pull/335#issuecomment-388785397 ?

Andrew Johns

@andrewdj

I haz questions, so I thought I should come here and ask instead of submitting an "issue"

Just wanted to confirm what "out of the box" support there is for subfolders? I notice that the "improving.DbUp" project on github "adds support to DbUp for SeedData, FirstRun, Always Run and Migrations folders" which sound sensible, has anyone used that project?

Going further, I think it makes sense to keep individual scripts small and light, e.g. multiple scripts for each table, rather than one long file. So, Within FirstRun I might have folders for 1. Tables, 2. StoredProcs, 3. Functions, 4. Users, 5. Indexes, and 6.Constraints. This would keep things tidy and easy to work with, IMO. Would I need to supply my own EmbeddedScriptProvider to find the scripts in these sub folders?

Finally, I saw in documentation that I should include "Use [DatabaseName]" at the top of these scripts, but this sounds counterintuitive. Does it not work if I just specify the database name in my connection string? Alternatively, I guess I need to use a variable in the scripts and preprocess it.

Robert Wagner

@droyad

@andrewdj I will check it in the morning. But it should say NOT to use Use at the top of the script

There should be a Folder aware script provider bundled

Andrew Johns

@andrewdj

I can't find where I saw it now, sadly. I'll try this structure tonight and see how I get on.

Do you think it's sensible to keep the constraints separate to the table creation as I've suggested? That way it ensures all the necessary tables are in place before foreign keys are added.

Robert Wagner

@droyad

Sorry, I re-read that. Yeh you could do that, the EmbeddedScriptProvider will sort things alphabetically so it will run them in the desired order

However, I think if you keep your Table, Indexes and Constraints separated you will run into trouble in the future. With that structure, it may mean you can upgrade from version 0 to N, or N-1 to N, but you'll run into conflicts when upgrading say N-10 to N

The schema (DDL) migration scripts should be a linear, identical* process that every DB you update follows.
* Except when you have branches (hopefully short lived) that make changes and then are merged (however from my experience, it is uncommon to have a conflict)

Robert Wagner

@droyad

For your other scripts, that do not change structure and do not influence how the structure can be changed (Functions, Sprocs, etc), make them repeatable, and run them every time using WithNoJournal

Andrew Johns

@andrewdj

the separation was more for the first run, after that migrations would be single scripts that applied all the necessary changes for a particular update

Joe Phillips

@phillijw

seems this is kinda out of date: https://github.com/DbUp/DbUp/releases

Lars A Brekken

@larsbrekken

Hi guys, just a heads up that I added a PR for Amazon Redshift support (DbUp/DbUp#350) and an associated issue (https://github.com/DbUp/DbUp/issues/352). Would appreciate feedback on the approach and please let me know if there's anything I can improve in order to get it considered for being merged.

João Paulo dos Santos Portela

@joaoportela

Hi! I'm looking for the docs that describes the ordering of the migrations when using WithScriptsEmbdeddedInAssembly. Does anyone know where it is?

I'm assuming it's simple "string" ordering, right?

Lars A Brekken

@larsbrekken

@joaoportela Yes, I believe that it orders it by script name. See https://github.com/DbUp/DbUp/blob/master/src/dbup-core/ScriptProviders/EmbeddedScriptsProvider.cs#L46

João Paulo dos Santos Portela

@joaoportela

thanks, 👍

strange2202

@strange2202

Has anyone used the dbup-oracle? I have used dbup and dbup-postgres and have had no issues but having trouble setting up UpgradeEngine for Oracle

Luis Alberto Carvajal Martinez

@carvajalluis

Hello everybody, is there a way to use dbup with mongodb?

Jojo Aquino

@jfaquinojr

Hows your experience with sqlite? I plan to use this for my side project but not really sure how this will fare against something like sqlite.

Andrew Johns

@andrewdj

@jfaquinojr I was using DBUp to produce scripts that deploy to SQLLite for running local tests. It worked for inline SQL with no trouble for me. It was the Stored Procedures that wouldn't work, but that's because SQLite doesn't support SPs. I presume you already know this if you're using SQLite. :)

Jojo Aquino

@jfaquinojr

@andrewdj awesome! I am not using stored procedures so, I guess there's no reason for me not to use dbup then

Matthijs ter Woord

@mterwoord

Hi All! Is this chat still active?

I'm wondering if its possible to have multiple sets of dbup scripts (and versions) inside 1 database/app?

Matthijs ter Woord

@mterwoord

Got it. can do it on mssql with different schema's. works for me!

Don Waldo

@dgwaldo

Any ideas on Invalid object name 'dbo.SchemaVersions'.??

I found all the issues related to that... DbUp/DbUp#142 & DbUp/DbUp#346

I'm using 4.3.1. with EnsureDatabase.For.SqlDatabase(connectionString); Then I run a script that does a bunch of alter statements.

Don Waldo

@dgwaldo

nuget package version only goes back to 4.0.0

Matthijs ter Woord

@mterwoord

that message is an error i guess it uses to see if it exists. does it give you an issue?

Chat via Matrix