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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-02-04 : 08:23:33
|
| Praveen writes "In what way can I generate an SQL Script for any change in the master data and / or change in the schema of the database.And how can this process be automated." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-04 : 15:02:24
|
| You can use replication for this. Please provide some more detail on what you need though so that we can suggest the appropriate replication type.Tara |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2005-02-08 : 21:02:30
|
| There are also some third party software packages that can compare schemas and data between two databases and produce and, optionally, execute the script that will update one based on the other.We are investigating the Red Gate SQL Bundle product now. It has some issues but it has made a lot of the mundane issues easier to facilitate.HTH=================================================================Egotism is the anesthetic that dulls the pain of stupidity. -Frank William Leahy, football coach (1908-1973) |
|
|
|
|
|
|
Data Synchronization