sql server msde: I have a Windows XP Home in a Laptop running VB .NET
Standard 2003, MSDE 2000 and Office Professional 2003.

I've been able to complete all the the exercises (except
of course those regarding IIS) in the Visual Basic .NET
2003 Step by Step book.

I start to follow the exercises in ADO .NET Step by Step
book and I have my first problem because it needs MSDE
for handling SQL DBs, but after downloading it and
several hours installing, configuring and testing it,
finally I could access the sample databases.

My questions now are:

1) How can I create a SQL DB that I can use in my
development environment while I build an application?

2) After finishing my application what are the steps to
generate a CD that includes my application with the DB. I
already know how to generate a Deployment project, but
not with the DB. Is it possible only to copy the DB files
to that CD or there is a specific procedure to follow?

3) What are the steps to follow for installing everything
in the user computer?


I've been looking for the last 2 days for a document or
documents in Microsoft web site that explain this
procedure but I have not find anything that at least give
me an idea.

Hi ,

Have you tried using these Kb articles . Hope they are useful

1)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html
/usingmsde.asp - Using MSDE to Build Scalable Solutions That Migrate to SQL
Server

2) http://www.microsoft.com/sql/msde/techinfo/MSDEintegration.asp -
Integrating MSDE 2000 with Your Applications

3) http://www.microsoft.com/sql/msde/techinfo/reskit/deployreskit.asp -
MSDE 2000 Deployment Resource Kit

Girish sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Girish.

Thank you for answering.

I've read the KB articles you mentioned but:
No. 1 is for VB 6.0 and MSDE 1.0, and I have VB .NET 2003
Standard and MSDE 2000.

No. 2 talks about what I have already done in my
development environment.

No. 3 requieres VS .Net Professional 2003 and I have
VS .net 2003 Standard.

Do you know about any KB regarding the sw versions I
have: VS .Net 2003 Stand, VB .NET 2003 Stand and MSDE
2000.

At this moment I do not need a full automated procedure,
but the critical steps to follow for each of my
questions, if you have examples, would be great.

Thanks

[quoted text, click to view]
http://www.microsoft.com/sql/msde/techinfo/MSDEintegration
..asp -
[quoted text, click to view]
http://www.microsoft.com/sql/msde/techinfo/reskit/deployre
skit.asp -
[quoted text, click to view]