Moving a database

2 Jul 2006 9:09 AM

cashdeskmac

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.

2 Jul 2006 10:05 AM

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

Show quote

"cashdeskmac" <cashdesk***@discussions.microsoft.com> schreef in bericht
news:F3EF35FD-665D-4AA4-98AE-D39C0922F230@microsoft.com...
>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.

2 Jul 2006 12:25 PM

Miha Markic [MVP C#]

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

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Show quote

"cashdeskmac" <cashdesk***@discussions.microsoft.com> wrote in message
news:F3EF35FD-665D-4AA4-98AE-D39C0922F230@microsoft.com...
>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.