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?

Something like this.

use databasename -- this script should run against required database

-- these two should be set as required
declare @shrink_target int = 10000 -- adapt as required...

Its a choice, but paying for SQL Server just to use SSIS is not what I would consider a good choice.
Without even considering some of the free ETL tools...