from Express to sql Server 2005

D

Dave Johnson

how to transform a database from sql server express edition to SQL
Server 2005 !!??

thanks i am just new to this :)



Sharing makes All the Difference
 
G

Guest

Dave,

I'm wondering if you can't just detach the database from express (using
Management Studio Express), copy the .mdf and .ldf files to 2005's Data
folder, and then attach to 2005?

Kerry Moorman
 
G

Guest

Actually all you have to do is to import, the SQL 20005 Server will see The
Express server just as another SQL server.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SMO for SQL Server 2008 Express AND SQL Server 2005 Express 6
reporting services 7
Different SQL Server versions and Entity Framework (ProviderManifestToken) 1
problem adding connection in vs 2005 sql 2005 express 2
Sql Server Express won't let me connect 8
Install SQL Server 2005 Express With ClickOnce? 1
Convert Access -> SQL Server 2005 1
Getting notification from SQL 2005 5

Top