Updates between development and product databases 
Author Message
 Updates between development and product databases

I'm working on three databases, that are essentially copies of each other.
One is for running automated tests against, one is for developers to do
their work with, and one is the live, production database.

What is the best way to migrate schema changes among these databases? For
example, if I add a column to a table in the test database, I want that
change to be replicated in the other two.

I'm unsure whether I should try replication, DTS, or simply capturing schema
changes in scripts, which I manually run against each of the other two
databases.

Any suggestions?



Fri, 04 Apr 2003 03:00:00 GMT
 Updates between development and product databases

Replication can not do this.  I advise against a DCTS package.  The way I do
it is to generate a delta script and manually apply it.  (Yes, I am managing
many more server than 3 in doing this and it does take time and effort.)

--
Please post all replies to the newsgroup unless otherwise stated.

SQL Server MVP
SQL Server Resources: http://www.mssqlserver.com
Replication Primer: http://www.mssqlserver.com/replication
SQL Server FAQ: http://www.mssqlserver.com/faq
SQL Server 2000 info: http://www.mssqlserver.com/articles



Sat, 05 Apr 2003 03:00:00 GMT
 Updates between development and product databases
Thanks for your reply, Michael. It's a pity there isn't an automated way to
do this, but I'm glad to have the wisdom of someone more experienced than
me.


Quote:

> Replication can not do this.  I advise against a DCTS package.  The way I
do
> it is to generate a delta script and manually apply it.  (Yes, I am
managing
> many more server than 3 in doing this and it does take time and effort.)

> --
> Please post all replies to the newsgroup unless otherwise stated.

> SQL Server MVP
> SQL Server Resources: http://www.mssqlserver.com
> Replication Primer: http://www.mssqlserver.com/replication
> SQL Server FAQ: http://www.mssqlserver.com/faq
> SQL Server 2000 info: http://www.mssqlserver.com/articles



Sun, 06 Apr 2003 03:00:00 GMT
 Updates between development and product databases

You can use SQL Compare www.red-gate.com

Adam
* Keep up-to-date by attending the monthly meetings at the 'Access/ASP/SQL
Server User Group, Sydney"   www.ssw.com.au/AccessUG
--------------------------------------------------------
Check out these HOT UTILITIES FOR ACCESS AND VB DEVELOPERS....
www.ssw.com.au
* SSW Data PRO  - Version Control for your data.mdb
* SSW Data Renovator  - Compare the differences between two data.mdb's
* SSW Upsize PRO! - Don't UPSIZE to SQL Server without it
--------------------------------------------------------


Quote:
> I'm working on three databases, that are essentially copies of each other.
> One is for running automated tests against, one is for developers to do
> their work with, and one is the live, production database.

> What is the best way to migrate schema changes among these databases? For
> example, if I add a column to a table in the test database, I want that
> change to be replicated in the other two.

> I'm unsure whether I should try replication, DTS, or simply capturing
schema
> changes in scripts, which I manually run against each of the other two
> databases.

> Any suggestions?



Sat, 12 Apr 2003 12:19:30 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. CA-San Jose-267399--Product Development-ORACLE-Product Development Manager @ eBay

2. Updating a production database from a development db?

3. NY-New York-93751--C-C++-SQL-UNIX-Windows Development-Product Developer

4. Louisiana - SAP, Oracle, PeopleSoft, Baan - Product Development Consultant

5. Product development ideas sought

6. New Product Development

7. Product Development Ideas sought !!!

8. Product Development Project

9. AZ-Tempe-239608--Product Development-Java-Client/Server-ORACLE-SUN-UNIX-Windows

10. NY-New York-93751--C-C++-SQL-UNIX-Windows Development-Product Developer

11. Product Development-Fortune 500 Co No.Va

12. Product development ideas sought


 
Powered by phpBB® Forum Software