Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can you please anybody one explain? Expand / Collapse
Author
Message
Posted Thursday, September 19, 2013 11:45 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 7, 2013 1:56 AM
Points: 15, Visits: 36
How to do database migration in Sql server?

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


Please help me

Thanks in advance
Post #1496713
Posted Friday, September 20, 2013 5:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:26 AM
Points: 2,840, Visits: 3,963
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
Post #1496810
Posted Friday, September 20, 2013 8:37 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 4:26 PM
Points: 3,535, Visits: 7,620
Let's make his life easier with this link.


Luis C.
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?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1496916
Posted Friday, September 20, 2013 1:15 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, September 29, 2013 1:24 AM
Points: 429, Visits: 1,721
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.


Post #1497012
Posted Monday, September 23, 2013 11:25 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 3,627, Visits: 5,269
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!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1497652
Posted Tuesday, September 24, 2013 8:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,296, Visits: 12,147
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1497883
Posted Tuesday, September 24, 2013 6:11 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 3,627, Visits: 5,269
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!

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?
Since random numbers are too important to be left to chance, let's generate some!
Learn to understand recursive CTEs by example.
Splitting strings based on patterns can be fast!
Post #1498091
Posted Wednesday, September 25, 2013 8:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,296, Visits: 12,147
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.


You are quite welcome. You even have the option of having it script your data if you want too.


_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1498379
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse