May 4, 2012 at 3:15 am
How could i take a store-procedure backup in sql sever 2008 without taking a script backup.
Actually i need to restore one database from 2008 backup into 2005.
we can export all tables but there are total 700 store-procedure it will consume a major time... to modify each an execute.
Please help me if anybody knows shortcut of this.
Thanks & Regards,
Pallavi
May 4, 2012 at 3:25 am
you could use powershell and script out all the objects you require into one big script and run it on 2005, you could also script the entire database from 2008 using the generate scripts task in SSMS which will save to one big file for you to run it in.
May 4, 2012 at 3:46 am
anthony.green (5/4/2012)
you could use powershell and script out all the objects you require into one big script and run it on 2005, you could also script the entire database from 2008 using the generate scripts task in SSMS which will save to one big file for you to run it in.
You could..... The only time I'd do this is if it needed to be automated.
anthony.green (5/4/2012)
you could also script the entire database from 2008 using the generate scripts task in SSMS which will save to one big file for you to run it in.
A much better solution for an adhoc request. Right click the database, Tasks, Generate scripts. Simple
May 4, 2012 at 5:15 am
A backup is a bit-by-bit copy at the page level of the database. No way to single out objects from it, at all. You have to script this.
700 stored procedures is a small number to script out. The methods offered above should take about 3-5 minutes.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply