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...

The business case initially is to have a readable copy out on our Azure environment.  Eventually, we will be moving our application to Azure, which is why we need to...

The table is usually between 1500-3000 rows, so not big at all.  It's fairly simple to just cut and paste an INSERT from SSMS.

I was just trying to avoid those...

The table in question is truncated and repopulated in the production environment at the end of each month.  It contains data that is compiled in other systems; the exact date...