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.

What are the diifferences between the ms sql server vs mysql?

1123

---

What are binary string data types in ms sql server?

1176

---

What is the xml datatype?

993

---

How do I run sql server 2014?

940

---

Difference between aggregate functions of sql?

1042

---

What is a linked server in sql server?

1017

---

What stored by the msdb? : sql server database administration

954

---

Why truncate is ddl command?

995

---

What is entity data services?

1005

---

Can one drop a column from a table?

968

---

Explain atomicity?

974

---

What are views used for?

969

---

What is coalesce and check constraint in sql server?

1046

---

How to create user defined functions with parameters?

1166

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

181

---