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 |
|
vinokure
Starting Member
1 Post |
 Posted - 2007-08-01 : 15:30:31
|
| I need to move the SQL Server 2000 Desktop Engine (MSDE) database and all jobs to the SQL Server 2005 Enterprise Edition. - May I detach and attach the DB in my case?- Where is the procedure to move the jobs from MSDE to SQL Server 2005? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-01 : 15:38:54
|
| Yes detach/attach will work fine. Just right click on the jobs and script them out. You can then use that script to create the jobs in 2005.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Move MSDE 2000 to the SQL Server 2005 Enterise