Re: Oracle licence question

If you want to automate it to occur every 15 minutes there is a ton of
stuff
you have to do including freeze everything while you do it.
Jim


Try using the GUI that comes with the SDK - its all done for you, including
scheduling.

And I don't think modifying a job schedule under SQL Agent is that
difficult.

And no - it does not freeze anything, the backups DO NOT affect connections
to the database, inserts, updates and selects can still occur and are not
affected.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in
message news:1uydnQQoP7n5jZ_Z4p2dnA@xxxxxxxxxxxxxx

"Tony Rogerson" <tonyrogerson@xxxxxxxxxxxxxxxx> wrote in message
news:dtspt4$amv$1$8302bc10@xxxxxxxxxxxxxxxxxxx
I have used log shipping and it is prone to problems. You have to
basically
freeze the database (source) and send it to the target. You have to be
careful applying logs, SS doesn't seem to be able to know what order to
apply logs in. (which seems rather silly, it should know the order)
Jim

Freeze the source database? Where and on what planet did you get that
impression from?

You start with a backup of the source database, that is done online and
takes into account current loading on the server so as to not affect
users,
users can still use, update, insert etc... into the database. You then
backup the log, copy to destination server (or servers) and restore the
log - it can't get any more simple!

Yes, you do need to apply logs in order at the destination but I don't
see
a
problem unless you are incompetant.

If you install the free SDK you will get a log ship built into the
maintanence plan in EM and its all done for you, and its through a GUI.


If you want to automate it to occur every 15 minutes there is a ton of
stuff
you have to do including freeze everything while you do it.
Jim

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"Jim Kennedy" <jim dot scuba dot kennedy at gee male dot com> wrote in
message news:YYudnWEkfbmOQpzZnZ2dnUVZ_tCdnZ2d@xxxxxxxxxxxxxx

"Tony Rogerson" <tonyrogerson@xxxxxxxxxxxxxxxx> wrote in message
news:dtrqsr$ocv$1$830fa79d@xxxxxxxxxxxxxxxxxxx
eweek did a comparison of the two (albeit Enterprise Editions) just
recently

I don't tend to read stuff like that, I can just as easily find
articles
that put SQL Server in a good light rather than Oracle, awards its won
etc... but they are all opinions of authors rather than people who
actually
use the kit. It suprised me that some of the newer features - report
builder, changes to the BI suite aren't even mentioned which says it
all
about that particular article....

Database mirroring isn't shipping yet, right ?


Its shipping but not supported yet until SP1, but that doesn't stop
you
using other stuff like clustering (which is in workgroup and standard
editions) or peer to peer replication, log shipping of your own....

I have used log shipping and it is prone to problems. You have to
basically
freeze the database (source) and send it to the target. You have to be
careful applying logs, SS doesn't seem to be able to know what order to
apply logs in. (which seems rather silly, it should know the order)
Jim

The price for Oracle Standard Edition One on a dual core machine is
$4995
US or 2902 GBP.

Is that for unlimited users though? Because its dual-core (2 CPU's) I
should
add another 75% to that price?

Check out http://www.theregister.co.uk/2005/07/15/oracle_core_pricing/
which
sums it up nicely.
And it gets even more complicated! A sharp Register reader forwards
this
advisory from Oracle's finer print:

"A multicore chip with 11 cores would require a 9 processor license
(11
multiplied by a factor of .75 equals 8.25 which is then rounded up to
the
next whole number which is 9)."

What I really wanted is something that lists features I get in Oracle
Standard so I can compare that against SQL Server standard, which, is
the
whole point of my reply to DA - I'd rather not he pass on yet another
myth
from his marketing list.
--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials



"Mark Townsend" <markbtownsend@xxxxxxxxxxx> wrote in message
news:4400F1A7.3090701@xxxxxxxxxxxxxx
Tony Rogerson wrote:
Sorry this is pure nonsense. I've yet to see a single example, in
recent
years, of Oracle being more expensive than SQL Server. In fact I
think
the exact opposite is true.



I've searched for a comparison of features between SQL Server 2005
(Workgroup, Standard, Enterprise) and Oracle Standard and I don't
seem
to
be able to find it - can you supply a URL for us to go visit.

eweek did a comparison of the two (albeit Enterprise Editions) just
recently

SQLServer - http://www.eweek.com/article2/0,1895,1894609,00.asp
Oracle - http://www.eweek.com/article2/0,1895,1618793,00.asp

"However, by making management more complex, Microsoft has discarded
the
one significant advantage it had over Oracle Database 10g and IBM's
DB2-ease of administration. This makes DB2 and Oracle Database 10g
look
all the more attractive for their broader choice of development
frameworks, management interfaces, and server hardware and operating
systems."

This doc identifies the differences between the Oracle Standard and
Enterprise Editions -


http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family.pdf



It would appear for £2,000 per physical processor (that means you
pay
for
one even though its dual core) for the workgoup edition more than
meets
most company needs, you also have a free hot standby via database
mirroring, log shipping or clustering (in workgroup edition), I
can't
seem to work out the Oracle price but for a 2 proc machine (dual
core
for
instance) it starts to get silly.

Database mirroring isn't shipping yet, right ?

The price for Oracle Standard Edition One on a dual core machine is
$4995
US or 2902 GBP.



I doubt you'll reply with facts, more like a rant - but its worth a
try.












.

Relevant Pages

  • Re: Why not Access...?
    ... Next, I DID NOT SAY Oracle was considered a "best choice," only a sufficient ... It is a desktop application and the database in also on the same machine. ... I also want to know why Oracle is considered a best choice as compared to SQL Server. ... > Also, you need to answer the question regarding whether or not each client> will be using an individual database, and individual copy of a central> organization database, or making straight calls to a centralized ...
    (microsoft.public.sqlserver.server)
  • Re: Merge/Replication or Syncing with Oracle
    ... You can't directly access an Access database on the desktop from a WM 5 app, but you can sync between SQL Compact on the WM device and Access using the Access Syncronizer: ... As for the Oracle issue ... ... Where SQL Compact Edition easily does merge/replication to SQL Server using IIS ... ...
    (microsoft.public.sqlserver.ce)
  • Re: Oracle vs SQL Server as a back end for Access?
    ... post -- comparing back end database engines or replacing the front end ... say that Oracle 10g is better than SQL Server 2000 without determining ... whether or not the total cost of ownership of 10g over SQL Server ... developer than Oracle 10g, in spite of its new web interface. ...
    (comp.databases.ms-access)
  • Re: General Question about Performance/Tuning and scheduled Tuning
    ... I have a general question about Performance and Tuning. ... some application on a MS SQL Server, ... think that must be possible with a oracle server too. ... Database is so fast as before. ...
    (comp.databases.oracle.server)
  • Freezing Database or Server
    ... In Oracle there a way to 'freeze' a tablespace when doing a backup. ... Does SQL Server have a way to 'freeze' the tables or the database? ...
    (microsoft.public.sqlserver.server)