Development server vs Live server deployment

How do you guys handle this? I want to create and develop our reports on our
development report services server with its own SQL server 2005 server...
then later when they are tested and working deploy them to our live server
with a completly different instance of SQL Server 2005 (enterprise edition)
and have them run there on its report services server with its data source
as itself... how would you go about doing this? thanks! Also is there a way
to change the database and database server at runtime (say in a VB.NET
application?) thanks!Smokey,
Check this page :
http://msdn2.microsoft.com/en-us/library/ms160854.aspx
for "PublishSampleReports.rss"
This should answer your "how would you go about doing this" part of the
question...
Andrei.
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
> How do you guys handle this? I want to create and develop our reports on
> our development report services server with its own SQL server 2005
> server... then later when they are tested and working deploy them to our
> live server with a completly different instance of SQL Server 2005
> (enterprise edition) and have them run there on its report services server
> with its data source as itself... how would you go about doing this?
> thanks! Also is there a way to change the database and database server at
> runtime (say in a VB.NET application?) thanks!
>|||any idea how you would change the dataset's database and database server at
runtime of a report?
"Andrei" <andrei.toma@.era-environmental.com> wrote in message
news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
> Smokey,
> Check this page :
> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
> for "PublishSampleReports.rss"
> This should answer your "how would you go about doing this" part of the
> question...
> Andrei.
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports on
>> our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to our
>> live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>|||Are you supporting multiple databases with the same structure or is this
just going from development to production? If you use shared datasources
then you configure it once on each server and after that you are good to go.
The reports go against the shared datasource which defaults to not being
overwritten so when you deploy it is left alone.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:eRK0myOOHHA.3212@.TK2MSFTNGP02.phx.gbl...
> any idea how you would change the dataset's database and database server
> at runtime of a report?
> "Andrei" <andrei.toma@.era-environmental.com> wrote in message
> news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> Smokey,
>> Check this page :
>> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
>> for "PublishSampleReports.rss"
>> This should answer your "how would you go about doing this" part of the
>> question...
>> Andrei.
>> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
>> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports on
>> our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to our
>> live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>>
>|||multiple databases, We have this structure in our application...
Our Live server can have multiple databases with the same exact schema (we
have a Live system with real time data, and a testing system with weekly
data from the live system for testing out stuff) when we log into our
application you select the server and which database you are going to work
with... in crystal reports we manually changed the mappings in the report to
get it to work with the different databases on the server then ran the
report, just wondering how you can do something similar in reporting server.
90% of the time the reports are ran in the live system, but we still have to
support the other 10% and dont want to make copies of reports for each
database, because techincally, someone could make another database at any
point in time with the same schema
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uiAgLBSOHHA.4848@.TK2MSFTNGP04.phx.gbl...
> Are you supporting multiple databases with the same structure or is this
> just going from development to production? If you use shared datasources
> then you configure it once on each server and after that you are good to
> go. The reports go against the shared datasource which defaults to not
> being overwritten so when you deploy it is left alone.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:eRK0myOOHHA.3212@.TK2MSFTNGP02.phx.gbl...
>> any idea how you would change the dataset's database and database server
>> at runtime of a report?
>> "Andrei" <andrei.toma@.era-environmental.com> wrote in message
>> news:O4ukonOOHHA.2236@.TK2MSFTNGP02.phx.gbl...
>> Smokey,
>> Check this page :
>> http://msdn2.microsoft.com/en-us/library/ms160854.aspx
>> for "PublishSampleReports.rss"
>> This should answer your "how would you go about doing this" part of the
>> question...
>> Andrei.
>> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
>> news:%23fQIZjOOHHA.1248@.TK2MSFTNGP03.phx.gbl...
>> How do you guys handle this? I want to create and develop our reports
>> on our development report services server with its own SQL server 2005
>> server... then later when they are tested and working deploy them to
>> our live server with a completly different instance of SQL Server 2005
>> (enterprise edition) and have them run there on its report services
>> server with its data source as itself... how would you go about doing
>> this? thanks! Also is there a way to change the database and database
>> server at runtime (say in a VB.NET application?) thanks!
>>
>>
>

Developer cant handle dates

Do I have to convert dates for a .NET developer so they can capture ms?
Or is there a method they are suppose to be using
I had to remove my modified date check to check for data collisions because they can't pass back microseconds.
What's the dealDepending on which of the .NET languages is being used, and in most of them which data type is being used, temporal data can be stored to the day, second, or true millisecond (which is actually more precise than SQL Server can store).

The short answer becomes something like: If you want absolute portability, convert and send them text (character) data. If they are using C#, C++, or VB then they just have to choose the correct data type. Most of the other .NET languages can store times to millieconds, but depending on the language that can be a pain in the patoot.

-PatP|||This dodges the obvious bullet about most developers not being able to even get a date, much less handle one! ;)

-PatP|||i thought this was a craigslist post.|||OK, CONVERT it is

And why is sql server limited in th MS category?

Something about clock speed?