| Author |
Topic |
|
Dev@nlkss
134 Posts |
 Posted - 2009-02-05 : 04:44:45
|
| Hi All,I have two databases one for development and one for testing.What i want to do is whenever a new database object(table,stored procedure etc...) is created in Development DB that should be replicated into Testing DB.Is it possible to do.If so can we automate it.Or is there any free or less cost tools.Thanks for any help. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-05 : 05:04:47
|
You can use transactional replication.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-05 : 08:49:10
|
quote:
Originally posted by Peso
You can use transactional replication.
E 12°55'05.63"N 56°04'39.26"
Peso,It doesn't replicate newly created objects unless new articles are added in publisher and snapshot agent is started everytime. |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2009-02-05 : 23:08:43
|
| Hi all,bit confused, can u tell me some more detail,am new to these concepts.or any links for this.Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 09:51:35
|
quote:
Originally posted by satya@imi
Hi All,I have two databases one for development and one for testing.What i want to do is whenever a new database object(table,stored procedure etc...) is created in Development DB that should be replicated into Testing DB.Is it possible to do.If so can we automate it.Or is there any free or less cost tools.Thanks for any help.Satya
isnt it just a matter of backup development db and restoring to test periodically? Please keep in mind that this will cause data in testdb to be consistent with dev db data |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2009-02-13 : 09:05:04
|
| I have implimented Replication in all the ways.but i am able to control only those objects which are at point of creating replication.How can i add newly creating objects into my existing Replication architecture.Is it possible.Or any other ways to do this.Its urgent.Thanks for any help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 09:16:00
|
quote:
Originally posted by satya@imi
I have implimented Replication in all the ways.but i am able to control only those objects which are at point of creating replication.How can i add newly creating objects into my existing Replication architecture.Is it possible.Or any other ways to do this.Its urgent.Thanks for any help.Satya
yup..its possible. you need to add them to existing publicationhttp://msdn.microsoft.com/en-us/library/ms152493.aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-13 : 09:48:56
|
quote:
Originally posted by satya@imi
I have implimented Replication in all the ways.but i am able to control only those objects which are at point of creating replication.How can i add newly creating objects into my existing Replication architecture.Is it possible.Or any other ways to do this.Its urgent.Thanks for any help.Satya
Add articles in the publisher and start snapshot agent. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-13 : 09:55:40
|
| you probably need to add more clarity to your topic headings. All of your posts are having same heading.it will help people to give you quicker solutions |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2009-02-14 : 00:00:20
|
| thanks.ya sure i will make as topic wise. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-14 : 02:01:04
|
| cheers! |
|
|
|
learntsql
524 Posts |
Posted - 2009-10-23 : 04:53:31
|
[quote]Originally posted by Dev@nlkss
Hi all,bit confused, can u tell me some more detail,am new to these concepts.or any links for this.Thanks. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-23 : 13:02:40
|
quote:
Originally posted by learntsql
[quote]Originally posted by Dev@nlkss
Hi all,bit confused, can u tell me some more detail,am new to these concepts.or any links for this.Thanks.
what concept are you looking for? |
|
|
|
|
SQL Server