it is such a small program that any programmer will be able to do it - and if not then hire one to do it either in c# or vb.net...

no Oracle isn't better suitable - and SQL Server Express will still hold with that volume. what you need to find out is exactly how many records each table that...

Because you have CLOB/BLOB data my advise is to use a C# program that reads from sql server and loads to Oracle directly using the OracleBulkCopy http://docs.oracle.com/html/E10927_01/OracleBulkCopyClass.htm

Note that with...

Rankerg (5/3/2016)

---

Thanks Again and see my inline response

frederico_fonseca (5/3/2016)

---

going to reply to your 4 comments.

1 - you do not need to migrate to Microfocus - I was just stating what...

no

no easy way to log the SSIS logging to sql server agent log.

one way would be to change the job to execute a cmd file containing 2 steps

step 1 -...

going to reply to your 4 comments.

1 - you do not need to migrate to Microfocus - I was just stating what we did on our project.

regarding the...

I've done such a migration 4 years ago - migrate a IMS db to Sql server and mainframe cobol to Microfocus COBOL. we kept the core code in COBOL but...

my advise is to look at https://www.connectionstrings.com/ and see lots of possibilities - and obviously the manuals may have a bit more options.

most important thing for now is ensuring that backups are done to all db's.

For new server - first of get it setup - make sure the server will allow for...

you can use these constructs to deal with partitions

select $partition.partitionfunctionname(partitioncolumn) as partitionnumber

,*

from mypartitionedtable

select *

from mypartitionedtable

where $partition.partitionfunctionname(partitioncolumn) = 5

see https://msdn.microsoft.com/en-us/library/ms188071.aspx

I see to main issues here

1 - VM setup seems to indicate an issue if performance of HD's is that bad compared to the physical.

What is the VM...

yes that would be the case - but easy enough to build the case statements in Excel for example - this is something I had to do on the last...

DCOM maybe? see http://answers.flyppdevportal.com/MVC/Post/Thread/c7f52891-7920-480c-999e-183d8f1b6387?category=sqlintegrationservices for some possible issues

select id

,product

,rentalrates

,row_number() over (partition by id order by RentalRates) as RowId

...