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 |
|
Madhavi25
Starting Member
2 Posts |
 Posted - 2007-08-06 : 10:45:57
|
| Do we have any way to update the stored procedures to read the data from tables in production server and to update the tables in Test server?Thanks |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-06 : 11:19:12
|
| no not really.you have to create linked servers between the two and manually change stored procedures._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Madhavi25
Starting Member
2 Posts |
Posted - 2007-08-06 : 15:58:51
|
| Thanks for the quick reply.Is creating linked servers a tedious job? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-06 : 16:08:33
|
| You could use transactional or snapshot replication for this, but that seems like overkill for a test environment.I'd suggest just doing backup/restore instead to copy a production database to test environment.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Read from one server and write to another server