• 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.


    My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]

    My thought question: Have you ever been told that your query runs too fast?

    My advice:
    INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
    The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

    Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
    Since random numbers are too important to be left to chance, let's generate some![/url]
    Learn to understand recursive CTEs by example.[/url]
    [url url=http://www.sqlservercentral.com/articles/St