"Ken Sturgeon" <aksturgeon@charter.net> wrote in message
news:ePKUlrUEGHA.1124@TK2MSFTNGP10.phx.gbl...
>I know this will seem to be an elementary question but since most of my
>programming experience is with ASP and SQL Server 2000 I have very little
>experience deploying windows applications that have a supporting database.
>
> I currently have SQL Server 2000, 2005 and SQL Server Express installed on
> a Windows XP Pro machine. I'm working on a VB.NET windows app using VS2005
> and I'd like to deploy it with an MSDE (I think that's the right term)
> data base... a SQL Express db.
>
> In light of the fact that I can access the SQL Express engine from SQL
> Server 2005's Management Studio I'm assuming that I can create the
> database directly from the interface, connect to it and deploy it with my
> windows app. Is that correct? If not, must I build the MSDE db from within
> VS2005?
>
> To deploy the database with the app, will I end up having to package SQL
> scripts to create the database and populate it with default data or can I
> simply include the db file in my windows deployment package?
>
> Any help or pointers to online references that address my questions is
> greatly appreciated.
>
> Thank you very much,
> Ken
>

"Roger Wolter[MSFT]" <rwolter@online.microsoft.com> wrote in message
news:%23I%23AQLXEGHA.984@tk2msftngp13.phx.gbl...
> just copy the mfd and lfd files and attach them on the destination
> machine. There's more information here:
>
> http://msdn.microsoft.com/library/en-us/dnsse/html/EmSQLExCustApp.asp?frame=true
>
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>
> "Ken Sturgeon" <aksturgeon@charter.net> wrote in message
> news:ePKUlrUEGHA.1124@TK2MSFTNGP10.phx.gbl...
>>I know this will seem to be an elementary question but since most of my
>>programming experience is with ASP and SQL Server 2000 I have very little
>>experience deploying windows applications that have a supporting database.
>>
>> I currently have SQL Server 2000, 2005 and SQL Server Express installed
>> on a Windows XP Pro machine. I'm working on a VB.NET windows app using
>> VS2005 and I'd like to deploy it with an MSDE (I think that's the right
>> term) data base... a SQL Express db.
>>
>> In light of the fact that I can access the SQL Express engine from SQL
>> Server 2005's Management Studio I'm assuming that I can create the
>> database directly from the interface, connect to it and deploy it with my
>> windows app. Is that correct? If not, must I build the MSDE db from
>> within VS2005?
>>
>> To deploy the database with the app, will I end up having to package SQL
>> scripts to create the database and populate it with default data or can I
>> simply include the db file in my windows deployment package?
>>
>> Any help or pointers to online references that address my questions is
>> greatly appreciated.
>>
>> Thank you very much,
>> Ken
>>
>
>