Compatability with SQL Server 2000

[dmctiernan]

Hi All,
I am in the process of developing a database on SQL Server 2005 and I am wondering if there are any guidelines I will need to follow in order to ensure that the resulting database will attach and run on SQL Server 2000.

I work for a small engineering company and I do some small software projects as a means of learning. SQL Server 2005 is what I use for database development at home however at my office where the database will run, we run SQL Server 2000 as this is the backend to our ERP system so upgrading this is not really an option for me.

Any guidelines or suggestions would be appreciated.

Thanks in advance,
Declan.

 

[TysonLPrice]

One way to be sure is to set the compatibilty level on the 2005 side to 2000. You lose the 2005 features but you know it will port over.

 

[pjw001]

To TysonLPrice: Do you know that this will work? My understanding was that if a database is created at 2005 there is no way of attaching it to 2000.

To Declan: I think I would want to try this before doing too much work on it.

 

[TysonLPrice]

I'm not a DBA, application programmer, but in my shop when we went to 2005 the way some of the joins were written were failing. The DBAs set the compatibility to 2000 as a short term solution. I found this out when trying to use some of the new 2005 features on those databases and they didn't work.

I believe I am correct that 2005 can be set to 2000 compatibility. The gurus here can chime in if I am wrong.

 

[fredericofonseca]

tyson,

It would probably help other viewers if you posted some samples of the joins that FAILED as it may help others to improve their code.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[TysonLPrice]

As I mentioned I'm an applications programmer not a DBA. I just spoke to them and they don't remember the specifics. They pointed be to this link however. Maybe that will help the OP.

http://msdn.microsoft.com/en-us/library/ms178653(SQL.90).aspx