Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Aug 11 15:42
    DevelopmentLeadRR commented #1440
  • Aug 11 14:23
    jzabroski closed #1622
  • Aug 11 14:23
    jzabroski commented #1622
  • Aug 11 14:09
    jzabroski closed #1614
  • Aug 11 14:09
    jzabroski locked #1614
  • Aug 11 14:09
    jzabroski commented #1614
  • Aug 11 11:20
    ademchenko commented #1614
  • Aug 05 13:11

    dependabot[bot] on nuget

    (compare)

  • Aug 05 13:11
    dependabot[bot] closed #1601
  • Aug 05 13:11
    dependabot[bot] commented #1601
  • Aug 05 13:11
    dependabot[bot] review_requested #1624
  • Aug 05 13:11
    dependabot[bot] labeled #1624
  • Aug 05 13:11

    dependabot[bot] on nuget

    Bump Oracle.ManagedDataAccess.C… (compare)

  • Aug 05 13:11
    dependabot[bot] opened #1624
  • Aug 03 19:09
    jzabroski commented #1152
  • Aug 03 18:32
    MangelMaxime commented #1152
  • Aug 03 16:36
    jzabroski commented #1152
  • Aug 03 16:35
    jzabroski commented #1152
  • Aug 03 15:51
    jzabroski commented #1623
  • Aug 03 15:47
    jzabroski edited #1623
John Zabroski
@jzabroski
It is definitely possible, as dotnet-fm allows it, so if you use In-Process Runner using the DotNet.Cli logic as a base, you should be able to just smoothly do what you describe.
alexanderbright
@alexanderbright
alexanderbright
@alexanderbright
Found RunnerOptions
So, issue resolved
Removed question
John Zabroski
@jzabroski
:thumbsup:
Simon Novak
@snovak7
@jzabroski ok, cool
Andrés Gómez
@agomezb
Hi, I have a project on .net framework 4, I would like to use fluentmigrator.
I understand I should use 2.0.7 version, where can i find samples or documentation to this version?
i.sinister
@i-sinister
Hi, I've tried using fluentmigrator with postgres and encountered a bug related to schema name handling. I've found 'related' issue and made added a comment but as bug is closed I'm not sure it was noticed. Can somebody check it, please? https://github.com/fluentmigrator/fluentmigrator/issues/771#issuecomment-673303328
John Zabroski
@jzabroski
Guys I had a crazy idea to quickly support smooth connectionless preview sql mode. Why not just create a mock IDbConnection and mock IDbTransaction? That completely removes the crazy NoOp logic that exists today. If someone tries calling ExecuteReader on a mock IDbReader we can throw an exception, too. Not perfect, but it would be a ton less work than what I had originally imagined.
allowing people to mock the conneciton might actually be a nice feature, too. Say you want to script a down migration that needs to query some system state. You could generate that through the mock by a robust interceptor like Moq. But for the core runner, we would just throw.
So, if you need to deploy something to a prod database you dont have ddl admin access to, you might be able to at least get a snapshot of some basic data and make some basic assertions.
I personally dont need anything that fancy, but one or two people have.
Simon Novak
@snovak7
@jzabroski if I use dotnet-fm, it says it doesn't support netstandard2.1 ? as it can't load library :)
reverting to netstandard2.0 looks like it works.
John Zabroski
@jzabroski
@snovak7 Hoping to fix that soon. Holiday break should give me a chance to clean some long standing stuff that is in half finished state in my jzabroski/FluentMigrator fork
You can always try to workaround library not load issues using a DirtyAssemblyResolveHelper trick, although its not really maintainable and whoever comes after you five years down the road will likely cuss you
John Zabroski
@jzabroski
Also, GitHub now seems to support copy-pasting html tables into markdown text. Sweeet
John Zabroski
@jzabroski
Also, this 2013 bug in IBM DB2 :psyduck: https://www.ibm.com/support/pages/apar/PM96007
John Zabroski
@jzabroski
Hmm... the fluentmigrator.github.io page doesnt seem to be correctly updating after AzureDevOps build success
I bet I need to click publish in the release pipeline, doh
Eivind Gussiås Løkseth
@eloekset
Fixed now, @jzabroski fluentmigrator/documentation#41
John Zabroski
@jzabroski
Great job
markjerz
@markjerz
Hi, just wondering if it's possible to have migrations auto-generated. For example, you could have two models that represented the state of your before and after databases and then get the tool to scaffold most of the fluent migrator expressions by examining the difference between the models?
Robert Williams
@RobertWilliams2000
Context: I am supporting postgres, sqlserver, & oracle.
Oracle behavior is quite a bit different with respect to DDL.
For instance if I create a stored procedure with a syntax error using Execute.Sql("Create Procedure ..."). The migration completes successfully. However the procedure is in invalid state.
Any chance someone in here has worked around issues like this in oracle and has some tips?
Robert Williams
@RobertWilliams2000
@markjerz in the past I had only used SQL Server and would utilize the visual studio data tools to generate a giant sql diff. Fluent migrator would run the script fine with a small amount of clean up and no transaction wrapping.
Rune Jacobsen
@havremunken

Hi all, I am pretty new to FluentMigrator, using it in my first project and I'm in love with the mental model etc. I have set up quite a few migrations and baked into my .Net 5 project nicely, running against a Postgres server on my local network for development.

However, time has come to deploy to production (at least test deployments), and for that, the Postgres server is on DigitalOcean's managed db thing. They require SSL and certificate usage, so I am required to do stuff to the connection establishing process to get up and running. I do the same in the EF DbContext setup, but of course FluentMigrator uses it's own stuff.

