Distributing Data of MSDE-Apps

Hi there,
I wonder, how to distribute an MSDE-Application with some
default database and data in it.
E.g. i need to ship my app with the database that contains
some tables and some tables may contain initial data.
How can I do that ?
hi Roger,
"Roger" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:744001c494d4$1eb766d0$a501280a@.phx.gbl...
> Hi there,
> I wonder, how to distribute an MSDE-Application with some
> default database and data in it.
> E.g. i need to ship my app with the database that contains
> some tables and some tables may contain initial data.
> How can I do that ?
Microsoft provides a deployment toolkit, in release candidate at the current
time, you can dowload from
http://www.microsoft.com/downloads/d...displaylang=en
I did not installed it, but I think some database deployment feature are
present... and some drawbacks of this toolkit have been posted here... don't
know the current state and/or the final release...
personally I do deploy apps with a companion tool which will read and
execute DDL scripts as long as INSERT INTO scipts, BCP and so on.. other
ways are backup/restore and sp_attach_db
I already disccused these 3 methods in http://tinyurl.com/6ux7p and
http://tinyurl.com/4x8pv ...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://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