3 Replies - 658 Views - Last Post: 28 December 2011 - 09:33 AM Rate Topic: -----

Topic Sponsor:

#1 insanepenguin  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 194
  • Joined: 08-July 10

Differences between Oracle and SQL Server

Posted 14 December 2011 - 10:04 AM

In University we use Oracle so I've been studying SQL, PL/SQL and all my assignments are obviously in Oracle. I like database development so when I begin my project in the summer I'd like to use C#/ASP.net for a windows program that synchronises it's database with one in an ASP powered website. I'm guessing I'll have to use hosting with SQL server - Is Microsoft SQL and T-SQL much different to Oracle and PL/SQL?

Thanks

Is This A Good Question/Topic? 0
  • +

Replies To: Differences between Oracle and SQL Server

#2 eclipsed4utoo  Icon User is offline

  • Not Your Ordinary Programmer
  • member icon

Reputation: 1447
  • View blog
  • Posts: 5,758
  • Joined: 21-March 08

Re: Differences between Oracle and SQL Server

Posted 14 December 2011 - 02:11 PM

View Postinsanepenguin, on 14 December 2011 - 01:04 PM, said:

I'm guessing I'll have to use hosting with SQL server


You guessed wrong. .Net can connect with an Oracle database.
Was This Post Helpful? 0
  • +
  • -

#3 insanepenguin  Icon User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 194
  • Joined: 08-July 10

Re: Differences between Oracle and SQL Server

Posted 14 December 2011 - 04:31 PM

View Posteclipsed4utoo, on 14 December 2011 - 02:11 PM, said:

View Postinsanepenguin, on 14 December 2011 - 01:04 PM, said:

I'm guessing I'll have to use hosting with SQL server


You guessed wrong. .Net can connect with an Oracle database.


But can oracle be used as an online (hosted) database connected to a website built in asp.net?
I need a DB that can be connected to through a windows application (c#) and mirrored/updated/accessed online

Thanks
Was This Post Helpful? 0
  • +
  • -

#4 AlbuquerqueApache  Icon User is offline

  • D.I.C Addict

Reputation: 49
  • View blog
  • Posts: 523
  • Joined: 21-February 10

Re: Differences between Oracle and SQL Server

Posted 28 December 2011 - 09:33 AM

Ugh, why would you want to share your database or have someone else host it?

Come on people, this is craziness!!! (by the way that is totally possible)

Here, I build app and give you all my data! derpty derrrrr....

(this isn't directed at the OP, I imagine some clueless CIO (Professor) has asked him to figure out such an ingenius application)

One thing more to conider is that if you have a network outage or slow down, it will adverely affect your application.

This post has been edited by AlbuquerqueApache: 28 December 2011 - 09:40 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1