dwain.c (9/24/2013)

---

Sean Lange (9/24/2013)

---

dwain.c (9/23/2013)

---

Steven Willis (9/20/2013)

---

techmarimuthu (9/19/2013)

---

How to do database migration in Sql server?

i need basic and step by step instruction.....

Please help me

Thanks in advance

The easiest method is to use Generate Scripts under the database task menu. If the database is huge you'd want to generate a schema only copy first then import the data. Otherwise you can import the data and schema at the same time.

Don't forget that this approach won't copy TRIGGERs or INDEXs. At least it didn't the last time I tried.

That depends on your scripting options. On the "Set Scripting Options" step you can click on the advanced button. From there you have a lot of choices of what to script and what not to script.

It appears that I must not have seen the advance button. Thanks Sean.