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
    ^ thanks. Ended up realizing that before your response
    works like a charm
    I should probably blog about how I'm setting all this up. I've used other systems before and I'm taking some things I learned from those and applying it with dbup
    I can say that I honestly disagree with the sentiment that "ssdt sucks" though. SSDT is actually really really powerful and good and it lets you spit out sql change scripts if you don't trust the automatic deployment features. Modeling the objects in sql is the easiest to work with that I've found so far
    i'll share my experience once I have everything set up
    Joe Phillips
    @phillijw
    Anyone around? I'm having trouble with the mysql beta. I have a DROP/CREATE script which errors out with a dumb message. It works fine in dbForge studio though
    Joe Phillips
    @phillijw
    Ugh. I wish this had unit tests so I could debug
    Joe Phillips
    @phillijw
    It seems that it can't handle comments? wut
    oh, there has to be a space after the -- in mysql? ugh
    perhaps there is or should be a mode I can enable to be verbose in what sql its running because whatever its trying to run is completely broken if I use DELIMITER anywhere
    Paul Welter
    @pwelter34
    there a target date on the dbup-mysql 4.0 nuget package release? All the other packages were released.
    Robert Wagner
    @droyad
    No, sorry. The only thing holding itt up is DbUp/DbUp#169
    I currently don't have the time to look into that, but would welcome a PR
    Joe Phillips
    @phillijw
    Seems easy to fix. Maybe if I knew where to start I could take a look?
    Adrian Clark
    @AdrianJSClark
    @phillijw I think the issue is around the MySqlCommandReader (https://github.com/DbUp/DbUp/blob/master/src/dbup-mysql/MySqlCommandReader.cs) so perhaps start there.
    Robert Wagner
    @droyad
    Added a note where I think it is to the Issue
    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.