MS SQL Server Express 2005 --> MS SQL Server 2005 1

[Luzian]

I have one of those "attachable" database files. I need to port this over to the server without "attatching" it.

 

[jbenson001]

What does that mean? If you have a sqlexpress db and want to now put it on a sqlsever2005 server, and use it, you will have to attach it.

 

[Luzian]

If you have a sqlexpress db and want to now put it on a sqlsever2005 server, and use it, you will have to attach it.

I realize that is an option, however I will not dismiss possible alternatives.

If you have a better understanding of how a normally created database is exactly the same as an attached database, I'd like to know that they are not different.

 

[jbenson001]

A database is a database. The fact that you detach it then attach it, does not change it in any way. It is simply a way of moving the database and log files to another machine.
You could also create a back up and do a restore, however I think using the detach/attach method is easier.