Deplyment pipeline switch between dev and prod for a stored procedure

[BenLyon]

Hello,

I have a problem when i deployed my pipeline data factory all of the stored procedures are connected with the datawarehouse of dev. How can i make a deployment rule for my data pipeline in fabric ?

Thanks

[Anonymous · Accepted solution]

Hi @BenLyon ,

I think you can do these steps below:

1. Use parameters to define environment-specific values such as connection strings, database names, and stored procedure names.

2. Maintain separate configuration files for each environment (e.g., dev, test, prod) that contain the environment-specific values.

3. Write deployment scripts that read the configuration files and apply the environment-specific values to the pipeline parameters during deployment.

4. Use a CI/CD tool like Azure DevOps to automate the deployment process, ensuring that the correct configuration file is used based on the target environment.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BenLyon]

Hello Yilong Zhou

Thank you so much for you answer. The fact that MS does not given the opportunity to make a deployment rules for a data pipeline yet is terrible but this is it. 
See you