Hi All,

I tried to upload my clients 2005 db to my webhosting site (MSSQL 2000) and
....
"Error: The destination server is not 2005"

Surely this can't be, no backwards compatibility??
there must be a way,...? (And no way am I purchasing 2000 just for this!,
then manually re-creating the DB)

Anybody

Thanks
--
Neal Rogers
University of Cape Town

Why would you expect a database that has features that SQL2000 knows nothing
about to be able to deal with it properly? Where do you find any product
that is designed to incorporate new features into an older product? You
will need to script out the DDL using the 2000 feature set and then export
and import the data.

--
Andrew J. Kelly SQL MVP

"Neal" <Neal (AT) discussions (DOT) microsoft.com> wrote

I would have thought that 2005 would have 2000 features making it backwards
compatible with earlier versions. (like Excel and Access, Later versions can
read earlier spreadsheets and mdbs.
How does a webhosting company (or most companies in the world) then , handle
an upgrade (import into newer version from older versions) , without an
enormous amount of hassle?

AnyWay,

I have no idea what scripting out the "DDl" is, nor do I have the 2000
feature set (I have MSSQL 2005 and thats it)
I do however have Access and Upsizing from it to 2005 I have done before, so
Maybe I should rather tackle it this way, else create the tables and cols
manually and write a few rtn's in DotNet to read from the one db and insert
into the other... gonna take a fair amount of time and effort though.

Tx
Neal
--
Neal Rogers
University of Cape Town


"Andrew J. Kelly" wrote:

But the point is you are asking SQL Server 2000 to downgrade an incoming
2005 database. It is not 2005 doing the work here it is 2000 and it is
being asked to recognise features about which it has no knowledge. Even if
it was able to recognise the new features and remove them before bringing
the DB onboard, which would it remove? I doubt your application would work
after that.



--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



"Neal" <Neal (AT) discussions (DOT) microsoft.com> wrote