How to create a deployment package with SQL scripts in IIS

Question

Using IIS-10, Web Deploy v3.6, Windows 10.

This is an ASP.NET website (not an application) using SQL Server 2014 for an external server.
I was able to successfully create and deploy the package, but without SQL scripts. Could not find information on how to do this, including the SQL scripts in the package. Here is what I tried:

• In IIS, in the "Default Web Site" section, select my web application.
• On the right side, click Export Application.
• Click Manage Features. Select "dbFullSql" as the provider name. For the path, enter the connection string.
  for example: Data source = xxx.xxx.xx.xxx; Start Directory = MyDB; Persist Security Info = True; User ID = testuser; Password = test @ 345;

When you click OK, nothing happens. The processing icon continues to be displayed. It had to be closed using the task manager. Also tried the path to the .sql file, not connectionString. But I don’t know what parameters to enter & how / where to specify the connection string.

I would appreciate it if someone could guide me with the right procedure.