|
<AppSecInc:MSSQLDatabase Id="MSSQLRcsDatabase" Name="[MSSQL_DATABASE_NAME]" ConnectionId="LocalSQLServerConnection" CreateOnInstall="yes" DropOnUnInstall="yes">
<AppSecInc:MSSQLDatabaseOption Id="MSSQLRcsDatabase_TrustWorthyOn" Value="TRUSTWORTHY ON" />
<AppSecInc:MSSQLDatabaseFileSpec Id="MSSQLRcsDatabase_PRIMARY" Name="RPC_mdf" Filename="[MSSQL_DATABASE_MDF_PATH]" Size="10MB" Type="PRIMARY" />
<AppSecInc:MSSQLDatabaseFileSpec Id="MSSQLRcsDatabase_LOG" Name="RPC_ldf" Filename="[MSSQL_DATABASE_LDF_PATH]" Size="12MB" Type="LOG ON" />
</AppSecInc:MSSQLDatabase>
<!-- Build the Tables -->
<AppSecInc:ODBCExecuteBinary
We are using the DataSource Extension by AppSecInc. It works well for installing a database and uninstalling a database. I use ODBCExecuteBinary to run SQL scripts to install tables and stored procedures. So far, the only trouble I have
with it is that CreateOnReInstall property won't work with the command even though I think I do see it in the actual C code.
Henry Sheldon
hsheldon@bearwareinc.com
|