How to Restore SQL Backup file by IS?

[masmart]

Hi everyone,
I've got a really simple questions.
How can I restore my database backup file by Installshield?
I'm really beginner in this regard and I have to do it becoz it's part of my thesis project.:( 😞 😞

Thanx for any help.

[Vijay__K]

I think you will have to script it... I don't think InstallShield sql scripts view supports the database restore.... I might be wrong.

[hidenori]

You should be able to restore a database by executing the RESTORE DATABASE statement.

[masmart]

I know how can I restore my sql Backup database by sql procedure but....
my backup files is next to installer. i want IS tho understand that, the backup file is next to it. how can i address IS to find backup files? the answer is something like this: , , , %CD%, %PROGRAMFILES%.
Thanx.

[Alpesh]

Hi,

You can put the Sql backup file in the 'Support Files' view and then use Sql Scripts view's Text Replacement view to know the actual path of the Sql Backup file. You will have to use the SUPPORTDIR property.

Thanks!