Local 2K5 server & Remote 2K server

Hi,
I was wondering what the issues I might face if I were to upgrade my
local SQL server to 2005 while my remote hosting server is still SQL
2000. Are there huge differences in formats of dbs, tables, jobs, etc
or is it largely UI & feature enhancements?
There isn't a great deal of interation between the servers, but I would
like to be able to, for instance, continue exporting a nightly copy
down to my local server and it being useable without too having to
re-jig things too much.
Thanks for any help you can lend,
MickMick
I have installed on my pc sql server 2005 and linked/connected to sql server
2000 . By saying "nightly copy" dod you mean a backup of the database and
then restore in on local server. It is also possible.
<mick.hodgson@.gmail.com> wrote in message
news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...
> Hi,
> I was wondering what the issues I might face if I were to upgrade my
> local SQL server to 2005 while my remote hosting server is still SQL
> 2000. Are there huge differences in formats of dbs, tables, jobs, etc
> or is it largely UI & feature enhancements?
> There isn't a great deal of interation between the servers, but I would
> like to be able to, for instance, continue exporting a nightly copy
> down to my local server and it being useable without too having to
> re-jig things too much.
> Thanks for any help you can lend,
> Mick
>|||Thanks Uri,
It is a nightly DTS Export which copies the database objects down to
the local server.
Do you have the full 2005 database engine on your PC or just the client
tools? I need to know i can develop on a SQL2005 db and it will work
when uploaded to the SQL2000 db.
Thanks again!
Mick
Uri Dimant wrote:[vbcol=seagreen]
> Mick
> I have installed on my pc sql server 2005 and linked/connected to sql serv
er
> 2000 . By saying "nightly copy" dod you mean a backup of the database and
> then restore in on local server. It is also possible.
>
> <mick.hodgson@.gmail.com> wrote in message
> news:1162982342.259348.291440@.m73g2000cwd.googlegroups.com...|||Mick
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
Yes, I do. Using DTS/SSIS to move the data is a headache ,epsecially
between 2000/2005.
Most likely to backup database on the sql server 2000 and restore on sql
server 2005
<mick.hodgson@.gmail.com> wrote in message
news:1162986618.135708.111690@.m7g2000cwm.googlegroups.com...
> Thanks Uri,
> It is a nightly DTS Export which copies the database objects down to
> the local server.
> Do you have the full 2005 database engine on your PC or just the client
> tools? I need to know i can develop on a SQL2005 db and it will work
> when uploaded to the SQL2000 db.
> Thanks again!
> Mick
> Uri Dimant wrote:
>