eport a database from ms sql 2005 to ms sql 2000

[Benign]

Hi:
I have Microsoft SQL 2005 Standard in my PC, I use CF 7.0/MS SQL 2005 to make
my application. I bought a 2 year hosting from Webserve.ca (NT PRO package).
Webserve.ca has MS SQL 2000. My problem is: If I design it in ms sql 2005 then
export it as a single file then import it in ms sql 2000 (in my webserve
hosting) will I have any problem? I mean I am worried about incompatibilities
and something like that. I have a short time for makeing that so I have no time
for making it again and if you tell me it will have some problems I will have
to buy/use a MS SQL 2000. So please help me and tell me what should I do.
Thanks
Benign

[Dan Bracuk]

The safest thing to do is beg borrow or steal ms sql 2000. Otherwise you may find that what works in development does not work in production.

[SafariTECH]

Unfortunately you stand a very high chance of it not functioning.

Usually Major version changes mean there are significant changes that are not
backwards compatible. I know that if you use a SQL 2000 db on a new SQL 2005
server, it goes through an up-conversion process and alters that previous db
for the new version. There would not be such a thing as a down-conversion in
SQL 2000