I need to copy both schema and data from a remote db server at my ISP.
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.The import/export wizard in 2005 doesn't expose the SQL Server specific ("script all objects and
then transfer the data). You find this in Integration Services, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hnteknik" <Henrik.F.A.Nielsen@.gmail.com> wrote in message
news:1166181741.158144.213330@.n67g2000cwd.googlegroups.com...
>I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard
Showing posts with label solution. Show all posts
Showing posts with label solution. Show all posts
Sunday, March 25, 2012
Deployment/copy of Db from remote server
I need to copy both schema and data from a remote db server at my ISP.
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.
Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(
|||Hi
Even if you can't restore the backup, I would expect your ISP to do it for
you.
John
"hnteknik" wrote:
> I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>
|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.
Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(
|||Hi
Even if you can't restore the backup, I would expect your ISP to do it for
you.
John
"hnteknik" wrote:
> I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>
|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard
Deployment/copy of Db from remote server
I need to copy both schema and data from a remote db server at my ISP.
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.The import/export wizard in 2005 doesn't expose the SQL Server specific ("sc
ript all objects and
then transfer the data). You find this in Integration Services, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hnteknik" <Henrik.F.A.Nielsen@.gmail.com> wrote in message
news:1166181741.158144.213330@.n67g2000cwd.googlegroups.com...
>I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("
script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(|||Hi
Even if you can't restore the backup, I would expect your ISP to do it for
you.
John
"hnteknik" wrote:
> I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wik...0Wizar
d
I used to use a Red Gate solution but dont have access to the proggie
anymore.
I then tried to use the import/export tool for the SQL 2005 server, but
view turned into tables and primary keys autoinc were not included.
What should I have done in order to get at complete copy. I cannot use
the backup function at the ISPs SQL server.The import/export wizard in 2005 doesn't expose the SQL Server specific ("sc
ript all objects and
then transfer the data). You find this in Integration Services, though.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"hnteknik" <Henrik.F.A.Nielsen@.gmail.com> wrote in message
news:1166181741.158144.213330@.n67g2000cwd.googlegroups.com...
>I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Tibor Karaszi skrev:
> The import/export wizard in 2005 doesn't expose the SQL Server specific ("
script all objects and
> then transfer the data). You find this in Integration Services, though.
>
Thanks - I will give it a try.
Found out later that :
'The SQL Server Import and Export Wizard provides minimal
transformation capabilities. Except for setting the name, the data
type, and the data type properties of columns in new destination tables
and files, the SQL Server Import and Export Wizard supports no
column-level transformations.' :-(|||Hi
Even if you can't restore the backup, I would expect your ISP to do it for
you.
John
"hnteknik" wrote:
> I need to copy both schema and data from a remote db server at my ISP.
> I used to use a Red Gate solution but dont have access to the proggie
> anymore.
> I then tried to use the import/export tool for the SQL 2005 server, but
> view turned into tables and primary keys autoinc were not included.
> What should I have done in order to get at complete copy. I cannot use
> the backup function at the ISPs SQL server.
>|||Hi John
I ran into this tool, which did the job of restoring my ISP DB as a
local DB on my server as it works both ways:
The Database Publishing Wizard enables the deployment of SQL Server
2005 databases (both schema and data) into a shared hosting environment
on either a SQL Server 2000 or 2005 server.
The tool supports two modes of deployment:
It generates a single SQL script file which can be used to recreate a
database when the only connectivity to a server is through a web-based
control panel with a script execution window.
It connects to a web service provided by your hoster and directly
creates objects on a specified hosted database
The Database Publishing Wizard provide both a graphical and a
command-line interface. In addition, it can integrate directly into
Visual Studio 2005 or Visual Web Developer 2005.
http://www.codeplex.com/sqlhost/Wik...0Wizar
d
Thursday, March 22, 2012
Deployment on Devices
I asked about this a few mos ago over in the CF forum, but I'm hoping there's a better solution someone (Erik?) knows about here.
Is there a "standard" deploy script for SQL Server CE on devices? There doesn't even seem to be one in the d/l from Microsoft. During development, Visual Studio handles the installation of SQL Server CE on the device but deploying it on a device that isn't partnered to a dev box seems to be a matter of "just copy the cab file over".
While I'm willing to do that if I have to, it raises some other questions. How do I know if it's already there? How do I know if what's there is a newer version or not (and if it is, how do I abort this step)? How do I make sure some other application hasn't installed it already? Do I really even need to worry this?
I can just have my installer tell ActiveSync to put it on the device, but without knowing the above I'm kind of nervous about it.It is probably a good idea to check the version installed. The most reliable way to do this is to check for the existance and file version information of the SQL CE dll files on the device. Assuming that your users have not installed to a storage card, this piece of code may be able to help you. I have used Opennetcf.org's SDF 2.1 for the fileversioninfo stuff:
Code Snippet
using System;
using System.Collections.Generic;
using System.Text;
namespace SQLVerCheck
{
public class SQLVerCheck
{
public static bool MustInstallCore(int requiredBuild)
{
bool mustInstall = false;
//Windows Mobile 6
if (System.Environment.OSVersion.Version.Major == 5 && System.Environment.OSVersion.Version.Minor > 1)
{
//SQL CE is installed in ROM in Windows Mobile 6
mustInstall = false;
}
else
{
//TODO get windir via PInvoke - see http://blogs.msdn.com/netcfteam/archive/2006/10/02/Platform-detection-III_3A00_-How-to-detect-a-touch-screen-on-Windows-CE-in-.NET-CF.aspx
if (System.IO.File.Exists(@."\windows\sqlceqp30.dll"))
{
OpenNETCF.Diagnostics.FileVersionInfo fi = OpenNETCF.Diagnostics.FileVersionInfo.GetVersionInfo(@."\windows\sqlceqp30.dll");
if (fi.FileBuildPart < requiredBuild)
{
mustInstall = true;
}
else if (fi.FileBuildPart >= requiredBuild)
{
mustInstall = false;
}
}
else
// Not trace, so we must install
{
mustInstall = true;
}
}
return mustInstall;
}
public static bool MustInstallReplication(string requiredBuild)
{
bool mustInstall = false;
//Windows Mobile 6
if (System.Environment.OSVersion.Version.Major == 5 && System.Environment.OSVersion.Version.Minor > 1)
{
//SQL CE is installed in ROM in Windows Mobile 6
mustInstall = false;
}
else
{
//TODO get windir via PInvoke - see http://blogs.msdn.com/netcfteam/archive/2006/10/02/Platform-detection-III_3A00_-How-to-detect-a-touch-screen-on-Windows-CE-in-.NET-CF.aspx
if (System.IO.File.Exists(@."\windows\sqlceoledb30.dll"))
{
OpenNETCF.Diagnostics.FileVersionInfo fi = OpenNETCF.Diagnostics.FileVersionInfo.GetVersionInfo(@."\windows\sqlceoledb30.dll");
if (fi.FileBuildPart < requiredBuild)
{
mustInstall = true;
}
else if (fi.FileBuildPart >= requiredBuild)
{
mustInstall = false;
}
}
else
// Not trace, so we must install
{
mustInstall = true;
}
}
return mustInstall;
}
}
}
Usage:
if (SQLVerCheck.MustInstallCore(5300))
{
// MessageBox.Show("Must install sqlce30.dev.ENU.ppc.wce4.armv4.cab");
Launch the install here!
}
|||Erik,
Thank you for the reply.
This helps with the version check once my app is deployed, but mostly I am concerned about installing it in the first place. Is there no "standard install" deployment script for getting SQL Server CE on the device? If I install it with my app, there is no "Remove Program" option on the desktop Control Panel specifically for it.
Also, since the code snippet would be run from the device, if SQLVerCheck() returns true, how would I launch the install of SQLServerCE from there?
Sorry, I'm pretty new at this. I appreciate the help. It's the difficult stuff I tend to get. The easy stuff you'd be amazed though.
TIA
|||No, there is no: "standard install" deployment script for getting SQL Server CE on the device, as there as some many options for distributing applications on Windows Mobile,but essenitally they all get installed by launching a cab file on the device. You could include my sample code in an autorun program on a storage card, or in a separate installer launched on the device. In order to launch a cab file, you can you wceload.exe, see http://msdn2.microsoft.com/en-us/library/ms933760.aspx
Wednesday, March 21, 2012
Deployment Issue
Hi,
I had a few sets of Reports, who were working fine. today I added a report
to my solution file at my dev machine and deployed it on the reportserver.
The Report got deployed successfully but when I browse the Report from the
browser before opening it shows the windows dialog box for "File Download"
and with the message "some files can harm your computer...." with the name
of the file as <reportfilename>.html. After clicking cancel the browser does
not shows the report. On clicking Save/Open the browser tries to download
some file which never ends.
Ironically it can preview my report from the dev machine.
My dev machine is Win XP and the Report server is Win 2000. I m using
Enterprise SQL Server MS Reports.
Is there any setting in reports/IE for this sudden behaviour
any idea will be highly appreciated..
siajHi,
I found the solution to my problem ...
There appears to be a bug in the MS RS version 8.00.743.00. If we name the
rdl file with a keyword containing "Attachmnet" Then we can deploy the file
but cant view the file..
I had named the file as "Look for Attachment.rdl" It did not work. I changed
the name it worked.
Would appreciate if some MS guy woule comment on this.
Cheers,
Jai
"siaj" wrote:
> Hi,
> I had a few sets of Reports, who were working fine. today I added a report
> to my solution file at my dev machine and deployed it on the reportserver.
> The Report got deployed successfully but when I browse the Report from the
> browser before opening it shows the windows dialog box for "File Download"
> and with the message "some files can harm your computer...." with the name
> of the file as <reportfilename>.html. After clicking cancel the browser does
> not shows the report. On clicking Save/Open the browser tries to download
> some file which never ends.
> Ironically it can preview my report from the dev machine.
> My dev machine is Win XP and the Report server is Win 2000. I m using
> Enterprise SQL Server MS Reports.
> Is there any setting in reports/IE for this sudden behaviour
> any idea will be highly appreciated..
> siaj
I had a few sets of Reports, who were working fine. today I added a report
to my solution file at my dev machine and deployed it on the reportserver.
The Report got deployed successfully but when I browse the Report from the
browser before opening it shows the windows dialog box for "File Download"
and with the message "some files can harm your computer...." with the name
of the file as <reportfilename>.html. After clicking cancel the browser does
not shows the report. On clicking Save/Open the browser tries to download
some file which never ends.
Ironically it can preview my report from the dev machine.
My dev machine is Win XP and the Report server is Win 2000. I m using
Enterprise SQL Server MS Reports.
Is there any setting in reports/IE for this sudden behaviour
any idea will be highly appreciated..
siajHi,
I found the solution to my problem ...
There appears to be a bug in the MS RS version 8.00.743.00. If we name the
rdl file with a keyword containing "Attachmnet" Then we can deploy the file
but cant view the file..
I had named the file as "Look for Attachment.rdl" It did not work. I changed
the name it worked.
Would appreciate if some MS guy woule comment on this.
Cheers,
Jai
"siaj" wrote:
> Hi,
> I had a few sets of Reports, who were working fine. today I added a report
> to my solution file at my dev machine and deployed it on the reportserver.
> The Report got deployed successfully but when I browse the Report from the
> browser before opening it shows the windows dialog box for "File Download"
> and with the message "some files can harm your computer...." with the name
> of the file as <reportfilename>.html. After clicking cancel the browser does
> not shows the report. On clicking Save/Open the browser tries to download
> some file which never ends.
> Ironically it can preview my report from the dev machine.
> My dev machine is Win XP and the Report server is Win 2000. I m using
> Enterprise SQL Server MS Reports.
> Is there any setting in reports/IE for this sudden behaviour
> any idea will be highly appreciated..
> siaj
Deployment File System installation
Hallo,
i created a solution that is working fine in development. I would now like to deploy it on an other server.
We have choosen for a file system -based deployment because this seems to require the least specialized SQL Server-knowledge from the user who will be utilizing this system. I changed the properties of the solution to
CreateDeploymentUtility: true
DeploymentOutputPath : bin\Deployment
Subsequently I build the solution and in the bin\Deployment-folder dtsx-files have been created.
Can anyone tell me what I need to do next to deploy them on an other machine?
Do I need to deploy a complete version of SQL SERVER 2005 Devenv included or is there a lighter installation possible that only contains what I need to run the packages?
Can I shedule the packages to run at a specified moment without DTultil coming up?
When you once found an answer to these many questions i would be most gratefull if you woulkd let me know.
Kind regards,
Paul
I seem to have found a solution to my own questions?
Can anyone tell me what I need to do next to deploy them on an other machine?
Do I need to deploy a complete version of SQL SERVER 2005 Devenv included or is there a lighter installation possible that only contains what I need to run the packages?
I did the test and only succeeded in running the packages after a complete install of SQLServer 2005.
Can I shedule the packages to run at a specified moment without DTultil coming up?
Using the MS-sheduler I sheduled the execution of a batch-file. this batchfile contains the Command line instructions created using DTUtil, preceded by 'DTexec '. for instance. 'DTEXEC /FILE "C:\Program Files\JACBE_IF_CAB\FMC_People.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWCDI'
There might be a more elegant solution but this seems to work .
Kind regards,
Paul
|||
You don't need devenv at all. Devenv comes with the client tools install.
The only thing you need to run packages is to install Integration Services. This is different to the client install.
-Jamie
|||
Hallo Jamie,
Thanks for your swift reply.
I admit i'm not a SQL server specilist but while installing SQL Server 2005 from CD (Microsoft SQL Server 2005 Enterprise Edition December 2005) or DVD the option 'Integration services' is disabled. So I can not single it out for installation. . Is there still an other installation dvd I need or can I download the SSIS server component from somewhere? I did not seem to find it in the download center
With kind regards,
Paul
|||That's bizarre. I have installed off that CD a number of times and the option is never greyed out. Very strange indeed - I don't know what would cuse this.
I would contact your reseller and ask them why you can't install the software that you have paid for!
-Jamie
Deployment
Hello,
What is the best way to deploy a Reporting Services solution. The solution
consists of database scripts, reports, CRI dll's and roles.
Thanks
HenrikHello Henrik,
I am not sure what does your solution include.
Based on my research and experience, you need to deploy those data
seperately.
For example, you need to run all the database scripts on the production
environment and then, you could use the VS 2005 IDE to deploy the report.
I am not sure what did you mean CRI dll and roles. Would you please specify
it more clearly?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei Lu,
We have a solution that contains the following elements:
1) SQL Scripts, which create views, tables, ect.
2) Custom Report Items (CRI) which is contained in a DLL
3) Reports (RDL files)
4) Reporting Services User Roles
5) Datasources
6) Setup of policies (permissions) on each report
We have to package the solution and deploy it to multiple customers.
Best regards
Henrik.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Henrik,
> I am not sure what does your solution include.
> Based on my research and experience, you need to deploy those data
> seperately.
> For example, you need to run all the database scripts on the production
> environment and then, you could use the VS 2005 IDE to deploy the report.
> I am not sure what did you mean CRI dll and roles. Would you please
> specify
> it more clearly?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Have you looked at MSI packages?
You could probably package most of the elements. MSI packages can be used
for SQL scripts, which covers element 1, and might cover element 4, 5 and 6
if you can do this through SQL. It can also install dlls, covering element
2. I've never tried using msi against a web service, but it should be
possible, and with the right setup of your package, you should be able to
either deploy your reports or at least trigger a rss-script (reporting
services script, not the blog rss :) ) that will deploy your reports.
A bit of information here
http://www.sqlmag.com/Article/ArticleID/22428/sql_server_22428.html
A more hands-on example and article here
http://www.csharp-home.com/index/tiki-read_article.php?articleId=152
If you decide on msi, please tell the NG what you do and how successful it
turns out.
Kaisa M. Lindahl Lervik
"Henrik Skak Pedersen" <skak@.community.nospam> wrote in message
news:eY0e8DE7GHA.4116@.TK2MSFTNGP03.phx.gbl...
> Hello Wei Lu,
> We have a solution that contains the following elements:
> 1) SQL Scripts, which create views, tables, ect.
> 2) Custom Report Items (CRI) which is contained in a DLL
> 3) Reports (RDL files)
> 4) Reporting Services User Roles
> 5) Datasources
> 6) Setup of policies (permissions) on each report
> We have to package the solution and deploy it to multiple customers.
> Best regards
> Henrik.
>
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hello Henrik,
>> I am not sure what does your solution include.
>> Based on my research and experience, you need to deploy those data
>> seperately.
>> For example, you need to run all the database scripts on the production
>> environment and then, you could use the VS 2005 IDE to deploy the report.
>> I am not sure what did you mean CRI dll and roles. Would you please
>> specify
>> it more clearly?
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>|||Hello Henrik,
I agreee with Kaisa.
You could setup a MSI package to deploy the SQL Script and use the RSS
script to deploy the Report.
Here are also some article for your reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/ht
ml/vbtskcreatinginstallerforyourapplication.asp
http://www.codeproject.com/dotnet/Win_App_Setup_Project.asp?df=100&forumid=2
50630&exp=0&select=1419048
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_prog_soapapi_script_3ik1.asp
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
What is the best way to deploy a Reporting Services solution. The solution
consists of database scripts, reports, CRI dll's and roles.
Thanks
HenrikHello Henrik,
I am not sure what does your solution include.
Based on my research and experience, you need to deploy those data
seperately.
For example, you need to run all the database scripts on the production
environment and then, you could use the VS 2005 IDE to deploy the report.
I am not sure what did you mean CRI dll and roles. Would you please specify
it more clearly?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Wei Lu,
We have a solution that contains the following elements:
1) SQL Scripts, which create views, tables, ect.
2) Custom Report Items (CRI) which is contained in a DLL
3) Reports (RDL files)
4) Reporting Services User Roles
5) Datasources
6) Setup of policies (permissions) on each report
We have to package the solution and deploy it to multiple customers.
Best regards
Henrik.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
> Hello Henrik,
> I am not sure what does your solution include.
> Based on my research and experience, you need to deploy those data
> seperately.
> For example, you need to run all the database scripts on the production
> environment and then, you could use the VS 2005 IDE to deploy the report.
> I am not sure what did you mean CRI dll and roles. Would you please
> specify
> it more clearly?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Have you looked at MSI packages?
You could probably package most of the elements. MSI packages can be used
for SQL scripts, which covers element 1, and might cover element 4, 5 and 6
if you can do this through SQL. It can also install dlls, covering element
2. I've never tried using msi against a web service, but it should be
possible, and with the right setup of your package, you should be able to
either deploy your reports or at least trigger a rss-script (reporting
services script, not the blog rss :) ) that will deploy your reports.
A bit of information here
http://www.sqlmag.com/Article/ArticleID/22428/sql_server_22428.html
A more hands-on example and article here
http://www.csharp-home.com/index/tiki-read_article.php?articleId=152
If you decide on msi, please tell the NG what you do and how successful it
turns out.
Kaisa M. Lindahl Lervik
"Henrik Skak Pedersen" <skak@.community.nospam> wrote in message
news:eY0e8DE7GHA.4116@.TK2MSFTNGP03.phx.gbl...
> Hello Wei Lu,
> We have a solution that contains the following elements:
> 1) SQL Scripts, which create views, tables, ect.
> 2) Custom Report Items (CRI) which is contained in a DLL
> 3) Reports (RDL files)
> 4) Reporting Services User Roles
> 5) Datasources
> 6) Setup of policies (permissions) on each report
> We have to package the solution and deploy it to multiple customers.
> Best regards
> Henrik.
>
> "Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
> news:OnGVeBD7GHA.2336@.TK2MSFTNGXA01.phx.gbl...
>> Hello Henrik,
>> I am not sure what does your solution include.
>> Based on my research and experience, you need to deploy those data
>> seperately.
>> For example, you need to run all the database scripts on the production
>> environment and then, you could use the VS 2005 IDE to deploy the report.
>> I am not sure what did you mean CRI dll and roles. Would you please
>> specify
>> it more clearly?
>> Sincerely,
>> Wei Lu
>> Microsoft Online Community Support
>> ==================================================>> Get notification to my posts through email? Please refer to
>> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
>> ications.
>> Note: The MSDN Managed Newsgroup support offering is for non-urgent
>> issues
>> where an initial response from the community or a Microsoft Support
>> Engineer within 1 business day is acceptable. Please note that each
>> follow
>> up response may take approximately 2 business days as the support
>> professional working with you may need further investigation to reach the
>> most efficient resolution. The offering is not appropriate for situations
>> that require urgent, real-time or phone-based interactions or complex
>> project analysis and dump analysis issues. Issues of this nature are best
>> handled working with a dedicated Microsoft Support Engineer by contacting
>> Microsoft Customer Support Services (CSS) at
>> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>> ==================================================>> (This posting is provided "AS IS", with no warranties, and confers no
>> rights.)
>|||Hello Henrik,
I agreee with Kaisa.
You could setup a MSI package to deploy the SQL Script and use the RSS
script to deploy the Report.
Here are also some article for your reference:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsintro7/ht
ml/vbtskcreatinginstallerforyourapplication.asp
http://www.codeproject.com/dotnet/Win_App_Setup_Project.asp?df=100&forumid=2
50630&exp=0&select=1419048
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/
rsp_prog_soapapi_script_3ik1.asp
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 19, 2012
Deploying updated report but still seeing old version
Hi,
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >
Deploying SQL Server 2005 Express
Hello
1.) Is there any solution for integrating the deployment of the sql server express into the setup project of my vb 2005 app ? 'Cause it is too much to install the framework... then the sql server and then the app....... Any help would be appreciated!
Thx
This may help:
http://msdn2.microsoft.com/en-us/library/ms165716.aspx
Buck Woody
Deploying SQL Server 2005 Express
Hello
1.) Is there any solution for integrating the deployment of the sql server express into the setup project of my vb 2005 app ? 'Cause it is too much to install the framework... then the sql server and then the app....... Any help would be appreciated!
Thx
This may help:
http://msdn2.microsoft.com/en-us/library/ms165716.aspx
Buck Woody
Friday, March 9, 2012
Deploying multiple web parts together
Hi,
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
Amit
Hi
"Amit" wrote:
> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/community/newsgroups/server/sharepoint.mspx
and choose a group.
John
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
Amit
Hi
"Amit" wrote:
> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/community/newsgroups/server/sharepoint.mspx
and choose a group.
John
Deploying multiple web parts together
Hi,
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
AmitHi
"Amit" wrote:
> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/community/newsgroups/server/sharepoint.mspx
and choose a group.
John
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
AmitHi
"Amit" wrote:
> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/community/newsgroups/server/sharepoint.mspx
and choose a group.
John
Deploying multiple web parts together
Hi,
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
AmitHi
"Amit" wrote:
> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/co...sharepoint.mspx
and choose a group.
John
My problem is that i want to add Web Part library project so that i
could add more than one web part into one solution.This will
facilitate me in deploying just one solution on Sharepoint server and
all webparts would be deployed.I searched through Google and found
that it was possible in vs.net 2003 through Web Part Template Library
project.But i could not find out any method of doing so in vs.net
2005.Could any one help..
I am using Sharepoint Server 2007 and vs.net 2005
AmitHi
"Amit" wrote:
> Hi,
> My problem is that i want to add Web Part library project so that i
> could add more than one web part into one solution.This will
> facilitate me in deploying just one solution on Sharepoint server and
> all webparts would be deployed.I searched through Google and found
> that it was possible in vs.net 2003 through Web Part Template Library
> project.But i could not find out any method of doing so in vs.net
> 2005.Could any one help..
> I am using Sharepoint Server 2007 and vs.net 2005
> Amit
>
This is not really a SQL Server question, you should post to a more
appropriate group such as microsoft.public.sharepoint.* or go to
http://www.microsoft.com/technet/co...sharepoint.mspx
and choose a group.
John
Wednesday, March 7, 2012
Deploying CLR from VStudio -- issue with permissions
I have a CLR project in my VStudio solution.
Whenever I deploy the project to SQL, the deployment will be successful, but, because the stored proc wrappers that get made in SQL are remade, all permissions that I had applied to those stored procs are gone and have to be reentered through SQL. I have made a TransactSQL script to run to automate this. Basically, what I need is to give them a group permission that is associated with the tables that they work with.
I gotta figure I am missing something simple that would allow my permissions to stick.
?
You can create "postdeployscript.sql" with everything you need to be executed after deployment, and put it to the root of the SQL-CLR project. Same holds for "predeployscript.sql" - it will be executed before deployment
|||Thanks -- that solves my problem.Deploying Analysis service solution
Greetings,
How do I deploy an Analysis services project on to diference machines. I have followed the process laid out in MSDN and changed the server to the remote server name while deploying. It throws up an error that the user does not have permissions to create objects on remote server.
Please help me understanding the process of deployment and how the analysts can open up the deployed cube in their machines
Thanks/Regards
Shiv
You must had the users in the security panel of your remote Analysis Services.
In Microsoft SQL Server Management Studio, open a connection to your Analysis Services Server. Click Right on the name of your server (XXXX (Microsoft Analysis Services...))
Choose Properties, Security, and add the users that must access to your server
|||Hi,
I am facing the same problem, i did as u said and got the following error:
TITLE: Connect to Server
Cannot connect to myserver.
ADDITIONAL INFORMATION:
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
An existing connection was forcibly closed by the remote host (System)
BUTTONS:
OK
pls any help ?
Thanks
Tarek Ghazali
MS SQL Server MVP
Deploying Analysis service solution
Greetings,
How do I deploy an Analysis services project on to diference machines. I have followed the process laid out in MSDN and changed the server to the remote server name while deploying. It throws up an error that the user does not have permissions to create objects on remote server.
Please help me understanding the process of deployment and how the analysts can open up the deployed cube in their machines
Thanks/Regards
Shiv
You must had the users in the security panel of your remote Analysis Services.
In Microsoft SQL Server Management Studio, open a connection to your Analysis Services Server. Click Right on the name of your server (XXXX (Microsoft Analysis Services...))
Choose Properties, Security, and add the users that must access to your server
|||Hi,
I am facing the same problem, i did as u said and got the following error:
TITLE: Connect to Server
Cannot connect to myserver.
ADDITIONAL INFORMATION:
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
An existing connection was forcibly closed by the remote host (System)
BUTTONS:
OK
pls any help ?
Thanks
Tarek Ghazali
MS SQL Server MVP
Deploying a SSAS solution from File location using C#
Hi all,
i have created a SSAS solution using BIDS . I have saved the project on local hard disk. Now i need to deploy the solution through C# and not use C#. Can i do that ? if how how?
Regards..
Girija Shankar
Could you describe your goals a bit more? When you create an SSAS solution with BIDS, a script file is created that can be used to deploy a database to SSAS. You could also use the ASCMD application to submit scripts or execute a script via AMO. (I believe the Server object's Execute method handles this.)
B.
|||Hi Bryan,
Thanks for the reply. The scenario is as folows:
1. I create a SSAS solution. i create the datasource,DSv,cubes and dimensions and Roles.I donot deploy that to the server but save the file to a local drive location.
2. If i go to the local directory path where I saved the solution i will find files such as .database, .cube,.partitions, .dim etc
3. i need to deploy the full solution from this file location to the server. After deployement i can process the cubes one by one using AMO. The processing part is clear to me using AMO but how to deploy from file location i am not able to figure out . All this has to be done through code (C#).
Regards...
Girija Shankar
|||So, the file in the BIN folder is a complete or near-complete script. You should be able to use standard techniques to read the file (it's just XML though I would read it as a simple text file). With the script in memory, you can then submit it as a string through the AMO Server object's Execute method.
You may also want to review the ASCMD project that comes with the SSAS samples. I believe it has the functionality built in to read a file and execute it like I'm describing. It's also written in C#.
B.
|||Bryan,
There are four files in bin folder . i suppose i would be using .asdatabase file. read that,envolope that with the create and Object Tags and execute that on server. Is this correct?
Regards...
Girija Shankar
|||Hi, Another question.
There are some read only tags such as CreatedTimestamp, should i remove them while reading that?
Regards...
Girija Shankar
command that can be sent the the server to deploy and optionally process the cube. This script deployment can be done using Adomd.Net, an XMLA Query in SQL Management Studio, or using the ASCMD.exe command line utilility available at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en.
Deploying a SSAS solution from File location using C#
Hi all,
i have created a SSAS solution using BIDS . I have saved the project on local hard disk. Now i need to deploy the solution through C# and not use C#. Can i do that ? if how how?
Regards..
Girija Shankar
Could you describe your goals a bit more? When you create an SSAS solution with BIDS, a script file is created that can be used to deploy a database to SSAS. You could also use the ASCMD application to submit scripts or execute a script via AMO. (I believe the Server object's Execute method handles this.)
B.
|||Hi Bryan,
Thanks for the reply. The scenario is as folows:
1. I create a SSAS solution. i create the datasource,DSv,cubes and dimensions and Roles.I donot deploy that to the server but save the file to a local drive location.
2. If i go to the local directory path where I saved the solution i will find files such as .database, .cube,.partitions, .dim etc
3. i need to deploy the full solution from this file location to the server. After deployement i can process the cubes one by one using AMO. The processing part is clear to me using AMO but how to deploy from file location i am not able to figure out . All this has to be done through code (C#).
Regards...
Girija Shankar
|||So, the file in the BIN folder is a complete or near-complete script. You should be able to use standard techniques to read the file (it's just XML though I would read it as a simple text file). With the script in memory, you can then submit it as a string through the AMO Server object's Execute method.
You may also want to review the ASCMD project that comes with the SSAS samples. I believe it has the functionality built in to read a file and execute it like I'm describing. It's also written in C#.
B.
|||Bryan,
There are four files in bin folder . i suppose i would be using .asdatabase file. read that,envolope that with the create and Object Tags and execute that on server. Is this correct?
Regards...
Girija Shankar
|||Hi, Another question.
There are some read only tags such as CreatedTimestamp, should i remove them while reading that?
Regards...
Girija Shankar
command that can be sent the the server to deploy and optionally process the cube. This script deployment can be done using Adomd.Net, an XMLA Query in SQL Management Studio, or using the ASCMD.exe command line utilility available at http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en.
Friday, February 24, 2012
Deploy Solution brings up a login box
Login box shows a server ashttp://localhost/reports (could be wrong, I don't kow but that's what I put in the property for that)
Then it wants a user name and password. I've tried a few logons but it doesn't accept them.
What is the problem here?
Disregard. reports needs to be reportserver.Deploy single report with keyboard shortcut?
Is it possible to deploy a single report from Visual Studio 2003 with a
keyboard shortcut? I can do it by right clicking in the Solution Explorer,
but it would be nice to just press "some combination of buttons" to make my
current report get deployed to the server.
Kaisa M. Lindahl LervikYou can use Tools\Options and Environment(Keyboard) settings to set shortcut
keys. There is a Build.DeploySelection command, but my attempts show that it
deploys the entire project and that you have to be in Solution Explorer for
the shortcut to activate. You can try for other combinations though.
Rodney Landrum
"Kaisa M. Lindahl Lervik" <kaisaml@.hotmail.com> wrote in message
news:uiTk6z7VGHA.2760@.TK2MSFTNGP11.phx.gbl...
> Is it possible to deploy a single report from Visual Studio 2003 with a
> keyboard shortcut? I can do it by right clicking in the Solution Explorer,
> but it would be nice to just press "some combination of buttons" to make
> my current report get deployed to the server.
> Kaisa M. Lindahl Lervik
>
keyboard shortcut? I can do it by right clicking in the Solution Explorer,
but it would be nice to just press "some combination of buttons" to make my
current report get deployed to the server.
Kaisa M. Lindahl LervikYou can use Tools\Options and Environment(Keyboard) settings to set shortcut
keys. There is a Build.DeploySelection command, but my attempts show that it
deploys the entire project and that you have to be in Solution Explorer for
the shortcut to activate. You can try for other combinations though.
Rodney Landrum
"Kaisa M. Lindahl Lervik" <kaisaml@.hotmail.com> wrote in message
news:uiTk6z7VGHA.2760@.TK2MSFTNGP11.phx.gbl...
> Is it possible to deploy a single report from Visual Studio 2003 with a
> keyboard shortcut? I can do it by right clicking in the Solution Explorer,
> but it would be nice to just press "some combination of buttons" to make
> my current report get deployed to the server.
> Kaisa M. Lindahl Lervik
>
Subscribe to:
Posts (Atom)