Re: Convert Express To Server

I just read this again - of course I meant the mdf and ldf files you need
both to do the attach. Backup and restore would also 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

"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uPLdDAseGHA.4276@xxxxxxxxxxxxxxxxxxxxxxx
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