Re: Yukon beta questions

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Hilary Cotter (hilary.cotter_at_gmail.com)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 13:37:21 -0500

1) You will have to evaluate whether it is reliable enough for you. However,
it is unsupported so if you have a show stopping problem you are completely
out of luck. This alone makes many people very very very nervous about
using beta products in production. This been said when SQL 7 was in beta 3,
some companies were running it in production. I think it was 800 Flowers and
a few investment banks, but don't quote me on that. There may be licensing
problems with doing this.

2) the existing queries will work fine. But to be sure, please post them
here.

3) You would be best to DTS it over. A detach/attach will be a little
problematic due to the orphaned SQL FTS catalogs.

4) Follow Kent's advice.

"Kent Tegels (MVP)" <kent@tegels.org> wrote in message
news:#8#Jg1bxEHA.2016@TK2MSFTNGP15.phx.gbl...
> > 1. Is the current Beta release reliable enough for a commercial
> > application?
> I wouldn't say that, nor is it currently licensed for it. Just a general
note: perf is something that gets the most attention in the last betas, the
RCs and the RTM. I suspect that you want to wait a bit and try B3 in a test
environment first.
> > 2. Is any change required to full-text queries? We are currently using
the
> > CONTAINSTABLE clause.
> Hilary or John would know better than I. Gents?
> > 3. Can we migrate/import our existing SQL databases into Yukon?
> For the most part. You can get the a build of the BOL from Yukon from
http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&displaylang=en
(watch for wrap) and see some of the differences there.
> > 4. As new Beta releases come out, can we install them over the old
release
> > without uninstalling?
> No, and it is because of the CLR dependencies at least.
> Thanks,
> Kent Tegels
> MVP - SQL Server
>
> The SSX FAQ & Blog:
> http://tinyurl.com/6r4gb
> Looking for XM, the GUI for SSX? See both:
> http://tinyurl.com/4dfee and http://tinyurl.com/53hts
> My Blog:
> http://www.tegels.org/

Relevant Pages

  • Re: oracle pl/sql -> sql server
    ... >> already are running SQL 2005 in production, ... Anyone that would put a Beta into ... go-live license for SQL 2005, but it applies the Express Edition only. ... of a Microsoft programme, where they have close interaction with Microsoft. ...
    (comp.databases.ms-sqlserver)
  • Re: find out os from pl/sql
    ... SQL> SELECT * FROM gv$version; ... PL/SQL Release 9.2.0.6.0 - Production ... PL/SQL Release 10.2.0.1.0 - Beta ...
    (comp.databases.oracle.server)
  • Re: find out os from pl/sql
    ... SQL> SELECT * FROM gv$version; ... PL/SQL Release 9.2.0.6.0 - Production ... PL/SQL Release 10.2.0.1.0 - Beta ...
    (comp.databases.oracle.server)
  • Re: AMD 64 & SQL Server 2000 64bit
    ... Unfortunately it won't be allowed on a production ... "Peter Yao" wrote: ... > You can try SQL 2005 beta which is 64 bit native. ...
    (microsoft.public.sqlserver.setup)
  • Re: Lucid statement of the MV vs RM position?
    ... there's more than 30 years of production apps out there running ... second language) databases with SQL DBMS's without using SQL against ... so you told me the jury was out regarding modeling and implementing ... thinking behind the origins of SQL, ...
    (comp.databases.theory)