CODEWITHSUNDEEP
visual-studiopublishweb-publishing
Steve
Steve

Reputation: 11963

What is incremental database publishing?

When I am publishing my site using Web Deploy in Visual Studio I see something like: 

MySql.Data.MySqlClient is not supported for incremental database publishing.

I want to know what exactly would this technology do if it is supported?

Upvotes: 3

Views: 1673

Answers (2)

Razvan Dumitru
Razvan Dumitru

Reputation: 12452

Incremental database publishing is used for versioning purposes. SVN can't really handle versioning for database schema like tfs can support.

If you're using incremental database publishing you can set up to keep the current database and just do the update, or to always recreate database.

Let's assume you want to declare sql variables like InitData, SeedData.

You can do this and you have access at some before and post publishing script. If your variable SeedData is true, you can seed some data in the post publishing script.

More info here: http://www.asp.net/web-forms/tutorials/deployment/web-deployment-in-the-enterprise/deploying-database-projects

EDIT: it's just the schema that's updated if you choose not to recreate your database when you publish

Upvotes: 1

David
David

Reputation: 218827

Incremental database publishing is a deployment feature where the source code for the schema (new version) is compared with the live database schema (current version) to create a change script to upgrade the current version to the new version.

For example, if your schema has a table with a few columns and in the source code you add a new column definition, when publishing it would create a script to add the new column to the table.

It's not surprising that a database engine besides SQL Server isn't supported, since supporting other database engines would be a significant amount of work. All it really means is that you'll have to synchronize database changes yourself. MySQL may provide tools to help with this, but Visual Studio doesn't.

Upvotes: 2

Related Questions