472,101 Members | 1,429 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,101 software developers and data experts.

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 1077
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.