Can you please anybody one explain?

Question

Post reply

Can you please anybody one explain?

techmarimuthu

SSC Enthusiast

Points: 137
More actions
September 19, 2013 at 11:45 pm

#148308

How to do database migration in Sql server?
i need basic and step by step instruction.....
Please help me
Thanks in advance

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 1

Google https://www.google.co.in/?gws_rd=cr&ei=1C48UtDrAs7KrAfnyoDwAQ#q=database+migration+in+Sql+server

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

Let's make his life easier with this link.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Steven Willis SSCrazy Eights Points: 9893 More actions · Answer 3

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.

Dwain Camps SSC Guru Points: 86948 More actions · Answer 4

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.

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

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.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Dwain Camps SSC Guru Points: 86948 More actions · Answer 6

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.