how to deploy and publish SQL server with app on IIS SERVER

First step you need to deploy your asp.net app to IIS

https://docs.microsoft.com/en-us/visualstudio/deployment/deploy-iis-with-web-deploy?view=vs-2017

Next step you need to Generate SQL Database Script

https://docs.microsoft.com/en-us/sql/relational-databases/scripting/generate-and-publish-scripts-wizard?view=sql-server-2017

Next you need to import this SQL Script

https://onlinehelp.coveo.com/en/ces/7.0/administrator/running_a_script_in_microsoft_sql_server.htm

Finally, you need to change the SQL Server Name and Database Name in web.confing in connection string on new server.

Connection string example

providerName="System.Data.SqlClient"

connectionString="Data Source=SQLInstanceServerName;Initial Catalog=DatabaseName;Integrated Security=True "/>