web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Is it possible to expo...
Finance | Project Operations, Human Resources, ...
Answered

Is it possible to export data from 2 different environments to the same DB?

(0) ShareShare
ReportReport
Posted on by Waller Walker 345

Hi all,

I'm looking for a way to reduce costs and export data from 2 different F&O env. to a single database using BYOD.

Is there a way to set one export with a certain schema name and another with a different one?

For example, have the production env. go out to the "prod" schema, and the test env. to a "test" schema.

Really any help on the matter would be much appreciated!

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,088 Super User 2025 Season 2 on at
    RE: Is it possible to export data from 2 different environments to the same DB?

    Hi Waller,

    From within the BYOD settings on F&O, you can only specify the database server and database name as part of the connection string. You can use different databases on the same Azure SQL server.

    If you want to reduce costs, have you considered exporting the data to Azure Data Lake?  Export to Azure Data Lake overview - Finance & Operations | Dynamics 365 | Microsoft Docs

  • Verified answer
    Waller Walker Profile Picture
    Waller Walker 345 on at
    RE: Is it possible to export data from 2 different environments to the same DB?

    I found a solution;

    Using different logins for the SQL DB, you can set different default schemas for each.

    When you define the connection strings in the BYOD settings, insert the login that uses the schema you want to use with the env.

    The tables will go out from each env. to its related schema on the same DB.

  • Albert Choi Profile Picture
    Albert Choi 10 on at
    RE: Is it possible to export data from 2 different environments to the same DB?

    I have tried and successfully publish the entity to the schema. But when performing 'Export' job, some entities always fail like 'Purchase requisition lines', 'Purchase Recipt lines', 'Return order lines', those entities can be successfully export to 'dbo' schema using another connection.

    Moreover, I've granted administrator rights to the users db_owner, db_securityadmin, db_ddladmin, db_datareader, db_datawriter

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,188

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 868 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 593 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans