If a form has been developed on a Dev k2 server with connections to a Stored Procedure on an Dev SQL Server (SQL connection), is it possible to change the SQL connection to a Live SQL Server during migration?
i.e. the Stored proc has been copied to Live Dev SQL Server, so when i migrate the form to the Live K2 Server it will use the live SQL server version?
What's the best way to do this when migrating forms from dev to live in K2?
When you register your SQL Server Service instance on the Live K2 Server, make sure it is pointing to your Live SQL Server. During the K2 package deployment, it will flag your Dev SQL Service and force you to map it to the Live one. As long as the database schema between Live and DEV SQL server databases are identical, all will be well!