Groups | Blog | Home
all groups > sql server msde > january 2006 >

sql server msde : Populating Tables on install


Chris
1/24/2006 12:00:00 AM
Hello all, I am going to run a script to install my tables onto my SQL
server. I would like to populate some of the tables with values when the
script is run (dropdown tables, default values table etc).

How should I do this?

Andrea Montanari
1/24/2006 12:00:00 AM
hi Chris,
[quoted text, click to view]

personally I use a path similar to
http://msdn.microsoft.com/msdnmag/issues/04/09/customdatabaseinstaller/,
that's the best article on database "publication" I'm aware of, supporting
source control integration as well...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

AddThis Social Bookmark Button