Yes...there are numerous differences in features, data
types, T-SQL functionality, etc between 2000 and 2005.
You could start by going through the What's New in SQL
Server 2005 section in books online.
-Sue
On Thu, 26 Oct 2006 09:12:44 +1000, "Michelle M"
[quoted text, click to view] <nospam_muloguard-news@yahoo.com.au> wrote:
>Hi
>
>I will be developing an application in vb.net 2005 using SQL Server Express
>2005.
>
>The client already runs SQL Server 2000 though. When developing this app.
>is there anything that I need to be aware of that may cause an
>incompatibilty problem?
>
>I'm new to the SQL side of things. Any help/information/areas that I can
>further read/research is much appreciated.
>
>Many thanks
>Michelle
>
Hi Jonathan
Thank you for your respone.
I haven't yet crossed that bridge and discussed the logistics. I want to do
the research to see HOW is this possible and what needs to be done.
If I install SQL Server Express 5 on each of the machines, will that solve
any problems that you may be aware of?
Regards
Michelle
[quoted text, click to view] "Jonathan Roberts" <gremln007@nospamplease.gmail.com> wrote in message
news:edUKN9J%23GHA.3352@TK2MSFTNGP03.phx.gbl...
>
> "Michelle M" <nospam_muloguard-news@yahoo.com.au> wrote in message
> news:12jvrreclarto90@corp.supernews.com...
>> Hi
>>
>> I will be developing an application in vb.net 2005 using SQL Server
> Express
>> 2005.
>>
>> The client already runs SQL Server 2000 though. When developing this
>> app.
>> is there anything that I need to be aware of that may cause an
>> incompatibilty problem?
>>
>> I'm new to the SQL side of things. Any help/information/areas that I can
>> further read/research is much appreciated.
>>
>> Many thanks
>> Michelle
>>
>>
>
> Will your client be running both versions of SQL Server on the same box?
>
>
Thank you Sue for your reply.
I will have a look at the topics that you have referenced.
Many thanks
Michelle
[quoted text, click to view] "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:oq40k2d536oa5l6hn284ogstgs40uor8lk@4ax.com...
> Yes...there are numerous differences in features, data
> types, T-SQL functionality, etc between 2000 and 2005.
> You could start by going through the What's New in SQL
> Server 2005 section in books online.
>
> -Sue
>
> On Thu, 26 Oct 2006 09:12:44 +1000, "Michelle M"
> <nospam_muloguard-news@yahoo.com.au> wrote:
>
>>Hi
>>
>>I will be developing an application in vb.net 2005 using SQL Server
>>Express
>>2005.
>>
>>The client already runs SQL Server 2000 though. When developing this app.
>>is there anything that I need to be aware of that may cause an
>>incompatibilty problem?
>>
>>I'm new to the SQL side of things. Any help/information/areas that I can
>>further read/research is much appreciated.
>>
>>Many thanks
>>Michelle
>>
>
[quoted text, click to view] "Michelle M" <nospam_muloguard-news@yahoo.com.au> wrote in message
news:12k090qkch2fjee@corp.supernews.com...
> Hi Jonathan
>
> Thank you for your respone.
>
> I haven't yet crossed that bridge and discussed the logistics. I want to
do
> the research to see HOW is this possible and what needs to be done.
>
> If I install SQL Server Express 5 on each of the machines, will that solve
> any problems that you may be aware of?
>
> Regards
> Michelle
If your SQL Server machine will have both versions, the two versions might
"fight" for resources. If it is a good server and there isn't a large
amount of database activity in either database, you should be okay. I
believe there are some whitepapers from MS on running both versions on the
same machine. Check Google or Microsoft.com for some more details. Good
luck!
