SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Oracle vs. SQL Server - An Issue Of Complexity
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

ameisez
Starting Member

6 Posts

Posted - 08/21/2003 :  02:03:12  Show Profile  Send ameisez a Yahoo! Message  Reply with Quote
Ok guys... I need your comment and advice here.. ill tell you the complete setting.

=========================
The loyalty program is on a shopping mall.
All participating shops will give discount to loyalty program member
Each member has a chip card
Each store has a Chip Card reader
All data transaction will be logged in the local machine

At the end of the day, the server will dial and connect to collect the data from each terminal on participating outlets

After collecting data, the server will print activity log to see if all the data has been collected without any errors

Then print the summary of the data that has just been collected
========================

Now the Administrator (that's me) has no idea on any of MS SQL or ORACLE that is why we stated in the contract that I should have the propper training before the developing company leave us.

FOR THOSE OF YOU WHO KNOWS MS SQL OR ORACLE OR BOTH...

WHICH IS A MORE ADVANTAGEOUS CHOICE? ORACLE OR MS SQL AND WHY???

by the way... I know PC (Windows) OS and nothing else

and one last thing??? How hard will it be to be a DBA if you know nothing but MS ACCESS???
Go to Top of Page

ameisez
Starting Member

6 Posts

Posted - 08/21/2003 :  02:15:56  Show Profile  Send ameisez a Yahoo! Message  Reply with Quote
TO the admin

can you delete 1 of that repeated message. My computer hangs the first time i click submit... so i try again... i restart and now i see both of it has been sent.. sorry

ameisez
Go to Top of Page

ameisez
Starting Member

6 Posts

Posted - 08/21/2003 :  02:28:39  Show Profile  Send ameisez a Yahoo! Message  Reply with Quote
quote:
Originally posted by nr


I still think it doesn't matter what the products can do - you will build a better system in whichever you know better.



I think it does for the first time... (just my opinion)
Go to Top of Page

whitesword
Starting Member

New Zealand
17 Posts

Posted - 08/21/2003 :  04:34:27  Show Profile  Reply with Quote
I have a lot of MS Access experience too. I have just had the same questions posted at me a couple of months back and the final answer that we decided on was to stay with the Microsoft suite. Several reasons: It was easier to install, there was a lot of support for it and we could upsize our Access projects to SQL server with a wizard. I have spent the last two months learning about stored procedures and am still learning. I have had to rewrite a number of them to increase their efficiency due to the scaling but it was not that difficult as all the documentation and help files (specifically Books Online) were familiar to us all.

In short, it was an easier transition, and best solution for our budget.

That's my 2c worth.

Cheers
Roger
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/21/2003 :  15:09:30  Show Profile  Visit nr's Homepage  Reply with Quote
>> Now the Administrator (that's me) has no idea on any of MS SQL or ORACLE that is why we stated in the contract that I should have the propper training before the developing company leave us.
How hard will it be to be a DBA if you know nothing but MS ACCESS???

How much do you know about database theory and how critical is the system?
Working on a single system on your own probably take a couple of years to become competent as you would not have exposure to different scenarios.
A lot faster if you have exposure to different systems and other DBA's (better if they are experienced but you gain a lot from discussion even if not).
Look at all the threads on this forum and any other sql forums you can find to see the sorts of mistakes you can make and the things you need to put in place.

I would suggest you get an experienced freelance dba to help with the transition and to teach you.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 08/25/2003 :  21:46:30  Show Profile  Reply with Quote
Just to make sure that you are working off correct facts.

SQL Server 7.0 and 2000 were not bought my Microsoft, 7.0 was a development from the ground up by MS. Most of the code from Sybase was thrown out and what little remains is slowly being rewritten in each later release.

On the 300MB issue, thats actually on optimisation, memory allocation and deallocation is an expensive operation, once SQL Server allocates memory into its global pool from the OS it will not be released until the system is under memory pressure or it is forced to. Thus when demand rises SQL Server does not have to allocate memory, as it already has been allocated.

As to scaleable SQL Server apps I suggest reviewing some of the following case studies.

http://www.microsoft.com/sql/evaluation/casestudies/scalability.asp

-Euan

[/quote]

As a developer/DBA i must disagree with many of your opinions. First of all MS did not entirely invented SQL Server , it was created by Sybase and as usual bought by MS.
Second of all, Linux is not just a stable platform but a daugher of UNIX which is the strongest platform , dont compare with AS/400 or VMS. Oracle under unix has greater capabilities then SQL server under MS windoze. Unix as you remember is multi tasking.
I ran into a factory server with SQL server 2000 , and guess what, i saw that in idling mode the thing was eating 300+M of operative memory RAM , what is the purpose of that.
I may be wrong but as a junio Oracle DBA, i quite enjoy the *NIX style architecture of Oracle. THe RAC ( real application cluster ) is a progressive evidence of Oracle living.
Please dont be offended MS people but easiness comes with problems, so enjoy the UNIX life under which serious company lives.





[/quote]
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 08/26/2003 :  01:40:25  Show Profile  Visit nr's Homepage  Reply with Quote
lol
>> junio Oracle DBA
Think that sums it up.
Wonder if he has more knowledge of Oracle than of architecture and database theory.

>> what is the purpose of that.
With a bit of thought it's obvious - just think about the other options.
Basic fact - you almost certainly won't get any useful opinions from a quick look at a product and any single facts should be considered within the environment they are discovered not in isolation.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

dbaperson
Starting Member

2 Posts

Posted - 05/02/2005 :  18:28:53  Show Profile  Reply with Quote
Some recent comparison Yukon - 10g
http://www.microsoft.com/sql/partners/migration.asp
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 05/02/2005 :  19:06:19  Show Profile  Reply with Quote
quote:
Originally posted by dbaperson

Some recent comparison Yukon - 10g
http://www.microsoft.com/sql/partners/migration.asp



I wonder what microsoft is going to say about their own product?



-ec

Go to Top of Page

niktrs
Starting Member

1 Posts

Posted - 09/30/2007 :  04:00:14  Show Profile  Reply with Quote
quote:
Originally posted by Merkin

quote:

Than again you'll always get the dyed in the wool Oracle DBA's who refuse to acknowledge there are better products out there



That is not restricted to RDBMS's everywhere in technology there is this "mine is bigger that yours" mentality.

Linux v Windows v Mac v BeOS v BSD etc

ASP v Cold Fusion v PHP v Perl v JSP

etc etc etc

Boring

Most people refuse to look at the fact that every product has strengths and weaknesses but at the end of the day you have to use the tool that you are good at. There is no point using SQL server if you completely rock at Oracle. Likewise with various programming languages, you see posts on boards like "I use ASP, should I use cold fusion ? " Hell no! Not if your skills (and those of your team) lie with ASP.

That being said, I aged about 5 years on the last Oracle project I did ..... Piece of crap that it is

Anyway, just needed to get that out of my system.......





Damian



I agree with you Demian.
I do not understand people that are arguing for which is the best OS
,the best RDBS etc.
Do they understand that our employers don't care for these?
They only want to get the job done!

It's not linux, windows, Oracle or SQL server.
It's IT!
Go to Top of Page

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 09/30/2007 :  13:25:57  Show Profile  Visit nr's Homepage  Reply with Quote
quote:
Originally posted by Merkin

I love it when a 2 year old thread gets revived


It's that anniversary again?

Before realising how old this was I read

>> SQL Server 7.0 and 2000 were not bought my Microsoft, 7.0 was a development from the ground up by MS. Most of the code from Sybase was thrown out and what little remains is slowly being rewritten in each later release.

Wonder if the poster has changed his mind since.



==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Edited by - nr on 09/30/2007 13:28:21
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000