Ah.. if it was that easy.. 1 to 1 mapping.. (sigh).

On the migration I did 1 segment was converted to 200+ Tables, each with their own set of primary key...

the original developer has most likely defined a expression to build the connection string - on the properties of the connection, look for expressions and see what is there.

Most common...

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