Re: SQL 6.5 upgrading to SQL 2005 suggestion needed

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

Using ODBC
Application divided into 2 parts:
1. client/server WinForm app using VB5. The app is running on the client side
2. WebForm on IIS5.0
both calling stored_procedures executed on SQL 6.5

Thanks~
Cheng

"laurnet banon" wrote:

> How your application is connected to your database? ODBC? Is your
> application on the same server than SQL?
>
>
> "SQL65to2005" <SQL65to2005@xxxxxxxxxxxxxxxxxxxxxxxxx> a écrit dans le
> message de news: F75E0208-BD6B-47EF-BA7B-673B2B7127C1@xxxxxxxxxxxxxxxx
> > thanks a lot for the advise.
> >
> > How about the application level (VB5) on SQL 2005?
> >
> > Thanks~
> >
> > "laurnet banon" wrote:
> >
> >> Hi,
> >>
> >> I have made a lot of migration from sql 6.5 to 2000.
> >> The files architecture between 2000 and 2005 are the same. The T-SQL is
> >> more
> >> complete so the process is nearly the same to migrate from 6.5 to 2000.
> >> According that the T-SQL is little bit different between 6.5 and 2005, I
> >> will advice you to have 2 environment, one in 6.5 and the other in 2005.
> >> You should rewrite some code to work both in 6.5 and 2005. When your test
> >> wok, you could migrate,
> >>
> >> Regards,
> >> Laurent
> >>
> >> "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx> a écrit dans le message de
> >> news: uc9U17DyFHA.3812@xxxxxxxxxxxxxxxxxxxxxxx
> >> > Hi
> >> >
> >> > There is no supported direct upgrade path from SQL Server 6.5 to 2005.
> >> >
> >> > There is an upgrade wizard to SQL Server 2000. From there, you can do a
> >> > backup and restore into SQL Server 2005.
> >> >
> >> > SQL Server 2000 BOL has all the information on the upgrade.
> >> >
> >> > Regards
> >> > --------------------------------
> >> > Mike Epprecht, Microsoft SQL Server MVP
> >> > Zurich, Switzerland
> >> >
> >> > IM: mike@xxxxxxxxxxxx
> >> >
> >> > MVP Program: http://www.microsoft.com/mvp
> >> >
> >> > Blog: http://www.msmvps.com/epprecht/
> >> >
> >> > "SQL65to2005" <SQL65to2005@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> > news:73853182-EC0E-43F6-BA79-8A114EF327E5@xxxxxxxxxxxxxxxx
> >> >> Dear guru,
> >> >>
> >> >> Please kindly provide your concerns and suggestions for the smooth
> >> >> upgrading
> >> >> path.
> >> >> - Downtime on weekend is acceptable.
> >> >> - SQL 6.5 English on NT4 machine
> >> >> - Database filesize 20GB
> >> >> - Application: VB5 + ASP ( no plan for .NET at the moment)
> >> >> --> compatible with new environment?? i think this would be a key
> >> >> pain
> >> >> here.
> >> >> - SQL 2005 CHT on Windows 2003 CHT will be installed on a new machine.
> >> >> - If staging is reccomended then I will prepare.
> >> >> - DB: backup/restore, copy database wizard, de/attach... which one
> >> >> covers
> >> >> better?
> >> >> - System DBs/logins/jobs?
> >> >>
> >> >> Thanks in advance.
> >> >>
> >> >> Best regards,
> >> >> Cheng
> >> >
> >> >
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: SQL 6.5 upgrading to SQL 2005 suggestion needed
    ... ODBC is not the most effiency layer comparing to OLEDB but it woks ... client/server WinForm app using VB5. ... > both calling stored_procedures executed on SQL 6.5 ...
    (microsoft.public.sqlserver.setup)
  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL using C
    ... I am almost a new C programmer and now I need to use SQL within my C ... The people who are telling you to use a C API are out of their mind. ... is not less complicated than ODBC and ties the user to a single ...
    (comp.lang.c)
  • Re: Quick primer on Unidata-to-SQL Server Connectivity?
    ... but creating a view and then running an SQL query with more than one ... but somewhat extensive experience with UniData SQL. ... until some things improved in UniData ODBC. ...
    (comp.databases.pick)
  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)