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 |
|
GreggPeters
Starting Member
1 Post |
 Posted - 2003-03-05 : 23:20:00
|
Does anyone have a step by step instructional tutorial for new people that explains how to upgrade your database from MSDE to SQL 2000?I have a database that someone installed on my web server and its running the MSDE, but I want to install SQL 2000 (the real one not the msde one).Can someone please explain the step by step process for upgrading a database from MSDE to SQL 2000?Thanks in advance!- Gregg Peters      |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2003-03-05 : 23:57:21
|
| Here is a kb article with some instructions for you...[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;325023[/url]hth,JustinExpect 0x80040106Edited by - justinbigelow on 03/05/2003 23:57:46 |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-05 : 23:57:29
|
| Guess the obvious way would be to back up all the databases, uninstall msde, install sql server then restore.Bit surprised if it doesn't give an option to upgrade though.==========================================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. |
|
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
Posted - 2003-03-07 : 16:26:17
|
| I've just detached databases from one flavor server and reattached to the other server. I've done this both from SQL 7 to MSDE 1.0 and from MSDE 1.0 to SQL 7. I assume SQL2000/MSDE2000 works the same way.======Doug G====== |
|
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-03-16 : 18:04:20
|
| MSDE is SQL Server, but its the engine only, without most of the client/administrative tools, and is less powerful than some versions of SQL Server. (like Enterprise), so a database can be detached from MSDE to SQL Server,and vice versa, as long as the server versions are the same.Sarah Berger MCSD |
|
|
|
|
|
|
Step by Step tutorial anyone?