topic Re: Deplyment pipeline switch between dev and prod for a stored procedure in Pipelines

Deplyment pipeline switch between dev and prod for a stored procedure

BenLyon — Tue, 11 Mar 2025 16:12:07 GMT

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

Re: Deplyment pipeline switch between dev and prod for a stored procedure

Anonymous — Wed, 12 Mar 2025 01:30:36 GMT

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.

Re: Deplyment pipeline switch between dev and prod for a stored procedure

BenLyon — Wed, 12 Mar 2025 09:09:59 GMT

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