fabric ci/cd release pipeline

Hello arkiboys2 ,

Srisakthi pointed you to right direction, here is step by step guide to create rules:

1. Open your deployment pipeline in Fabric.
2. Click on the settings icon (gear) in the upper-right corner of the pipeline.
3. In the settings pane, select the "Rules" tab.
4. Click on "New rule" to create a rule.
5. Configure the rule:
   • Choose the item type (e.g., "SQL Server connection")
   • Select the specific items or "All items" of that type
   • Choose the action (e.g., "Update connection string")
   • For connection string updates:
     • In the "Find" field, enter the part of the connection string to be replaced
     • In the "Replace" field, enter the new value
     • In the "Find" field, enter the dev SQL Server details (e.g., Server=dev-sql-server.database.windows.net).
     • In the "Replace" field, enter the test SQL Server details (e.g., Server=test-sql-server.database.windows.net).
   • Select which stage to apply the rule to (e.g., "Apply to Test stage")
   • Name your rule
6. Click "Create" to save the rule.
7. The new rule will appear in the list of rules for the pipeline.

This process allows you to automatically update connection strings when deploying from dev to test, ensuring that your connections point to the correct SQL server in each environment.