Forum Discussion
fabric ci/cd release pipeline
hello,
I am in the process of setting-up the releas epipeline from dev to test.
in the dev workspace which has data factory, etc.), the connections are to dev sql server.
how can I make sure in test the connections are pointing to test sql server?
thank you
Hi arkiboys2
Deployment rules in Fabric deployment pipelines do not currently support changing data source connections for data factory pipelines. This means that a pipeline pointing to a dev data source cannot be automatically updated to point to a prod data source during deployment.
11 Replies
Hi arkiboys2 ,
You can utilise Fabric deployment pipeline for deploying from one environment to another. There you have an option of pointing to target db by using deployment rules.
Reference : https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/create-rules?tabs=new-ui
Regards,
Srisakthi
Hello arkiboys2 ,
Srisakthi pointed you to right direction, here is step by step guide to create rules:
- Open your deployment pipeline in Fabric.
- Click on the settings icon (gear) in the upper-right corner of the pipeline.
- In the settings pane, select the "Rules" tab.
- Click on "New rule" to create a rule.
- 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
- Click "Create" to save the rule.
- 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.
Hi,in your step number 3, I am unable to locate the rules tab in the settings.
I can access the create rules via the deployment screen with a little lightning icon at the bottom.
Question. I am unable to set rules for pipelines eventhough the pipelines use the copy activity and connect to sql server instance.
any suggestions why it does not allow rules ? thank you
Hi arkiboys2
If nilendraFabric Srisakthi 's response helped you resolve your issue, please consider marking it as the accepted answer. If you found this information helpful, I would greatly appreciate your kudos. Thank you!If you still encounter any issues, don’t hesitate to reach out for further assistance!
