Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Joe Phillips
    @phillijw
    I'm looking at it but I can't seem to build the solution
    It's complaining that I don't have .net v3.5 sp1 or later installed... seems ... wrong
    I definitely have v4.0.30319 installed though
    oh, need sdk I guess
    Joe Phillips
    @phillijw
    or not. I have no idea how to build this :)
    I would love to contribute but if I can't do simple things like build in vs2017 .. eh...
    this sln is broken in other ways
    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
    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