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 |
|
ozsql
Starting Member
14 Posts |
 Posted - 2009-09-20 : 21:10:51
|
| Hi Guys,I need to refresh SQL Database. We got three serversServer (A) ProductionServer (B) Replication of Production Server (C) DevelopmentI need to get the last data to develop few requirements. We need to refresh data on server (B) and then refresh on server (C). On both the servers do I need to right click on database and then click on refresh to refresh database or do I need to run any script? Please can anyone help me out with query, we are using SQL 2008.Can anyone please provide if any script available Thanks,D |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-21 : 03:51:27
|
| The Refresh simply refreshs your view/screen with the list of objects.To move data from production to test and dev, I would either- backup the production database. restore into test/dev. scramble the data in certain tables, if required. reset the logins. and re-release any changes to the database (floowing your change control process).- if its a small set of tables, tansfer the data using BCP/import wizard |
 |
|
|
|
|
|
Database Refresh