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.

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

Thank you for the awesome work, by an chance, is there a possibility of merging this project with "https://dbdeploynet2.codeplex.com/"?

@brunomlopes I noticed that you have a NuGet package at https://dl.bintray.com/brunomlopes/generic/dbdeploy.net.2.2.0.4.nupkg. Would you mind uploading that to https://www.nuget.org so we can use it as a package?

Thanks,

Gregg

Could you please update the readme file with installation instructions.?

I downloaded and installed the nuget package of this tool. After installing the .nupkg file to my .net project, I do not see any folders or files relevant to your tool created in the solution/project.

Am i supposed to write code in order for making this work after installing the nuget package.?

Over all, it is not so clear how to install and use your tool. Kindly request to address the gaps and publish more clearer instructions please.

thanks.

Hi,

I need only the sql script as output and "do not" need the script run on the database. what settings should i use?

thanks.

Binary Release Included Script is not working:

Working Script:

CREATE TABLE changelog (
ChangeId INT(11) NOT NULL AUTO_INCREMENT,
Folder VARCHAR(255) NOT NULL,
ScriptNumber SMALLINT(6) NOT NULL,
ScriptName VARCHAR(512) NOT NULL,
StartDate DATETIME NOT NULL,
CompleteDate DATETIME DEFAULT NULL,
AppliedBy VARCHAR(128) NOT NULL,
ScriptStatus TINYINT(4) NOT NULL,
ScriptOutput TEXT NOT NULL,
PRIMARY KEY (ChangeId),
UNIQUE INDEX UK_changelog (Folder, ScriptNumber)
);

-- UNIQUE INDEX UK_changelog (Folder, ScriptNumber) Varchar(256) + SMALLINT not supported by max key size

I have multiple folders for different solution, like
ABCompany/MetaSql (for ex: it contain sql files from number 1-10)
ABCompany/SchemaSql (for ex: it contain sql files from number 1-12)
DEFompany/MetaSql (for ex: it contain sql files from number 1-5)
DEFompany/SchemaSql (for ex: it contain sql files from number 1-7)
GHICompany/MetaSql (for ex: it contain sql files from number 1-15)
GHICompany/SchemaSql (for ex: it contain sql files from number 1-11)

For example, now I want to execute following files
only files whose number after 7(i.e. 8-10) from folder ABCompany/MetaSql
only files whose number after 5(i.e. 6-12) from folder ABCompany/SchemaSql
only files whose number after 2(i.e. 3-7) from folder DEFompany/SchemaSql

Now Why I want to do this is because let's say I downloaded my production Database in my QA box and it contains all the scripts except the listed above.

Is this possible?

Thanks
Manoj

The Readme.md states that binaries are available at: https://bintray.com/brunomlopes/generic/dbdeploy.NET but Bintray has been shut down.

Is there any alternative location, or must users now build the project themselves to use it?

Regards.

I had following error in my sql script. (i.e. length of column is less than actual value in sql file)

warning 8152: String or binary data would be truncated.

MSBuild raised this error but dbdeploy set ScriptStatus column value as 1 instead of 3.

Can you please help to fix this issue?

This is due to the delimiter being by default null

Hello,

is yours different from this? https://github.com/rakker91/dbdeploy.net if so, is it possible for you to please provide a comparison highlighting the differences.?

EDIT: you can disregard my question whether this is different from rakker91's. I see it is different. both of your works are derived from https://sourceforge.net/projects/dbdeploy-net/.

Hence closing this issue.

This is mentioned here: https://msbuildextensionpack.codeplex.com/discussions/471408

This happens on the command line version.