reporting services - How to migrate reports (RDL files) from SQL Server 2008 R2 to 2012? -

-


reporting services - How to migrate reports (RDL files) from SQL Server 2008 R2 to 2012? -

we have sql server 2008 r2 server reporting services more 200 reports.

for migration purpose have installed sql server 2012 reporting services on new server. have published same rdl reports new server , have terrible performance results. reports working takes 10times longer sql server 2008 r2.

we think these performance troubles can caused fact rdl files 2008 r2 based.

how can migrate these reports sql server 2012 ? and/or how can troubleshoot these performance problems ?

[update] after investigations, i've found performance problem not related reports. reports generated asp.net application phone call render2 method of reportexecution2005.asmx web service. if phone call method production front end web server phone call takes more 1 minute, if phone call exact same method same web service hosted on same reporting services dev machine, phone call takes few seconds. that's very, very, weird.

any ideas behavior ?

regards,

from: https://msdn.microsoft.com/en-us/library/ms143674(v=sql.110).aspx

reports not upgraded when upload study definition file straight study server or sharepoint site. upgrading study definition in sql server info tools way upgrade .rdl file.

in order upgrade them, need to:

report definition (.rdl) files automatically upgraded in next ways:

when open study in study designer in sql server info tools (ssdt), study definition upgraded supported rdl schema. when specify sql server 2008 or sql server 2008 r2 study server in project properties, study definition saved in schema compatible target server.

when upgrade reporting services installation sql server 2012 reporting services (ssrs) installation, existing reports , snapshots have been published study server compiled , automatically upgraded new schema first time processed. if study cannot automatically upgraded, study processed using backward-compatibility mode. study definition remains in original schema.

sql-server reporting-services sql-server-2008-r2 sql-server-2012

Comments

Post a Comment

Popular posts from this blog

java - How to set log4j.defaultInitOverride property to false in jboss server 6 -

-
java - How to set log4j.defaultInitOverride property to false in jboss server 6 - how set log4j property false in jboss. not using log4j in application still property has set true. the reason, why trying set property false is, suspecting property overrides java.util.logging.logger configuration provided application. might because of this, log file not getting generated. boot.log infomation below: 02:46:10,495 debug [serverinfo] log4j.defaultinitoverride: true 02:46:10,496 debug [serverinfo] org.jboss.deployers.spi.deployer.matchers.nameignoremechanism: org.jboss.deployers.spi.deployer.helpers.dummynameignoremechanism 02:46:10,496 debug [serverinfo] org.jboss.logging.logger.pluginclass: org.jboss.logging.logmanager.loggerpluginimpl i have found in boot.log in jboss. in 1 of blog, developers told me that, log4j.defaultinitoverride property should set false avoid override of java.util.logging.logger. comment same if wrong. java logging jboss log4j
Read more

c - GStreamer 1.0 1.4.5 RTSP Example Server sends 503 Service unavailable -

-
c - GStreamer 1.0 1.4.5 RTSP Example Server sends 503 Service unavailable - i'm trying create rtsp server based on gstreamer 1.0 1.4.5 plugin. source code of illustration taken here. with_tls , with_auth flags not enabled. i'm compiling using visual studio 2013 community edition. project building , running successfully. when i'm trying play video using vlc on address rtsp://127.0.0.1:8554/test says can't open mrl. recorded traffic (using rawcap) of communication between compiled server , vlc player following: request: options rtsp://127.0.0.1:8554/test rtsp/1.0 cseq: 2 user-agent: libvlc/2.2.0 (live555 streaming media v2014.07.25) response: rtsp/1.0 200 ok cseq: 2 public: options, describe, get_parameter, pause, play, setup, set_parameter, teardown server: gstreamer rtsp server date: thu, 09 apr 2015 03:35:30 gmt request: describe rtsp://127.0.0.1:8554/test rtsp/1.0 cseq: 3 user-agent: libvlc/2.2.0 (live555 streaming media v2014.07.25) accept: applicat...
Read more

Using ajax with sonata admin list view pagination -

-
Using ajax with sonata admin list view pagination - i'm using sonata admin in project. in list view sonata refresh page when clik sec list pagination. that's default behavior of sonata.is there way utilize ajax phone call list view pagination !!! same question when using sortable list view. thanks. this possible, have overwrite of basic functionality of sonata admin bundle. tested symfony 2.6.6 sonata admin-bundle dev-master (4f23e1a30e49681bf8ebdbbae549848784be7699) 1. edit bundles services.yml you have implement own crudcontroller , new list template. tell in services.yml sonata.admin.youradmin: class: your\bundle\admin\youradmin tags: - { name: sonata.admin, manager_type: orm, group: "groupname", label: "grouplabel" } arguments: - ~ - your\bundle\entity\entityclass - yourbundle:yournewcrud # <- add together crud class here calls: ...
Read more