Specific version of MySql.Data Dependency

[efaruk]

You have used ilmerge to merge required assemblies but this is not a good practice in this case. Because you have referenced specific version of MySql.Data (Actually all referenced 3rd parties are same). If have more up-to-date version of MySql on my system, this won't work.

<provider name="mysql" description="MySQL, MySQL provider 1.0.7.30072" assemblyName="MySql.Data, Version=1.0.7.30072, Culture=neutral, PublicKeyToken=c5687fc88969c44d" connectionClass="MySql.Data.MySqlClient.MySqlConnection" />

You can remove "Version=1.0.7.30072," par of the assemblyName registration. There is no difference for you because important part is PublicKeyToken.

I'm strongly encouraging you to remove version information from assemblyName registration.

Also, you guys need well formed documentation very very badly... I'have rebuilt (directly from vs in debug mode) the project to override dependencies with what I have currently. But unfortunately its not working... It shows, job done, but actually it is not. There is no table created...

But I'm strongly recommend you guys publish your work with dependencies without merging in it. You don't have any inexperienced customers...

Thanks, regards... efaruk

[brunomlopes]

Hi,

I was just doing some work and I think I'll have a better solution for you. Instead of just relying on the merged dbproviders.xml, we'll be able to place a dbproviders.xml either together with the assembly or the current path and it should pick those up instead of the embedded version.

This should allow you to override without having to recompile.

As far as documentation, I won't make any promises, but we can try to improve it. If you care to take a stab at it, feel free to contribute some documentation.

As your bug, you mention mysql, but you're using mssql in the screenshot. Is that correct?

[brunomlopes]

Actually, I'll follow through and not include a version on the default assembly. I'm testing internally how this works out.

[efaruk]

Actually, I tried both, on mysql I had reference specific version issue which I mentioned and second issue with mssql is (screen shot) tool says it succeed the process but it is not...

Thanks, Regards... EFP

On Sat, Sep 27, 2014 at 11:33 PM, Bruno Lopes [email protected] wrote:

Hi,

I was just doing some work and I think I'll have a better solution for you. Instead of just relying on the merged dbproviders.xml, we'll be able to place a dbproviders.xml either together with the assembly or the current path and it should pick those up instead of the embedded version.

This should allow you to override without having to recompile.

As far as documentation, I won't make any promises, but we can try to improve it. If you care to take a stab at it, feel free to contribute some documentation.

As your bug, you mention mysql, but you're using mssql in the screenshot. Is that correct?

— Reply to this email directly or view it on GitHub https://github.com/brunomlopes/dbdeploy.net/issues/7#issuecomment-57064836 .

[gapin]

Hi, I have try this tool, after assemblyBinding for the latest MySql.Data assembly version.

But I'm getting "Incorrect table definition; there can be only one auto column and it must be defined as a key" when trying to create ChangeLog table.

Do you know why? Am I doing something wrong? Does this tool really work with MySql server?

Thanks

[brunomlopes]

Hi @gapin, Can you confirm which version of mysql you're using on the server side so I can try to reproduce on my end?

Thanks

[gapin]

Hi @brunomlopes! The MySql server version is 5.6.19.

Thanks

[gapin]

Bruno?

[brunomlopes]

Apologies. I did some changes and it should now work, but I don't work regularly with mysql. Can you give the version up at https://bintray.com/brunomlopes/generic/dbdeploy.NET/2.2.0.4/view?sort=&order=#filesa go?

[gapin]

Hi Bruno! I needed to change from: @"INSERT INTO {0} (Folder, ScriptNumber, ScriptName, StartDate, CompleteDate, AppliedBy, ScriptStatus, ScriptOutput) VALUES (@1, @2, @3, {1}, {2}, {3}, @4, @5) \r\n SELECT ChangeId FROM {0} WHERE Folder = @1 and ScriptNumber = @2", To: @"INSERT INTO {0} (Folder, ScriptNumber, ScriptName, StartDate, CompleteDate, AppliedBy, ScriptStatus, ScriptOutput) VALUES (@1, @2, @3, {1}, {2}, {3}, @4, @5); SELECT ChangeId FROM {0} WHERE Folder = @1 and ScriptNumber = @2",

And it seems to work now... I'll try harder later and keep you updated!

Thanks!

[brunomlopes]

Great!

Where did you change that? It looks like it should use the default delimiter there, I think.

On Sun, Jan 3, 2016 at 8:10 PM, gapin [email protected] wrote:

Hi Bruno! I needed to change from: @"INSERT INTO {0} (Folder, ScriptNumber, ScriptName, StartDate, CompleteDate, AppliedBy, ScriptStatus, ScriptOutput) VALUES (@1 https://github.com/1, @2 https://github.com/2, @3 https://github.com/3, {1}, {2}, {3}, @4 https://github.com/4, @5 https://github.com/5) \r\n SELECT ChangeId FROM {0} WHERE Folder = @1 https://github.com/1 and ScriptNumber = @2 https://github.com/2", To: @"INSERT INTO {0} (Folder, ScriptNumber, ScriptName, StartDate, CompleteDate, AppliedBy, ScriptStatus, ScriptOutput) VALUES (@1 https://github.com/1, @2 https://github.com/2, @3 https://github.com/3, {1}, {2}, {3}, @4 https://github.com/4, @5 https://github.com/5); SELECT ChangeId FROM {0} WHERE Folder = @1 https://github.com/1 and ScriptNumber = @2 https://github.com/2",

And it seems to work now... I'll try harder later and keep you updated!

Thanks!

— Reply to this email directly or view it on GitHub https://github.com/brunomlopes/dbdeploy.net/issues/7#issuecomment-168537024 .

[gapin]

Yes, that's right! \dbdeploy.net\src\Net.Sf.Dbdeploy\Database\DatabaseSchemaVersionManager.cs (line 133)

Thanks!