On the particular sample of data you supplied it seems that everything field is within double quotes without exception.

That being the case would it not be an easy...

try changing the header delimiter to LF - there is a discrepancy between the header and row delimiters.

And what I have found before is that where there is...

I would say it may require one of the following

sysadmin - but should not be granted
dbowner - should be avoided
view definition (database level) or view any...

Regarding the links that Jeff posted be aware of some of the issues with it.
Firstly the Attunity driver is only for Enterprise Edition.

As for the driver itself.

are both same exactly the same spec?

mainly memory but also
number cores
size of databases - are they same size as prod? - having one or more tables...

does this work? without setting location

get-item "\\pathToPolicyfiles\policy.xml" | Invoke-PolicyEvaluation -TargetServer "servername"

look at https://docs.microsoft.com/en-us/powershell/sqlserver/sqlserver-module/vlatest/invoke-policyevaluation

Although the examples there do not use a network share, the Get-ChildItem can get them from there with no issues, and you pipe the file onto...

but ...

DECLARE @T table (data char(1))

Insert @T (data) values ('A')
Insert @T (data) values ('a')
Insert @T (data) values ('B')
Insert @T (data) values ('b')

rowversion is indeed unique and can not be copied like that - talk with the customer and see what are the implications of changing it.
For that table to be...

I suggest that you go to https://www.appdynamics.com/community/ and look at the several threads there.

And if you have specific questions that aren't already answered post them there.

It...

It is advisable that you identify the correct mapping for the oracle types and apply those instead.

Oracle is has its own way of dealing with datatypes and that...

How are you copying from the big table to the partition table?

As I said on my comment -- this is better done using SSIS or a small C#...

Discipline is in my opinion the most important thing on working from home.

Those that tend to get distracted with things going on in their house, or that, for...

why don't you try it out?