Article/tutorial needed regarding deployment with mdf

[Paul Hemans]

Hi,
VS2005 running with SQL Server Express. My app needs a simple table, if I
include the mdf with the deployment, then the database will be overwritten
with updates (losing the site data). So does anyone know of a good
article/tutorial describing how to deploy a simple table via scripts
particularly in regards to what happens when you bring out a new release?

Thanks.

[Andrea Montanari]

hi Paul,

Post by Paul Hemans
Hi,
VS2005 running with SQL Server Express. My app needs a simple table,
if I include the mdf with the deployment, then the database will be
overwritten with updates (losing the site data). So does anyone know
of a good article/tutorial describing how to deploy a simple table
via scripts particularly in regards to what happens when you bring
out a new release?
Thanks.

please have a look at
http://msdn2.microsoft.com/en-us/magazine/cc163919.aspx ..

[Paul Hemans]

Yes, that looks the goods
Thanks

Post by Andrea Montanari
hi Paul,

Post by Paul Hemans
Hi,
VS2005 running with SQL Server Express. My app needs a simple table,
if I include the mdf with the deployment, then the database will be
overwritten with updates (losing the site data). So does anyone know
of a good article/tutorial describing how to deploy a simple table
via scripts particularly in regards to what happens when you bring
out a new release?
Thanks.

please have a look at
http://msdn2.microsoft.com/en-us/magazine/cc163919.aspx ..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply