Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manwith2thumbs
Starting Member
3 Posts |
 Posted - 2010-02-19 : 12:59:39
|
| I have a database that is copied off and stored in SQL Server 2000 format. Would I be able to use SQL Server 2008 Developer's Edition to query against this data? This data is static, there will be no future development...only a need to query against tables.I am interested in the lowest cost solution.Regards,Chris |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-19 : 13:03:42
|
| do you mean restore a sql 2000 db in sql 2008 server?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-19 : 13:11:30
|
| "I am interested in the lowest cost solution."Do you already have SQL 208 Developers Edition?If not SQL Express might be enough (and "free") |
|
|
|
manwith2thumbs
Starting Member
3 Posts |
Posted - 2010-02-19 : 13:46:55
|
| Yes, I need to restore the SQL Server 2000 Database. It was copied from a company network. Currently I don't own any SQL Server Database programs at all.If my wording sounds ignorant...it is because I am.Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-19 : 14:00:23
|
| You can restore SQL 2000 database backup to SQL 2005 or SQL 2008There may be some issues if the SQL 2000 backup contains some Enterprise Version features, but other than that you should be fine.Developer version gives you all features of Enterprise (very cheaply - but you can;t use it to host database for commercial purposes, only for DEV work Natch!) but in the short term why not download SQL 200 Express (AND SQL Express Management System so you have some tools to run SQL statement etc) and try restoring the database? |
|
|
|
manwith2thumbs
Starting Member
3 Posts |
Posted - 2010-02-19 : 14:04:16
|
| Thank you very much for your advice...sounds like a great way to proceed.Chris |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-19 : 14:09:53
|
Detailed (hopefully not needed ... but "just in case"  ) instructions on Restoring here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300#184356 |
|
|
|
|
|
|
Compatability