my first experience distributing the new-built sql db onto client machine?

[ssfftt]

hi i am new to mssql db stuff. I just developed my first VB.NET application and it uses a mssql database which is hosted locally on my development machine. I built the deployment msi file for my application which can be installed easily on client machine, but have no idea how to move the mssql db with it.

the client machine is a laptop with XP Home installed. and it's clean, no other software installed.

oh, btw, i use VB.NET 2003, MS Server Service Manager Version 8.00.760 and SQL Server Enterprise Manager.

Please help...

 

[Tarik]

Embedding MSDE 2000 Setup into the Setup of Custom Applications

Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Deployment Toolkit (Sample Application)

Deploying MSDE with VB .net

Another Way is to restore database backup through simple batch you can make or by running the Generated DB script through OSQL from a batch too

 

[ssfftt]

thanks tarik, i appreciate ur help, and i think i will learn how to do this in the links u provided, cheers