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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-31 : 07:51:04
|
| eric writes "Is there any utility to check for errors before converting .mdf files to and from MSDE 2000, SQL Server 7, and SQL Server 2000? I know that there are some small variations between the 3 database formats and do not know how to check for version incompatibilies myself.Thanks.Eric Maksim" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-10-31 : 11:42:55
|
| No, that is why you should run this on a test system first. You should not do this in production unless you have already successfully tested this in a test environment. There aren't any version incompatibilities, so I'm not sure what you are referring to.Tara |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-31 : 17:06:23
|
| The only incompatibilities I can think of are some new reserverd words in 2000 that were not reserved in 7.0. However, there may be some other issues such as logins, jobs and DTS packages not being transferred. Also, indexes and statistics should be rebuilt/updated. I wrote an article on moving from 7.0 to 2000 you might want to review for other tidbits.Part 1: [url]http://www.sqlteam.com/item.asp?ItemID=9066[/url]Part 2: [url]http://www.sqlteam.com/item.asp?ItemID=9465[/url]--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-04 : 12:51:51
|
| Well, incompatibilities will not exist when you initially upgrade since the database compatibility mode will not be set to 80. The incompatibilities will arise when you change it.Tara |
|
|
|
|
|
|
.mdf - .ldf version conversion