Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tanai
Starting Member
2 Posts |
 Posted - 2008-04-16 : 23:44:07
|
| Please can somebody help me with the following:Our company has an enterprize site (a very large one). From time to time we need to make changes in it. In other words, we had to synchronize one database (local where we make all changes) and database on hosting. So, we did it manually (wrote scripts and inserted them in database on hosting). But as the databases grew it became impossible to synchronize everything manually. So we need some tool which could cope with this task. The problem is that, as I know, there are many tools which can do it, but we are tight in time and can't evaluate them all. Please share your ideas on what tool is worth evaluating? Thanks in advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-17 : 13:00:17
|
| Why aren't you scripting your changes as you do the work locally? I like Red Gate's SQL Compare utility, but I only use it in environments where I don't have a handle on what's been changed.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Tanai
Starting Member
2 Posts |
Posted - 2008-04-21 : 03:30:44
|
| It is possible to manually write script on site db change, but our site consists of more than 250 tables. And to write scropts manually is a terrific work, especially if we don't want any errors. We wanted to change db without saving and scripting changes.Yes, Red Gate is a really good program, but it costs a lot (unfortunately we can't afford it)and the possibility of integration of such program would be great. |
|
|
|
|
|
|
SQL database synchronization