Hello ,
Thank you for creating this wonderful application .
Scenario : during installation the installer should automatically check in SQL Server whether if the database exists. If exists skip running the restore script and just run the update script .
I have a created a Query for the same and saving the result in the DBExists_PROP and same returns TRUE if the database exists and FALSE or (null) if the DATABASE does not exist .( Using the Test Option we have tested the query and the same returns true or false/(null))
Then I am adding a condition to run the restore script only if the DBExists_PROP ="false" or DBExists_PROP <> "True" but still every time we run the installer the DB Is restored or replaced .during second install.
Kindly advise