I have never done anything with DB2 but maybe something like CData Sync would work.

Maybe I have not had enough coffee yet, but I am having difficulty understanding how RCSI/MVCC will help with a data extract. Snapshot isolation may help and the issues with...

• This reply was modified 2 weeks ago by Ken McKelvey.
• This reply was modified 2 weeks ago by Ken McKelvey.

France has its own cloud provider:

Cloud Computing & Web Hosting | OVHcloud UK

The problems allegedly are:

1. The documentation, even in French, is poor.

2. The support is worse.

3. Only basic services.

ie...

It seems strange to do this in a SP; I would be more inclined to have something on an application server and use a more suitable language. (C#)

If you really...

/* *** Test Data *** */
CREATE TABLE #t
(
   Account char(7) NOT NULL
   ,TransDate date NOT NULL
   ,TransType char(1) NOT NULL
 ...

The order in which rows are returned in a result set aren't (sic) guaranteed unless an ORDER BY clause is specified.

If you are not using SSIS elsewhere, it may just be simpler to use PowerShell.

1. First create a view of your query. Something like:

SET ANSI_NULLS, QUOTED_IDENTIFIER ON;
GO
USE...

• This reply was modified 1 month, 3 weeks ago by Ken McKelvey.
• This reply was modified 1 month, 3 weeks ago by Ken McKelvey.

I think Databricks is a good option for production at the moment as Fabric is still not mature. Microsoft now has an issues list so hopefully it will be...

Your question is unclear so I showed you how to use FIRST_VALUE and...

/* *** Test Data *** */
CREATE TABLE #t
(
    rn int NOT NULL
        PRIMARY KEY
   ...

Just load this and weave the results into the conversation! I find it amusing when...

CDC uses the log so does not explicitly require timestamps.

Why not just filter the results for enabled jobs? The Filter button is next to...

• This reply was modified 3 months ago by Ken McKelvey.

I have just tried to create a view with an ORDER BY in SQL 2019 and got the following:

Msg 1033, Level...

This shows how to connect to a local SQL Server using ADF:

Tutorial: How to access on-premises SQL Server from Data Factory Managed VNet using Private Endpoint

Presumably you would then...