save 2005 sqldatabase as 2000 database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul - 12 Mar 2008 16:07 GMT

Hi just wondering if anyone knows if you can save a 2005 database as a 2000
database so it can be opened and used in 2000?
thanks.

Signature

Paul G
Software engineer.

Reply to this Message

bruce barker - 12 Mar 2008 16:17 GMT

no, they are not compatiable (even backups). you will need to export/import
the data. you can use bcp or ssis

-- bruce (sqlwork.com)

> Hi just wondering if anyone knows if you can save a 2005 database as a 2000
> database so it can be opened and used in 2000?
> thanks.

Reply to this Message

Paul - 12 Mar 2008 17:07 GMT

ok thanks for the information.

Signature

Paul G
Software engineer.

> no, they are not compatiable (even backups). you will need to export/import
> the data. you can use bcp or ssis
[quoted text clipped - 4 lines]
> > database so it can be opened and used in 2000?
> > thanks.

Reply to this Message

Rate this thread:

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...