Development Server vs Production Server

[pinna_hari]

Hello, I have developed one web application in asp.net(in VSTS 2008) and moved to production server by taking backup of database and files, Later i have included lot of new modules and functionality in developement server. My question is how to move updated files (Modules with database) to production server, with out losing of existing data in production server. do we have any tools to update whenever we build in visual sutdio, or any specail process is there? Please help me, and let me know any vedios or articles available on this topic.

Pinna

[Adam R Harris]

Well as far as your Modules go, if you are just talking libraries (dlls), you should just be able to overwrite the existing Modules. For the DB, this is a little trickier if you know exactly what fields changed you should be able to just write an update statement for the tables that have changed. If you don't know what tables changed you can use a third party tool, something like APEX SqlDiff[^] to run the comparison and generated the scripts for you. It's a little pricey but I’m not sure what your budget is. If it's just a onetime thing, I think the trial might do.

If at first you don't succeed ... post it on The Code Project and Pray.

[Yusuf]

For MSSQL server there is a free toolSqlDbDiff[^] which does a decent job of comparing databases.

Yusuf May I help you?

[Adam R Harris]

Never heard of this one before, looks nice and you can't beat that price. Thanks for the info

If at first you don't succeed ... post it on The Code Project and Pray.

[pinna_hari]

Hi, Thanks for your reply. I am not talking about libraries(dlls), i am just saying about aspx files, and came to known we can move updated files from production server to development server using Team foundation server, but i dont know the process am looking for tutorials.

Pinna

[Adam R Harris]

Copy & Paste replacing the old ones with new ones, if you have customizations to the web.config don't overwrite that or you will have to make the changes again, by changes I mean values. obviously overwriting the web.config will remove all changes to the previous version

If at first you don't succeed ... post it on The Code Project and Pray.