SQL2005 to SQL2000

[Greg]

I have a potential customer who I demonstrated my software to that seems
interested in buying. But, my software is using SQL 2005 Express and this
client already has a full version of SQL Server 2000 installed and would
rather use that than 2005. I told them I was 99.9% sure there would be no
problems installing our SQL2005 database to their SQL2000 server.

Our database is a very simplete database. What I mean by simple is that its
not like a banking system that processes massive volumes of data, or its not
a database that really uses any of the tools provided by SQL Server. What I
mean by this is I've basically just created tables, stored procedures, views
and functions and have an Access database that connects to it.

With this is mind, would my SQL2005 database be able to be restored to a SQL
2000 Server? If so, are there any special things I must do to make by
database compatiable with 2000?

Plus, if we do this, and I end up sending out an update script in the future
to add new tables, fields, stored procedures, etc to our database, would
these work fine in 2000 if they were developed in 2005?

Again, remember, my database is a simple database and I'm not using all the
fancy features of SQL Server to manage my database.

Thanks,
Greg

 

[Sylvain Lafontaine]

Well, I am - like you - sure at 99.9% that it will work correctly without
any problem. I don't know if you can restore directly to SQL2000 from a
backup of SQL2005 but the sql scripts should be compatible without any
problem, including the updating scripts. For the rest, you will have to make
some tests by yourself to be sure. I suggest that you install a copy of
MSDE 2000 somewhere in order to perform these tests. If you install it on a
machine with SQL-2005 already installed, maybe it would be a good idea to
reinstall the later to make sure that everything is OK.

 

[Peter Yang[MSFT]]

Hello Greg,

The database backed up in SQL 2005 cannot be restored on SQL 2000 Server.
Also, the database detached from 2005 cannot be attched to 2000 servers.

You need to use SSIS/DTS to transfer data between tables on these 2
servers. YOu could use script to create the objects and then transfer the
data between the objects.

If you have any further qusetions or concerns, please feel free to let's
know. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Tom van Stiphout]

On Thu, 15 Nov 2007 14:42:01 -0800, Greg

Why would you expect that SQL2000 is forward compatible with SQL2005?

If you script your objects, you may well be able to recreate them in
SQL2000, or at most make minor changes to the scripts.

-Tom.

 

[Peter Yang[MSFT]]

Hello Greg,

I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

======================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================