467,915 Members | 1,155 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

How to Deploy SQL server Database to another PC while creating SetUP package in .Net VB

How to Deploy SQL server Database to another PC, How to create a
package that craetes Database as well as ODBC driver for accessing data
at enduser PC, using .Net VB

Jul 23 '05 #1
  • viewed: 6475
Share:
2 Replies
hi,
<hi********@gmail.com> ha scritto nel messaggio
news:11**********************@c13g2000cwb.googlegr oups.com
How to Deploy SQL server Database to another PC, How to create a
package that craetes Database as well as ODBC driver for accessing
data at enduser PC, using .Net VB


John already answered you about drivers...
as regard database installation, personally I do not like backup/restore
practice, nor detach/attach...
and Ialways go for executing the DDL scripts to recreate the dbs and related
objects as long as performing BCP in and/or INSERT INTO scripts in order to
populate pre-loaded tables...
the best "universal" approach I've seen so far explained in a public article
is
http://msdn.microsoft.com/sql/archiv...r/default.aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Jul 23 '05 #2
To add on to Andrea's response, we keep all of our DDL scripts under source
control and run these scripts during installation with a .Net custom action.

Depending on your requirements, you can include the scripts in a .Net
project as either content files or as embedded resources. You can then
include that project in your Setup and Deployment project. Your custom
action can read and execute the scripts from either the resource assembly or
from the file system.

--
Hope this helps.

Dan Guzman
SQL Server MVP

<hi********@gmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
How to Deploy SQL server Database to another PC, How to create a
package that craetes Database as well as ODBC driver for accessing data
at enduser PC, using .Net VB

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Wilson Ricardo Passos Oliveira | last post: by
reply views Thread by Danny J. Lesandrini | last post: by
reply views Thread by Markus Stehle | last post: by
4 posts views Thread by bob lambert | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.