Description:
1) Install the latest ApexSQL Source Control
2) Open SSMS and execute the following script in the one database:
"CREATE TYPE DictionaryStringStringDT AS TABLE
(
[Key] NVARCHAR(255),
[Value] NVARCHAR(255)
);
CREATE PROCEDURE [dbo].[Test]
@ExternalOrderData DictionaryStringStringDT READONLY
AS
BEGIN
DECLARE @EsimPhoneId INT = 0;
-- Check if the Key 'EsimPhoneId' exists and has a non-null, non-empty Value
IF EXISTS (SELECT 1 FROM @ExternalOrderData WHERE [Key] = 'EsimPhoneId' AND ISNULL([Value], '') <> '')
BEGIN
-- Get the Value for 'EsimPhoneId' and cast it to INT
SET @EsimPhoneId = ISNULL(PARSE((SELECT [Value] FROM @ExternalOrderData WHERE [Key] = 'EsimPhoneId') AS INT), 0);
END;
END;"
3) Try to link that database to any repository
4) A "Database is synchronized" message will appear, but the repository will be empty
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center