Check whether the database already exists during installation

Create ServerProgramTo create a database and tables. Before creating a database, check whether the database already exists. If yes, a pop-up dialog box is displayed asking if you want to overwrite the existing database data. Here is a usageNSIsHow to check the installation package.

 

NSI of the detection partCodeAs follows:

Nsexec ::Exec 'Sqlcmd-S. \ sqlexpress-D sampledb'

Pop $0

Intcmp $0 1Update ask

 

The principle is very simple.SqlcmdLog on to the database you want to create. If the database already exists, log on successfully,$0The value in will be0Otherwise1.

NSIsThere are manyExecAnd there are many ways to detect databases. I tried many methods today, some of which are not feasible and some are too complicated. The above method is relatively simple. I hope to give some tips to those who need it.