I found issue #968 which suggests to inherit from PostgresProcessor and do stuff in EnsureConnectionIsOpen() - however, I am completely blank as to what I need to do in there.

Is anyway aware of an example of how to provide a certificate for the postgres connection and handle the handshake bits?

Rune Jacobsen
@havremunken
That "anyway" in the last sentence was supposed to be an "anyone"..
Fausto Ruvalcaba
@seFausto
Hi everyone, I'm semi-new to using FluentMigrator. I do have a question that I haven't been able to find an answer or at least an opinion: Is there such thing as too many migrations? if so, should you clear your migrations and create them from scratch, with the first one being a schema build?
2 replies
Emmanuel Allende
@eallende3gis:matrix.org
[m]
hello! quick question. I need to extend PostgresGenerator. How can I achieve that? since PostgresGenerator has no parameterless constructor and I don't know what to pass to it.
Thanks!
YanerTavuz
@YanerTavuz
Hey everyone, I'm running FluentMigrator 3.2.1 and everytime I rebuild my solution when a migration has been run it seems to lock a .DLL named Microsoft.Data.SqlClient.SNI.dll.
I am using using (var scope = ServiceProvider.CreateScope()) to ensure that resources are released after running migration but to no success.
Edit: v3.2.16
YanerTavuz
@YanerTavuz
Solution that worked was to downgrade to v3.2.15
Andrew
@helmkamp
is the dotnet fm tooling compatible with .net 5?
1 reply
tjmcdevitt
@tjmcdevitt
Hi everyone I just updated from 1.2.1 to 3.1.3 - I use a batch file with all of the setting. I am now running the batch file from FluentMigrator.Console.3.1.3 but I am getting the message No migrations found. Is there anything else I need to do for this to update the database?
1 reply
wangadeketan
@wangadeketan
@fubar-coder how fluent migrator manages the dependency like i have 3 migrations A, B and C. How fluent migrator knows which file has to be executed first ?
2 replies
Alex Faizrakhmanov
@Malstraem
Hi, is it possible to find out the current migration number using the runner?
1 reply
julian-di
@julian-di
Hi, sorry to bother you but, is there a way to use fluentmigrator to retrieve the SQL migration statement at runtime / run it on request (with dynamic varaibles?) context: I need to create databases with custom names that the user inputs after program startup (and i can't use SQL queries since the db format is not know aot)
1 reply
J. Cole Brand
@jcolebrand
@jzabroski is this a good place to chat about fluentmigrator/fluentmigrator#1556 cos I have a specific question about "have you guys already discussed X elsewhere that I can see history"? Specifically, I'm not sure where to look for "have you guys ever returned an IList<AnnouncerResult> (for lack of a better model name) on the MigrateUp/MigrateDown to mirror what is done on the log extensions utility but as a return object. If you never consume it, then it just gets thrown away, and the runtime handles that, but in our case that solves the need. Honestly I'm curious where any discussions would have occurred on that and where to look for those, because if it hasn't been a case considered before, I'm happy to open a discussion/feature request (and I can help put in a PR to plumb it in if that's desired once it's deemed a worthwhile thing to add) - Hence wanting to figure out if it's been discussed before so I can know the history.
1 reply
I'm not sure who else I might tag here besides John, I just know he seems to be a key person to start with from responses I've seen on issues
Strahinja Serbula
@SerlokPK
Hello everyone, I am using fluent migrator to migrate sql DB. I have try/ catch and in try section I am calling MigrateUp. When error occurs, I want to rollback to state before MigrateUp is called (I am saving state with a VersionInfo.Latest()). When exception is caught, latest version is still as on beginning, so rollbacl/ migrateDown doesn't work. How can I achieve this behavior?
2 replies
Will
@rballonline
Trying to run migrations using the dotnet-fm command. I have dotnet-fm migrate --preview -p Oracle12cManaged -a bin/Debug/net6.0/Migrations.dll --working-directory "C:\projects\API\Migrations\bin\Debug\net6.0" but it's giving me a FluentMigrator assembly not found. Is there a way I can specify where the assembly is located?
7 replies
Carlo
@salaroglio
Hi,newbie here, is there a person who has direct experience using fluentmigrator, creating As-400 files/tables(Db2 iSeries), from a .net core project using IBM.Data.DB2.core drivers? Could you give me general advice if it is a viable way to upgrade and develop the db2 iSeries database ?
Shailesh M
@shailesh1984
Hi, I am getting below error while running dbMigrate.bat file using fluentmigrator runner and tool
"Process is terminated due to StackOverflowException"
bat file code :

@echo off
if "%1" == "rollback" goto rollback
if "%1" == "" goto migrate

goto error

:migrate
bin\Debug\netcoreapp3.1\migrate -db SqlServer2016 -connection "Server=.;Database=DbMigration;Integrated Security=true;Persist Security Info=true;" -assembly "bin\Debug\netcoreapp3.1\CakeBuild.FluentMigration.dll"
goto done

:rollback
bin\Debug\netcoreapp3.1\migrate -db SqlServer2016 -connection "Server=.;Database=DbMigration;Integrated Security=true;Persist Security Info=true;" -assembly "bin\Debug\netcoreapp3.1\CakeBuild.FluentMigration.dll" -task rollback:all
goto done

:error
echo "No valid command"

:done
echo "Completed"

image.png
Eivind Gussiås Løkseth
@eloekset
image.png
You know your NuGet package is popular when Visual Studio suggests to install it while working on a project completely without any reference to FluentMigrator whatsoever.