Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference beteen Migration and Upgrdation?
- 7 Answers
- 24981 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / phani kiran sai
Migration:
There are various situations for migration
1. LAUNCH, GO-LIVE, DEPLOYMENT.
A situation or a birth of PROJECT is known as LAUNCH,
GO-LIVE, DEPLOYMENT. Starts from Development -> Test ->
Production.
2. DB-REFRESH.
When we need to take back the server and its functionalities
from PRODUCTION SERVER to TEST SERVER and back again to
PRODUCTION SERVER is known as DB-REFRESH.
3. MOVING FROM OLD HARDWARE TO NEW HARDWARE.
Every hardware is subject to END OF LIFE. In such
situations, we would move the entire server from OLD
HARDWARE to NEW HARDWARE.
4. MOVING BETWEEN DIFFERENT DATA CENTERS.
5. CONSOLIDATION PROJECT.
CONSOLIDATION is a process of gathering all the NON-CRITICAL
databases over individual servers and managing them in a
single high scalable server.
FROM THE ABOVE SITUATION, WE CAN CLEARLY IDENTIFY THAT WE
ARE NOT EFFECTING THE VERSION OF THE SQL SERVER SOFTWARE.
Up-gradation:
UP-GRADATION is a process of INSTALLING a newer version on
the existing SQL SERVER SOFTWARE. [E.G HOTFIX, PATCH,
SERVICE PACKS, VERSION UPGRADE]
There are two types of UP-GRADATION
1. IN-PLACE UP-GRADATION
2. SIDE-BY-SIDE UP-GRADATION
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between control flow and data flow?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How to encrypt Strored Procedure in SQL SERVER?
What function does a database engine serve in the sql server?
What is transactional replication?
Explain nested join?
How to execute stored procedure and set temp table in sql server?
Define ACID properties in a Database?
Mention the different authentication modes in sql server.
Explain relational data?
You want to implement the one-to-many relationship while designing tables. How would you do it?
How to create a simple user defined function in ms sql server?
What are cursors stored procedures and triggers?
How can you know if the row fetched from cursor is still valid in underlying table?
