What is difference beteen Migration and Upgrdation?
Answer Posted / thrilok
Migration is the process of taking the backup and restore into the target server (One or More).
Down time is not mandatory.
Man power is required.
Upgradation is the process of replacing the old version of sql server with the new version of sql server.
Down time is mandatory for upgradation.
Man power is not required.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are different types of replication in sql server?
What happens to a statement batch if there is a compilation error?
How to access the inserted record of an event?
Can you explain what are commit and rollback in sql?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
How to create stored procedures with parameters in ms sql server?
What are the restraints imposed on the table design by a merge replication?
Explain linked server in sql?
Explain tablesample?
What are the different authentication modes in sql server?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
please differentiate between delete and truncate?
Explain “@@rowcount” and “@@error” in sql server?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is the syntax for encrypting a column in SQL Server?