Deploy VB.Net application with SQL Database

Hello,
I have an application with SQL data. I want to deploy this application with
data. How can I ?
Harsha
Harsha,
presumably you are talking about deploying publications/subscriptions? If
so, have a look at some of these scripts:
http://www.replicationanswers.com/Scripts.asp
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Because the To: list is so large perhaps you may be able to use
BACKUP/RESTORE?

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OLaoZEKdFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Harsha,
> presumably you are talking about deploying publications/subscriptions? If
> so, have a look at some of these scripts:
> http://www.replicationanswers.com/Scripts.asp
> HTH,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||I just use Detach / Attach. Include the database in the distribution (not in
the MSI) and have an application that Moves the database (if a move is
required) to a user choice location then attaches it. Very fast and simple
as the 'issue' database is copied directly off the CD once to the required
location then attached. Only issue with this is if you want to specify the
location of the ldb file, but thats easy enough.
- Tim
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
> with
> data. How can I ?
>
> Harsha
>
>
|||Another method is to create the database, objects and data using SQL
scripts. We use this technique in our application installers with
source-controlled scripts and it works quite nicely, especially when time
comes to upgrade our clients to a new version while retaining existing
customer data.
Hope this helps.
Dan Guzman
SQL Server MVP
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
> with
> data. How can I ?
>
> Harsha
>
>
|||FIX YOUR CLOCK
|||Tim wrote :
> I just use Detach / Attach. Include the database in the distribution (not
in the MSI) and have an application that Moves the database (if a move is
required) to a user choice location then attaches it.
Harsha wrote :
Thank you for your reply.
Please kindly explain me in brief how detach/atach works.
Harsha.
|||http://msdn.microsoft.com/library/en...da-di_83fm.asp
http://msdn.microsoft.com/library/en...ae-az_52oy.asp
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:espsmYXdFHA.796@.TK2MSFTNGP09.phx.gbl...
> Tim wrote :
> in the MSI) and have an application that Moves the database (if a move is
> required) to a user choice location then attaches it.
> --
> Harsha wrote :
> Thank you for your reply.
> Please kindly explain me in brief how detach/atach works.
> Harsha.
>
|||test
"Harsha Shah" <har_sha_99@.hotmail.com> wrote in message
news:eq8S7IJdFHA.220@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I have an application with SQL data. I want to deploy this application
with
> data. How can I ?
>
> Harsha
>
>
|||hi Harsha,
Harsha Shah wrote:
> Hello,
> I have an application with SQL data. I want to deploy this
> application with data. How can I ?
>
have a look at
http://msdn.microsoft.com/msdnmag/is...baseinstaller/ ...
it's a good article ..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply