Hi there

How can we change database connection while taking the built Gen pro code to the deployement server from development site in self service.

Connection string is read from your application config file. So change that to point to the deployment database server.

Further if the database (catalog) name is different, you should check Catalog Name overwriting