Moving a database

[Guest]

I am using the MSDE version of SQL Server in order to create a SQL database.

Once I have reated the database, how would I go about sending it to a
colleague so that he can install it on his version of SQL Server? Is it just
a case of sending the MDF file from the Data folder of SQL Server? If so,
how would he then install it on his server?

Hope you can help.

 

[Cor Ligthert [MVP]]

Cahsdesk,

The best thing you can do is moving to another database engine. The most
terrible thing wiht MSDE is to deploy it. This is the replacement for that
one.

http://msdn.microsoft.com/vstudio/express/sql/download/

http://msdn2.microsoft.com/en-us/library/ms365247.aspx

I hope this helps,

Cor

 

[Miha Markic [MVP C#]]

Either detach it and send mdf and ldf files or create a backup and send him
the backup file.