My host runs SQL Server 2000, i have SQL Server 2005. What to do?

Hi,

the title of this topic about summarises it. I have a dev-machine with SQL Server 2005 Standard edition on it. My host runs SQL Server 2000. What are my options?

Is there some sort of backward compatibility? Can i export as 2000?

I have no idea and i can't find anything about this particular problem.

Thanks

2 solutions:

Move your database to SQL Server 2000 or|||

The possibility to script the database/objects makes it rather easy to generate a script in SQL 2005 and run the script in SQL 2000 Query Analyzer.

There is a feature (dropdownbox) that is named : Script for version.

If you select SQL Server 2000, you'll eliminate many of the SQL 2005 specific commands.

Clientwise... You have to use the SQL provider, I don't think the NAtive provider for 2005 works with 2000 (please feel free to prove me wrong on this...)

/micke

|||The main difference SQL Server 2000 uses TDS(tabular data stream) 80 while SQL Server 2005 uses TDS 90 but SQL Server 2005 also require file groups in the create table statement, so you can create a blank database in SQL Server 2000 and do INSERT INTO with column list per table which gives you control of the insert. The other alternative is to look for SQL Server 2005 hosting provider. Hope this helps.