Is there a way to automate some of the reports available in Sql Server Mgmt
Studio? I really like several of them, such as the Schema Changes History,
and think they would be helpful from a "compliance" perspective. So, I've
been exporting a few to PDF or Excel on a regular basis... so it's pretty
obvious that the next step would be to have a job that does automatically on
a scheduled basis (Daily, Weekly, whatever).
Any insight on if this doable w/out too many hoops?
-- Margo Noreen
Hello M,
You can download the reports here
http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx
You will need to put them in RS and schedule them
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> Is there a way to automate some of the reports available in Sql Server
> Mgmt Studio? I really like several of them, such as the Schema
> Changes History, and think they would be helpful from a "compliance"
> perspective. So, I've been exporting a few to PDF or Excel on a
> regular basis... so it's pretty obvious that the next step would be to
> have a job that does automatically on a scheduled basis (Daily,
> Weekly, whatever).
> Any insight on if this doable w/out too many hoops?
>
|||So that assumes one has Reporting Services setup and configured... which we
do not.
No other way?
-- Margo Noreen
"Simon Sabin" wrote:
[vbcol=seagreen]
> Hello M,
> You can download the reports here
> http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx
> You will need to put them in RS and schedule them
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
|||RS is needed if you want the same cool look you currently have in Management
Studio. If you're just after the data, you can pull the queries into a
sproc, tweak it to output to a persistent table and schedule a job to run it
at whatever frequency you need.
joe.
"M Noreen" <MNoreen@.discussions.microsoft.com> wrote in message
news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@.microsoft.com...[vbcol=seagreen]
> So that assumes one has Reporting Services setup and configured... which
> we
> do not.
> No other way?
> --
> -- Margo Noreen
>
> "Simon Sabin" wrote:
|||We have Reporting Services installed on some servers. Can we run these
reports against any other SQL Servers in our network.
thanks,
ktm
"Joe Yong" wrote:
> RS is needed if you want the same cool look you currently have in Management
> Studio. If you're just after the data, you can pull the queries into a
> sproc, tweak it to output to a persistent table and schedule a job to run it
> at whatever frequency you need.
>
> joe.
> "M Noreen" <MNoreen@.discussions.microsoft.com> wrote in message
> news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@.microsoft.com...
>
>
|||You can run these reports against any SQL Server 2005 instance.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
"ktmd" <ktmd@.discussions.microsoft.com> wrote in message
news:3F316342-FAB9-4E5A-802A-320713FD9E39@.microsoft.com...[vbcol=seagreen]
> We have Reporting Services installed on some servers. Can we run these
> reports against any other SQL Servers in our network.
> thanks,
> ktm
> "Joe Yong" wrote:
Showing posts with label schema. Show all posts
Showing posts with label schema. Show all posts
Thursday, March 29, 2012
Friday, February 24, 2012
AutoGenerate Table Schema in SSIS
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?SSIS can't handle changing metadata. Once built, it's set. (Unless you edit it and resave it.) Unless you are going to build the package using .Net, I don't believe this is possible.|||
Leo Mwangi wrote:
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?
Are you just wanting to drop and recreate the table, or do you want to populate it with data as well? If you want to populate it, Phil's comment applies. If you just want to drop and recreate the table based on info from a flat file, you could use a script task to read the file, create the appropriate SQL statements to DROP and CREATE the table and store them in variables, then call them from an Execute SQL task.
|||True statement, John!|||I want to drop and recreate them then push data. I think i have a working script which I will be pushing using script task. thanks for the suggestions guys.AutoGenerate Table Schema in SSIS
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?SSIS can't handle changing metadata. Once built, it's set. (Unless you edit it and resave it.) Unless you are going to build the package using .Net, I don't believe this is possible.|||
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?
Are you just wanting to drop and recreate the table, or do you want to populate it with data as well? If you want to populate it, Phil's comment applies. If you just want to drop and recreate the table based on info from a flat file, you could use a script task to read the file, create the appropriate SQL statements to DROP and CREATE the table and store them in variables, then call them from an Execute SQL task.
|||True statement, John!|||I want to drop and recreate them then push data. I think i have a working script which I will be pushing using script task. thanks for the suggestions guys.AutoGenerate Table Schema in SSIS
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?SSIS can't handle changing metadata. Once built, it's set. (Unless you edit it and resave it.) Unless you are going to build the package using .Net, I don't believe this is possible.|||
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?
Are you just wanting to drop and recreate the table, or do you want to populate it with data as well? If you want to populate it, Phil's comment applies. If you just want to drop and recreate the table based on info from a flat file, you could use a script task to read the file, create the appropriate SQL statements to DROP and CREATE the table and store them in variables, then call them from an Execute SQL task.
|||True statement, John!|||I want to drop and recreate them then push data. I think i have a working script which I will be pushing using script task. thanks for the suggestions guys.AutoGenerate Table Schema in SSIS
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?SSIS can't handle changing metadata. Once built, it's set. (Unless you edit it and resave it.) Unless you are going to build the package using .Net, I don't believe this is possible.|||
I have a database that has few tables whose table Schema changes oftenly based on a flat file specification and I wanted to automate the process where I drop the table and recreate it with the new schema using an SSIS package. Any Ideas on how I can achieve this?
Are you just wanting to drop and recreate the table, or do you want to populate it with data as well? If you want to populate it, Phil's comment applies. If you just want to drop and recreate the table based on info from a flat file, you could use a script task to read the file, create the appropriate SQL statements to DROP and CREATE the table and store them in variables, then call them from an Execute SQL task.
|||True statement, John!|||I want to drop and recreate them then push data. I think i have a working script which I will be pushing using script task. thanks for the suggestions guys.
Subscribe to:
Posts (Atom)