visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
315 experts, 1193 registered users, 1659 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Databases :: SQL Compatibility issues :: SQL Server to Oracle
By: kukiya U.S.A.  Date: 17/09/2003 00:00:00  English  Points: 50 Status: Answered
Quality : Excellent
HI,
I have a project in VC++ that connect with ODBC to SQL Server2000 DB.
Now I want the project will be able to work with Oracle DB.
I have some questions about it, since I don't really know how to begin.

1. Is there any progarm that can convert an an SQL Server to Oracle 9i?
2. Can oracle give the solution of stored procedures of the SQL that I am using?
3. I think I managed to create a table, but I cannot fill in data, How do I do that, Is it via the Enterprise manager of Oracle (Like in SQL Server).

Thaks in advance
By: VGR Date: 17/09/2003 04:14:00 English  Type : Comment
1) both are supoposed to understand only SQL (ANSI pref.) so the question is meaningless ***if*** those two Db providers (Merdu$oft and I'veBeenMoved) are ***really*** as SQL92&99-compliant as they claim to be.

2) and in English ? Yes, you can use stored procedures in Oracle ; it's even recommended given the very poor date, time and string functions supported by Oracle, and the lack of standard-SQL functions like CURRENT_DATE(), MONTH() etc

3) use TOAD, it's free. And yes, you could use whatever tool Oracle offers you, BUT NOT the Enterprise manager : you can't create data using this.

3b) I recommend opening a SQL console (like with TOAD) and begin playing with INSERT INTO tablename VALUES(...,...);
3c) I would recommend to use MySql in stead :D
By: kukiya Date: 17/09/2003 16:45:00 English  Type : Comment
Thank for answering,
2 things:

1. I still haven't figured out with what tool can I create and insert into data into the database.
As I understand from you, using the Enterprise manager of Oracle is not the way.

2.Can you tell me what is 'TOAD' you mentioned ???

3. Where can I read about 'MySql '

Thanks in advance
By: VGR Date: 18/09/2003 17:39:00 English  Type : Comment
1) Toad, as the "console" from Oracle is very poor.

2) TOAD is Tool for Oracle Access , it's free, widely used, and from Quest Software.

Just make the effort of typing "TOAD" in <A HREF="http://www.google.com">www.google.com</a> ...

3) <A HREF="http://www.mysql.com">www.mysql.com</a>
By: kukiya Date: 23/09/2003 16:47:00 English  Type : Comment
Thanks for the inforamtion.
2 questions concerning the subject:
1. I did downloaded the TOAD.
The problem is I can't execute any query since I get the message :
"ORA-01950: no privileges on tablespace 'USERS'".

where do I grant the permissions in the Oracle manager or in the TOAD?

2. What is actually "MySQL". is it like TOAD ????

Thanks !
By: VGR Date: 24/09/2003 04:51:00 English  Type : Answer
MySql is a concurrent to Oracle. It's a database or RDBMS (relationnal database management system). It's robust, fast and powerful. Moreover, it's SQL-standard-compliant and free. Oracle is the exact contrary (except perhaps on robustness) :D

As for your permission problem, I don't know.

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Twitter Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to Facebook Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

EContact
browser fav
page generated in 344.645020 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page