Dynamics Community Forum Thread Details

Hello, we have deployed a Unified Sandbox Environment where consultants test our custom features, I would like to export data from this environment to my local OneBox dev to make changes in the code, for using the data already entered by one of our consultants. I gained access to the database via SQL Server (using the SQL Credentials for Dynamics 365 FinOps feature in VS), connected to the Spartan server and then exported the bacpac file via SqlPackage. However, I am getting errors when trying to import the bacpac into my local dev machine.
Has anyone already tried to move a database between these environments? Is there any different solution to deploy developer changes to that Unified Sandbox Environment?

Below I added log from CMD:

C:\Users\localadmin\Downloads\sqlpackage-win-x64-en-170.2.70.1>SqlPackage.exe /a:import /tcs:"Data Source=localhost;Initial Catalog=TST;Integrated Security=True;TrustServerCertificate=True" /sf:"C:\Users\localadmin\downloads\USE_Export.bacpac" /p:CommandTimeout=0
Importing to database 'TST' on server 'localhost'.
Creating deployment plan
Initializing deployment
*** The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.
Verifying deployment plan
Analyzing deployment plan
Importing package schema and data into database
Updating database
*** Error importing database:Could not import package.
Warning SQL74501: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 468, Level 16, State 9, Procedure GETTABLESWITHOPENCURSORS, Line 192 Cannot resolve the collation conflict between "Latin1_General_100_CI_AS_KS_WS_SC" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE [DBO].GETTABLESWITHOPENCURSORS
@OptionalSchemaToCheck NVARCHAR (20)='dbo', @OptionalTableToCheck NVARCHAR (128)=''
AS
BEGIN
SET NOCOUNT ON;
SET LOCK_TIMEOUT 60000;
SET DEADLOCK_PRIORITY HIGH;
DECLARE @spVersion AS NVARCHAR (30) = 'GetTablesWithOpenCursors v2.2';
DECLARE @Tables TABLE (
TableName VARCHAR (128));
IF (PROGRAM_NAME() <> 'DAMS')
BEGIN
IF (@OptionalTableToCheck != '')
BEGIN
IF EXISTS (SELECT TOP 1 'x'
FROM sys.dm_tran_locks WITH (NOLOCK)
WHERE resource_type = 'OBJECT'
AND request_mode LIKE 'Sch%'
AND resource_associated_entity_id = (SELECT object_id
FROM sys.objects WITH (NOLOCK)
WHERE n

Categories:

Dynamics 365 Finance