SQL-DBA-01 (5/10/2016)

---

Hi,

When I try to run the below command, the variable ($pk_key2) comes as NULL.

Can you suggest if something is going bad?

[string] $pk_key2 = invoke-sqlcmd -query "SELECT column_name FROM...

issue is using Oracle.ManagedDataAccess.Client; -- don't use the managed class.

Example from John should work but it will be slow depending on the volumes.

if you can it might be better to...

DiabloSlayer (5/9/2016)

---

Hi There,

My mistake, I just went back and checked, the hours are like '3.5' and '4' instead of 03:30 and 04:00 as initially stated.

So when I ran the

convert(datetime,STARTDATETIME)...

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