mercredi 3 février 2016

VS2005 Database Project ignoring target database name on deploy

I'm working on an ancient project made in VS2005 that deploys a database project to MSSQL2005.

The project has a database name configured in the Target Database field in the Build tab of the project properties. Testing the connection confirms that the settings are correct.

I usually overwrite this database using SSMS with backups downloaded from different production servers, then rebuild the database project to generate an SQL script with the statements required to apply recent schema changes to the production DB.

I'm not sure what might have changed, but recently it started to generate a different DB named like this: ProjectName_DB_GUID, interfering with the creation of the diff script.

It also deleted many rows in some tables, even though Block Incremental Deployment if data loss might occur was checked.

This apparently happens only with some of the downloaded databases, but so far I haven't been able to pinpoint the exact cause.

What might I be missing here? What can I try to diagnose the problem and restore the original behavior?

Aucun commentaire:

Enregistrer un commentaire