Appreciate the reply!

I did run that procedure.

The issue turned out to be unrelated to replication - at least not directly.  We have a database that is essentially just a bunch...

Found it...

The issue actually had nothing to do with IRES.

We have five identical databases, each one representing a business unit.  At some point in the past, we created a new...

UPDATE:

I've managed to work out that when you try to create a new publication or subsciption, it runs this:

exec sp_helpreplicationdboption @reserved = 1

Which loops through all of...

So I've figured out that what I really need to use is Merge Replication - which I was able to setup pretty easily between two local servers.

The problem I'm running...

Unfortunately some of the images in question are not our images - for example the little arrows that show that you can sort a column aren't rendering.  Those are embedded...

The Oracle team determined that the driver was basically still doing a row by row insert instead of batch.

In the meantime, we decided to setup an Azure database with the...

Duplicate reply my first one took a while to show up...

Sincerely appreciate all of the replies.

We've started down the path of creating a C# program that uses the Oracle’s 19c drivers - and performance is definitely much, much better; in...

Appreciate the replies!

The script I used most recently is this:

declare @period varchar(10) = '2024MAR'
 
declare @innerCommand varchar(500) = 'select * from FACT_GL_ACTUALS where TRX_PERIOD = ''''' + @period...

Thanks all...

I tried using a dynamically generated openquery statement and, while it's not as fast as I was hoping, it's definitely a lot faster than before.  Going to try to...

We're not joining to anything local, fortunately.  We're literally just dumping the contents of reporting tables on our server to a tables on their server - the only difference being...

In this particular instance, my local PC is the server - right now we're just trying to see if we can actually make the connection.

Everything is 64-bit including the driver. ...

Just in case anyone is curious or has the same problem - the solution provided by bpflanzer works perfectly.  I've tested it a couple of times now in our test...

Appreciate the help...  the @sync_type suggestion from bpflanzer seems to work exactly how I'd hoped.

I am bit nervous about the fact that the first time I tried, I setup a...

Fortunately the powers that be have agreed that replication isn't the way to go...  mostly because this database was one of six with that many objects; and if one giving...