I have a website on a server with a database in MSSQL 2005 behind, I wish to make changes in a local copy in of the databases in my computer and be able to connect to the database used by the website in the server and make the changes to there also (I guess something like the ftp programs where you can get/ put files only that I want this for tables). As I lewarned this is called database synchronization. Has anyone done it, and if so can give me some guidence, I haven't done anything like that before so I am quite cluless, can this be done alone with the SQL server 2005 ? or I need some tool (if so do you know any free one?)
Many thanks🙂
