Re: Best Practices Analyzer - Feedback

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Christian Kleinerman [MS] (ckleiner_at_online.microsoft.com)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 14:22:01 -0800

BPA only works with SQL 2000, and will aid more in readiness for 2000 ->
Yukon. We currently don't have plans for bpa-like advisors for migrations to
previous versions.

- Christian

This posting is provided "AS IS" with no warranties, and confers no rights.

"glennf" <gfroemming@yahoo.com> wrote in message
news:3621B09D-5389-488B-A69D-2736DAC209C7@microsoft.com...
> Alan,
>
> I saw your post on MSDN. We are migrating SS7(in 6.5 compat) to 2000. I
was seeking a SQL code analysis tool to do a quick pass for no longer
supported constructs or potential semantic differences. I believe it was
Christian that responed to my post, suggesting bpa.
>
> What was the motivation of your use for bpa? For a 6.5 => 2000 upgrade,
how many of the potentially errant constructs will it catch, and which
types, that you are familiar with, is it likely to miss? One issue we are
aware of is handling of zero length strings. Apparently in 6.5 a
zero-length string is reported as NULL, while @ SS >= 7.0 it is simply a
zero length string. ... nice ... Would bpa catch something like this?
And can I point it directly at my 7.x DB?
>
> thanks,
>
> Glenn Froemming

Relevant Pages

  • Re: best practice analyzer help
    ... completion events - for those events, it will lookup the SQL text being ... If you create a trace file that captures batch/statement events, ... server and BPA will perform the scan. ... Trace files should be files generated by SQL ...
    (microsoft.public.sqlserver.tools)
  • BPA Tool wont run on SQL 2000 instances
    ... I am trying to run BPA 2005 tool on my SQL 2000 instances. ... I RDP in to SQL ... shows hour glass and does not do anything. ...
    (microsoft.public.sqlserver.tools)
  • Re: BPA Tool wont run on SQL 2000 instances
    ... "Chris Wood" wrote: ... I am trying to run BPA 2005 tool on my SQL 2000 instances. ... shows hour glass and does not do anything. ...
    (microsoft.public.sqlserver.tools)
  • Re: BPA Tool wont run on SQL 2000 instances
    ... I am trying to run BPA 2005 tool on my SQL 2000 instances. ... I RDP in to SQL ... shows hour glass and does not do anything. ...
    (microsoft.public.sqlserver.tools)
  • Re: ADO.NET 2.0 saving single space to SQL?
    ... SqlParameter param = mCmd.Parameters.Add; ... The value in the problem case is a string with a zero length. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)