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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2010-10-20 : 04:00:57
|
| what is the way to work with two enviroments? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-10-20 : 04:04:55
|
That's a very wide question.Could you be more specific?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2010-10-20 : 05:28:14
|
| what is the best way to update the production(sechema,data ect) |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2010-10-22 : 09:59:40
|
quote:
Originally posted by inbs
what is the best way to update the production(sechema,data ect)
We use Tool Red Gate SQL compare and Data compare. It produces a script to tell you what you would apply on Prod to make it equivalent to Dev.In the meantime you can do Tasks->Generate Scripts... and compare these outputs in MS Word or some text compare tool. |
|
|
|
learnit
Starting Member
6 Posts |
Posted - 2010-10-23 : 04:33:17
|
| Update production - do you mean that dbs running are updated with data from development?Production Environment is accessed by business and do get updated by business users. Development Enviroments is manipulated by developers and application dba's.Most of the cases development is refreshed with the data (by taking the backup) from production and the way gets updated. This depends on your production and development environments if are similar. |
|
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2010-10-25 : 08:47:57
|
quote:
Originally posted by learnit
Update production - do you mean that dbs running are updated with data from development?Production Environment is accessed by business and do get updated by business users. Development Enviroments is manipulated by developers and application dba's.Most of the cases development is refreshed with the data (by taking the backup) from production and the way gets updated. This depends on your production and development environments if are similar.
Just a guess, since the original poster hasn't said a whole lot. But if the system is Data Driven, you may need to send data from Dev to Prod. Such as if you have a table that determines which text boxes are visible. In that case, we use Red Gate Data compare. |
|
|
|
|
|
|
DEVELOPMENT- PRODUCTION