Varying Pipeline Data Sources at Each Stage

(0) Share

Report

Posted on by bribuii

I currently have a pipeline going between a dev environment and a production environment, with the apps using a SQL server as the data source. I'd like to have my dev database in SQL used in the dev environment (using test data), and my prod database in SQL used in the prod environment (using active client data). If the two databases are formatted identically, with the same table names and column names/data types, is there a way to deploy in the pipeline but have each stage pointed to a different data source?

Categories:

Environment

Management

All responses (1)

Answers (0)

velegandla 202 Super User 2025 Season 1 on at

Like (0)

Report
Re: Varying Pipeline Data Sources at Each Stage

@bribuii

Can you try the steps below?

Deleted all old Solutions on Development environment.
Deleted all Connection references.
Created new Solution in development environment.
Add the existing Canvas App to the solution.
Added new connection reference to SQL server connection.
Deleted all Datasets(Tables) inside Canvas App which used the SQL Server connection.
Added the Dataset(Tables) again with for SQL Server connection.
Deploy the solution using Pipeline.
====================================================

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

https://www.linkedin.com/in/devendravelegandla/