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_at_comcast.com...


>

> "Tony Rogerson" <tonyrogerson_at_sqlserverfaq.com> wrote in message

> news:dtspt4$amv$1$8302bc10_at_news.demon.co.uk...

>> > 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_at_comcast.com...

>> >

>> > "Tony Rogerson" <tonyrogerson_at_sqlserverfaq.com> wrote in message

>> > news:dtrqsr$ocv$1$830fa79d_at_news.demon.co.uk...

>> >> > 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_at_comcast.net> wrote in message

>> >> news:4400F1A7.3090701_at_comcast.net...

>> >> > 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.

>> >> >>

>> >> >

>> >>

>> >>

>> >

>> >

>>

>>

>

>