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 |
|
keithc
Starting Member
35 Posts |
 Posted - 2004-12-13 : 08:58:41
|
| Can anyone explain differences between MSDE and SQL. I thought MSDE was Personal Edition with a new name. I was wondering if there are differences in backing up restroring databases in MSDE as compared to like SQL standard or enterprise editions? |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-13 : 09:52:25
|
| Start looking at Express...Goes up to a 4gb restrictionb up from 2, but loses other "features" like replication...but you could build your own anyway...It's still in Beta 2, but should be released soon...AND it's built on SQL Server 2005 technology, which has a lot of neat features....Brett8-) |
 |
|
|
keithc
Starting Member
35 Posts |
Posted - 2004-12-13 : 11:23:51
|
| Thanks X i'll check into it. I am taking it then that MSDE is Personal Edition with a different name so it is basicly localy accessable only?Also, was wondering about opinions on Mysql |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-12-13 : 11:30:50
|
| No. msde doesn't have the client tools and there are some features that aren't supported - see the link I posted.Mysql is as mature as sql server and it costs money unlike msde.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
MSDE