Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2008-08-13 : 20:22:48
|
| I have working reports on a PC running SQLExpress. I then setup another PC and manually port the reports from one PC to the other by coping the blah.rdl file onto a flash drive (second PC not on a network)and use upload from Report Manager. For reports that do not use stored procedures this procedure works fine. However stored procedures are of course not included so the reports that use them when run give an error indicating the stored procedure cannot be found. So.. my question is how is the easiest way to also port the stored procs ideally using Report Manager?I should also mention that in the final product we plan to use rsutility to configure the server and deploy the reports. I have not looked into this yet however I hope rsutility can deploy the blah.rdl files and stored procs? Any examples? Thanks |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-13 : 21:55:31
|
| In SQL Server Management Studio (SSMS), right-mouse click on the database, select "tasks -> Generate Scripts" & work thru the wizard according to what you want. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-13 : 23:34:02
|
| And you can apply the script to any server. |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2008-08-14 : 02:52:47
|
| Thanks for your response. That resolved my problem or should I say lack of understanding. So the solution I went with was:Create a script using the wizard as explained above by dexter.knudson selecting only the stored procedures.Then run the folowing from command line to install on the new server, just change server_name, instance_name, db_name and myscript.sql to your names.sqlcmd -E -S server_name\instance_name -d db_name -i myscript.sql |
|
|
|
|
|
|
Porting stored procedures between servers