• 0

sql server 2000


Question

Hi Guys,

I'm developing an application for work (manage small number of patients, for a hospital) i've only got access to SQL 2000 in work and was wondering if it was possible to get hold of a copy so i can develop the application at home or weather or not if i used the 2005/2008 versions of sql - but not using any features specific to these versions - would i be ok migrating the data/table structure to sql 2000 when deploying the application?

hope this makes sense.

Thanks,

Michael

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

as far as i know you would not be able to restore a sql 2005/2005 database to an older version, you would however be able to script it off and recreate your db on the target machine without issue.

check out a tool called SQLCompare from Redgate, it would also be quite useful for deployment/bug fixes.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.