Re: SQL server 2005

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

From: simon (simon.zupan_at_stud-moderna.si)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 14:17:11 +0200

thank you for your answer.
There is still one question:

Can I copy the database from sql2000 to sql 2005 and work like before. Does
SQL 2005 support SQL 2000 database?
Than I can uninstall SQL2000.

Or I have to have both SQL servers installed?

Thank you,
Simon

"pakerblom" <pakerblom@hotmail.com> wrote in message
news:uDThfRcsEHA.3148@TK2MSFTNGP10.phx.gbl...
> Yes, you can install SQL 2005 on your desktop running XP (Beta 2 is a
> Developer Edition).
> Yes, you can run both SQL 2000 and SQL 2005 on the same machine (give SQL
> 2005 an unique instance name - not default)
> A good start would be A First Look at Microsoft SQL Server 2005 for
> Developers (0321180593)
>
> /Patrick
>
> "simon" <simon.zupan@stud-moderna.si> wrote in message
> news:uF$JZ4bsEHA.3196@TK2MSFTNGP14.phx.gbl...
> >I have SQL2000 Personal version on windows XP.
> > For development purposes it works fine.
> >
> > Now, I would like to start to learn programming in new SQL server 2005.
> > Can I install SQL 2005 beta2 version on windows XP or I must first
install
> > windows server 2003?
> >
> > Than, I have a lot of projects on my computer in SQL2000. I don't want
to
> > lose them or change them.
> > So, can I have both instalations, SQL2000 and SQL2005 on my computer?
> > Or I should copy all my databases from SQL2000 to SQL2005 - will that
> > work?
> >
> > And final, is there any recomended book about diferences of SQL2000 and
> > SQL2005.
> > I would like to start programing sql procedures in .NET - is that good
> > option?
> > Is some different news group for sql2005 or I can use this one?
> >
> > Thank you for answers,
> > Simon
> >
> >
>
>

Relevant Pages

  • Re: Dont understand what version of SQL to install
    ... I created a database using sql 2005 express edition. ... With that in mind - could you use SQL Server 2008 Developer Edition? ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to
    ... Go to the Database tab and click on the browse button next to the connection string. ... In the New Database Reference dialog, enter the details for the database where you want to deploy the assembly and create the user defined aggregate. ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: Dont understand what version of SQL to install
    ... but "moving" a database implies a degree of automation. ... Principal SQL Infrastructure Consultant ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: Dont understand what version of SQL to install
    ... Subscription and I still have to pay $49 to use SQL Developer? ... I don't think you have to buy another license for the Developer Edition, but you better ask this question to whom you bought it. ... it's not stated that SQL Server 2008 Enterprise Edition can be ... > So I can use SQL Developer 2008 to create a database in standard 2005, ...
    (microsoft.public.sqlserver.setup)