Express to Developer

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

do you have any databases you want to keep?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 2

[font="Verdana"]While doing inplace upgrade the only problem is you can't rollback easily.

Main is that take a backup of all your databases, logins.[/font]

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 3

Thanks for reply,

1)How to backup logins???

2)Is there any SQL Server upgradation tool ???

Now am planing to take all the backups and

1) install developer edition then detach all the database from express and then attach to developer editon(offline)

2)Backup and Restore (online)

Is it possible for inplace upgradation from EXPRESS to Developer

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

Ratheesh

i would install SQL2005 developer alongside as a separate instance.

move databases, logins, etc to the new instance.

remove the old one when finished.

script the logins off using the MS script at

detach and re attach the databases, then add the logins back.

Make sure to attach the databases first otherwise the logins may fail as the script may not be able to set the default database if it doenst exist

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 5

SSC-Dedicated

Points: 36097

July 17, 2008 at 3:48 am

Thanks Perry 🙂

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 6

Those scripts are for 2000:sick:.Am having SQL Server 2005 Express so how can i script out all logins other than doing one by one .