Mandy,
MSDE is SQL server. Minus the tools and GUI.
Therefore your database can simply be backed up on SQL server and
restored to MSDE.
MSDE does however support replication so if the stand alone and SQL
server versions are ever on the same network replication should do the
job nicely for you.
Here is a link to MSDE replication
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q324992
If your application uses SQL reporting services they are not available
in MSDE. If you can wait, and do your development using BETA software,
SQL Express will support reporting services when it is released
http://www.microsoft.com/sql/express/default.mspx
If you need anything else just post again.
Matt
mandy_vb6 wrote:
>I have written an application using VB6 and SQL Server. It has now
>become necessary to also have a standalone version of the application.
>I have heard about MSDE and I think I should perhaps use this as the
>database for the standalone application. I will have to write code to
>import and export data between the two applications.
>
>The problem is that I don't even know where to start with this. I was
>wondering if any of you could point me to some beginner's information
>on MSDE. I have no idea where to even start with this. I also don't
>know how I will import and export the data - do any of you have any
>idea as to what would be the best way to do this?
>
>Thank you so much!
>
>
>
>
>
>'// =======================================================
> Rules : http://ReliableAnswers.com/List/Rules.asp
> Home : http://groups.yahoo.com/group/vbHelp/
> =======================================================
> Post : [email protected]
> Join : [EMAIL PROTECTED]
> Leave : [EMAIL PROTECTED]
>'// =======================================================
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
