ms sql merging RSS

• • Reply
  

  inbaa

  Member

  341 Points

  304 Posts

  ms sql merging

  May 17, 2012 09:17 AM|LINK

  Dear friends ,

  I have a database projects..udder folder separated  for tables,SP,Views and function ..each table and sp stored as single sql file .. i want to merge all files ..if any possible

  • Moved by bbcompent1 on May 17, 2012 12:36 PM
• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: ms sql merging

  May 18, 2012 06:39 AM|LINK

  inbaa

  Dear friends ,

  I have a database projects..udder folder separated  for tables,SP,Views and function ..each table and sp stored as single sql file .. i want to merge all files ..if any possible

  Are you talking about SQL Server Database folder? IF Yes, than you can use below step to get all script data

  • Right Click Database - Tasks - Generate Scripts
  Yogesh Bhadauriya
  .Net All About
  
  • Marked as answer by Chen Yu - MSFT on May 30, 2012 10:27 AM
• • Reply
  

  Chen Yu - MS...

  All-Star

  21829 Points

  2513 Posts

  Microsoft

  Re: ms sql merging

  May 21, 2012 10:25 AM|LINK

  Hi inbaa,

  If all files in the same database, you could backup that database and retore it in the new instance.

  Backup database and Restore database: http://msdn.microsoft.com/en-us/library/ms187048

  Thanks.

  Please mark the replies as answers if they help or unmark if not.
  Feedback to us
  
  Develop and promote your apps in Windows Store
  
  
  • Marked as answer by Chen Yu - MSFT on May 30, 2012 10:27 AM