469,307 Members | 2,083 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

deploy the updated database

Hello every one,
Thank you very much for your help,
I program my websit in VWD 2008 and SQL Server2005 and I want to know how to deploy the database to the server if I change my database tables after the first deployment and to know if I lost the old data in it and how can I avoid that?

Aug 10 '10 #1
1 1047
Jerry Winston
145 Expert 100+
Where is your database currently deployed? location, format, and size will play a key role in formulating my deployment suggestion.

How does your application connect to the database currently? Windows or SQL authentication?

How many logins are associated with the current database?

To deploy a database from development into production is one thing. To improve that database and redeploy is another. This is the number one fear of customers in the post delivery maintenance phase of application development, whether or not their old data will be compatible with the new version. While it may be easier for you, the developer, to simply introduce a new 'clean' version unencombered by antiquated code or table design, I feel the developer has a responsibility to clients that entrusted their data to your data system to create an upgrade/import/conversion process to bring as much old data forward to the new version as possible. Beyond the personal ecconomic benefits of not alienating your clientbase with every new version, future developers will benefit from users with good technology experiences.
Aug 10 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by dave | last post: by
9 posts views Thread by jensendarren | last post: by
5 posts views Thread by Johnny Jörgensen | last post: by
1 post views Thread by kitemad69 | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.