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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Database Deployment

Author  Topic 

ecjmt
Starting Member

1 Post

Posted - 2005-11-07 : 06:39:46
We have a client with our data base, but this database is undergoing constant changes since the development has not been finished, for that reason whenever we made an update we must synchronize the data base. I wondering if exists a tool in which setup can be created and updates the data base in SQL.

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-11-07 : 06:42:33
There is a tool from Red-Gate (SQL Compare )which will find the difference between database..
www.red-gate.com

Complicated things can be done by simple thinking
Go to Top of Page

Antonio
Posting Yak Master

168 Posts

Posted - 2005-11-07 : 07:11:06
quote:
Originally posted by chiragkhabaria

There is a tool from Red-Gate (SQL Compare )which will find the difference between database..
www.red-gate.com

Complicated things can be done by simple thinking



Hi chiragkhabaria, I would like to discuss something (related to SQL work) in private. Do you have MSN or an email address?
Go to Top of Page

chiragkhabaria
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2005-11-07 : 07:13:45
well.. you can email me @ chirag@civilsoft.net

Complicated things can be done by simple thinking
Go to Top of Page

Antonio
Posting Yak Master

168 Posts

Posted - 2005-11-07 : 07:21:22
quote:
Originally posted by chiragkhabaria

well.. you can email me @ chirag@civilsoft.net

Complicated things can be done by simple thinking



Thanks, I have just emailed you
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-11-07 : 13:15:39
We "script" all changes to our DEV database, we can then just run the scripts, in order, on QA, STAGING and PRODUCTION when we want to bring them up to the current "version".

Much easier to adopt that habit than try to script differences between databases as a means of rolling out changes.

Kristen
Go to Top of Page
   

- Advertisement -