Hi,
Is there any way to restore SQL db from backup file by using SqlScript as
below?
Using SqlFileSpec for data and SqlLogFileSpec for log file elements were
also not successful.
<Binary Id="RestoreDB" SourceFile=".\RestoreDB.sql" />
<Directory Id="TARGETDIR" Name="SourceDir">
<Directory Id="ProgramFilesFolder">
<Directory Id="SQLServer" Name="Microsoft SQL Server">
<Directory Id="MSSQL.1" Name="MSSQL.1">
<Directory Id="MSSQL" Name="MSSQL">
<Directory Id="MSSQLDATA" Name="Data">
<Component Id="SQLDirComponent"
Guid="{61E9CEC3-99DA-415b-A828-E3C9C8323073}" KeyPath="yes">
<CreateFolder />
<Sql:SqlDatabase Id='TestDB' CreateOnInstall='yes'
Database='TestDB'
Server='Dev'>
<Sql:SqlScript Id="RestoreRackwiseDB"
ContinueOnError="no" ExecuteOnInstall="yes" ExecuteOnReinstall="yes"
Sequence="001"
BinaryKey="RestoreDB"/>
</Sql:SqlDatabase>
</Component>
</Directory>
</Directory>
</Directory>
</Directory>
</Directory>
In RestoreDB.sql,
RESTORE DATABASE TestDB FROM DISK = 'C:\Projects\Wix\TestDB.bak'
WITH
MOVE 'Rackwise' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\TestDB.MDF',
MOVE 'Rackwise_log' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\Data\TestDB.LDF'
GO
Any feedback will be greatly appreciated.
--
View this message in context:
http://www.nabble.com/Restoring-SQL-database-from-backup-file-tf4510637.html#a12864723
Sent from the wix-users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
WiX-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users
