April 17, 2016 at 10:39 am
Hi Can any one help me on what is Refresh for Sql server
Difference between migration and refresh and when and why we use Refresh?????
on which project project it will related to mean to say OLTP or OLAP.
Please help me on this
April 17, 2016 at 8:30 pm
Database refresh usually means copying production data to development, stage, test etc, so those environments have "fresh" data.
Migration can mean to copy entire database or groups of databases from 1 environment to another.
Every company and subset of departments will have their own definition to suit their business needs.
April 17, 2016 at 10:58 pm
Database migration:
Moving a database from one server to another.
Database Refresh:
Overwrite the existing data in the database with other database data using backup files.
April 18, 2016 at 12:18 am
Hi Homebrew01, johnwalker10
Thankyou for your help and have little bit confusion around Refresh means Refresh will done with in single instance with multiple databases?
April 18, 2016 at 5:14 am
naveen.neerukattu1228 (4/18/2016)
Hi Homebrew01, johnwalker10Thankyou for your help and have little bit confusion around Refresh means Refresh will done with in single instance with multiple databases?
It completely depends on what's needed for the refresh. If there are two development teams working on two different databases on the instance and one development team requests are refresh of their database, you wouldn't automatically refresh the other database too. However, change the scenario so that both databases are dependent on one another and then, yeah, you'll have to coordinate the refresh between the two development teams.
Don't get hung on the term "refresh". It's not a precise and universal concept across all IT teams on earth. It can mean different things in different situations and there can be different ways to resolve it. I do think by and large it's a term applied to non-production environments where we're talking about getting a new or clean set of production or production-like data. However, it might mean other things to other people.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 18, 2016 at 8:07 am
naveen.neerukattu1228 (4/18/2016)
Hi Homebrew01, johnwalker10Thankyou for your help and have little bit confusion around Refresh means Refresh will done with in single instance with multiple databases?
Every company will make their own definition of "refresh" to meet their needs.
It could mean 5 tables from a database, an entire database, multiple databases, combined data from several databases, summary data etc ...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply