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
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
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
yrb.yogi
Star
14460 Points
2402 Posts
Re: ms sql merging
May 18, 2012 06:39 AM|LINK
Are you talking about SQL Server Database folder? IF Yes, than you can use below step to get all script data
.Net All About
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.
Feedback to us
Develop and promote your apps in Windows Store