Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    I've pinged Chris to ask if he can officially add that code
    That method is included in for Sql Server and one other database that I can't remember offhand, so the documentation is correct but unclear
    Joe Phillips
    @phillijw
    cool
    Joe Phillips
    @phillijw
    anyone around?
    Running into this weird problem. I want to be able to deploy to multiple databases using a for loop. I am trying to call connection.ChangeDatabase("my_db_name") and then use connection.ConnectionString in the DeployChanges.To.MySqlDatabase(right_here).... but it doesn't specify the DB in that connection string which means it doesn't get used
    anyone know a way around that?
    Robert Wagner
    @droyad
    @phillijw I suspect the ChangeDatabase command just switches the database for the current connection, the connection string would not be affected as that's only used to establish the connections.
    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?