April 28, 2008 at 3:08 pm
I'm a SQL Server newbie coming from Oracle. Could someone please give me a high level start on how to convert a small 2005 db to Express 2005. I've read this forum and am familiar with and have the DTSWizard...but I'm missing something.
thanks
May 1, 2008 at 1:46 pm
Unless the database specifically uses features that SQL Express doesn't support (there are a few, but mainly in terms of enterprise databases and server automation, probably doesn't apply), you can simply detach the database from one server, move it to the SQL Express Server, and attach it there.
Have you tried this? If so, does it give you an error?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 12, 2008 at 9:53 am
I was pushed onto a different project and am back on this one. Your suggestion worked perfectly. Too easy. I like M.S. SQL Server. Thanks!!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply