Re: Convert Express To Server

Even easier - attach the mdf file to the new server. Everything is the same
as I said so the files will just work

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"MDB" <mdb@xxxxxxxxxxx> wrote in message
news:usy4%23KqeGHA.968@xxxxxxxxxxxxxxxxxxxxxxx
I figured out a way to do this somewhat easily (scripted db and then
exported data.)

Thanks

"MDB" <mdb@xxxxxxxxxxx> wrote in message
news:Ox1AY1peGHA.1276@xxxxxxxxxxxxxxxxxxxxxxx
Thank you, I still have a question though. Is there an easy way to
transfer all of my tables,views, stored procedures and data from one to
another?

"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OF1OlkpeGHA.3888@xxxxxxxxxxxxxxxxxxxxxxx
There is no difference between the Express database and any of the other
SQL Server 2005 Editions.You may have some connection string issues if
your Express database was used in a User Instance but the database files
are identical.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"MDB" <mdb@xxxxxxxxxxx> wrote in message
news:%23PvgFtmeGHA.4304@xxxxxxxxxxxxxxxxxxxxxxx
Hello All, is there a easy way to convert a sql server express mdf to
a Sql Server 2005 db? I developed an app using express not realizing
my host doesn't support express.









.

Relevant Pages

  • Re: OT - newsservers?
    ... I have since found a server that works, ... Speed: 67220 kb Groups: 109673 Posting: Yes ... Username: None Password: None ... Binaries: Yes Location: United States ...
    (sci.geo.geology)
  • RE: OWA - cant send, reply, or show calendar views
    ... Microsoft CSS Online Newsgroup Support ... This posting is provided "AS IS" with no warranties, ... As you mentioned, the OWA work fine on the SBS Server, but it have ... Please try to test it on other client ...
    (microsoft.public.windows.server.sbs)
  • Re: MI5 freak out...
    ... nanny wrote: ... Paul, I did the next best thing: after you heard from weirdo's server, I ... If a user on Altopia is causing it, we may disable their posting ...
    (alt.med.fibromyalgia)
  • Re: userenv and NETLOGON errors
    ... From an ipconfig? ... I never knew doing that from my SBS server would ... Keep posting, I'll keep pointing out that it's FUD. ... security by obsecurity is no security at all. ...
    (microsoft.public.windows.server.sbs)
  • Re: Slow update
    ... This posting is provided "AS IS" with no warranties, ... I'm afraid I don't know much about the SQL server itself ... I'm updating a table on a database i.e. I've ...
    (microsoft.public.dotnet.languages.vb)