hi all,
i am develpoing an application, and using SQL 2000. i have some of the client. and my devloping as well as the database modifiction is under construction... and now i want to copy the newly added feature such as new table, view as well as some new columns of existing table.. etc.. to Client server..
is there any easier way to copy structure to client side without affecting its data.
Tejas Kishanwala
Easier way ? the answer is NO.......... In such scenario , if u have a systamatic method then it is very easier to handle multiple development server. Before applying any change to master Developemnt server u create a script for the particular modification and apply that in master and distribute the script to others also. Otherwise there are third party tool available for it. u can try that.
Madhu
|||Hi,thanx for reply.
pls. give me the name of some of the third party tool............
Tejas|||
check this site: http://www.red-gate.com/
also google for free sql tools
Madhu
|||
Be aware that also the visual Studio for Database professional has a funcationality to do this. You can compare two database for schema or data differences and create alter / update scripts to change the target database and to keep them in sync. As the tool is integrated within visual Studio and it has some other interesting features for development I would suggest you to check this out.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment