Created
July 6, 2011 14:00
-
-
Save ielcoro/1067289 to your computer and use it in GitHub Desktop.
Integrar FluentMigrator con Visual Studio
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> | |
<PropertyGroup> | |
<sqlserverinstancename Condition="'$(sqlserverinstancename)' == ''">erkasqlserver.erka.es</sqlserverinstancename> | |
<backupscriptpath Condition="'$(backupscriptpath)' == ''">..\Scripts\Backup\Backup.sql</backupscriptpath> | |
<dbDebugConnectionString Condition="'$(dbDebugConnectionString)' == ''">Data Source=.;Initial Catalog=EKP_INTEGRACION;Integrated Security=true</dbDebugConnectionString> | |
<dbPublishConnectionString Condition="'$(dbPublishConnectionString)' == ''">Data Source=erkasqlserver.erka.es;Initial Catalog=EKP_Integracion;User ID=sa; pwd=erkatxirrita2003</dbPublishConnectionString> | |
<dbMigratorPath Condition="'$(dbMigratorPath)' == ''">..\..\lib\FluentMigrator</dbMigratorPath> | |
</PropertyGroup> | |
</Project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<Import Project="dbmigrate.properties" /> | |
<Target Name="AfterBuild"> | |
<!--<Exec Command="sqlcmd -S $(sqlserverinstancename) -i "$(backupscriptpath)"" Condition="'$(Configuration)' == 'Publish'" />--> | |
<Exec Command="$(dbMigratorPath)\Migrate.exe /target "..\Database\bin\debug\Database.dll" /connection "$(dbDebugConnectionString)" /db sqlserver /profile Debug /workingdirectory "..\Database\bin\debug"" Condition="'$(Configuration)' == 'Debug' " /> | |
<Exec Command="$(dbMigratorPath)\Migrate.exe /target "..\Database\bin\Publish\Database.dll" /connection "$(dbPublishConnectionString)" /db sqlserver /profile Release /workingdirectory "..\Database\bin\Publish"" Condition="'$(Configuration)' == 'Publish' " /> | |
</Target> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
1- Crear el archivo dbmigrate.properties
2- Editar el fichero del proyecto destino que ejecutara la migración al ser compilado
3- Si se dispone de entorno de producción, crear configuración Publish en Visual Studio que ejecutará el comando de migración de la BDD de producción al compilar con dicha configuración activa