asked on

What is SQL*PLUS?

What is SQL*PLUS?

I was sent to a website to gather a few scripts. On the website it states the scripts can be executed using SQL*PLUS. I thought SQL*PLUS was an ORACLE product. I need to run this for MS SQL. I see mention to run sqlcmd but how does that solve anything?

SOLUTION

Nitin Sontakke

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rwheeler23

ASKER

I do not know MySQL but my suspicion is that is what they are. On their website they state that if you run these scripts under SQL*Plus they will run. Then I saw something about running sqlcmd was equivalent to SQL*Plus which really did not make sense. I had to manually make corrections to these scripts to get them to run under MSSQL. Since one of the scripts had over 10,000 it was a bit of a task. I tried running a MySQL to MS SQL converter and it froze. I will play around with some other tools.

ASKER CERTIFIED SOLUTION

Vitor Montalvão

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rwheeler23

ASKER

That is what I thought. I will need to have them update their website.

By the way, I tried to put the scripts through a MySQL to MSSQL conversion tool and it just froze. From what I see the conversion formula for dates needs to be upgraded.

Vitor Montalvão

Each DBMS has their own way to deal with dates. Maybe the best thing is to convert to varchar when exporting and then convert from varchar to date when importing.

rwheeler23

ASKER

This is NYS website and all I have is the script. There is no access to the database. For now I did a search and replace to fix the date function.

rwheeler23

ASKER

Thanks