Re: Convert Express To Server

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: Scripting T-SQL CREATE Statements
    ... a backup of user-defined SQL Server objects. ... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ...
    (microsoft.public.sqlserver.programming)
  • Re: Convert Express To Server
    ... all of my tables,views, stored procedures and data from one to another? ... your Express database was used in a User Instance but the database files ... Use of included script samples are subject to the terms specified at ... Sql Server 2005 db? ...
    (microsoft.public.sqlserver.setup)
  • Re: Generate sql script for encrypted stored procedures
    ... Nhan, you could try ... Once it is encrypted you can script it out. ... >> I encrypted my stored procedures in SQL Server 2K to deploy to the ...
    (microsoft.public.sqlserver.security)
  • Re: Strongly Type Datasets
    ... Schema for that login. ... It won't create the stored procedures. ... The SQL script it generates is based on a SQL login so the script looks ... some way or my permissions are wrong in SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Can I search for a string in a set of stored procedures?
    ... want to go through a database full of many stored procedures to find ... my version of Sql Server Management Studio? ... Alternatively stored procedures of the database can be scripted by ... Microsoft) to script each stored procedure to individual files. ...
    (comp.databases.ms-sqlserver)