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 |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2012-10-25 : 16:59:45
|
| I have about 100 reports that I need to rewrite to point to a new database with a slightly different schema. It'd be nice if I could create new data sets that point to the new data source and then disable them until I'm ready to deploy the modified reports, but I don't see a way to do that. Is copying the solution and doing all the modifications in the copy the best way? The problem with that is that changes could be made to the old solution and not the new one during the transition. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 17:09:09
|
| do you means your used tables and their structure will also change?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2012-10-25 : 17:17:28
|
| Slightly yes. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-25 : 17:27:36
|
| then effectively you've to write new queries for all reports isnt it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2012-10-25 : 17:48:01
|
| Yes, sorry that wasn't clear. |
|
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2012-10-25 : 19:17:24
|
| I'm just gonna make copies of all the reports and modify the copies, then delete the old ones and rename the copies, then deploy the new ones. |
|
|
|
|
|
|
best way to modify all reports