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!
>>
>>
>
Showing posts with label develop. Show all posts
Showing posts with label develop. Show all posts
Wednesday, March 7, 2012
Development Procedures
Hello,
Recently my partner in crime (so to speak) and I have been asked to develop procedures and/or methods for our software development group. Currently we're running SQL Server 8 with several Access apps and Crystal Reports. In a nutshell, I'm looking for resources.
We're supposed to develop a process (we're both DBA's) where our development team can formally submit new stored procedures, views, or whatever they've come up with to solve for buisiness requirements. It'll be our job to take thier scripts and execute them on the production database after ensuring someone has tested the logic and signed-off on it.
Unfortunately, I have been charged with developing this process (ie: development, sign-off, testing, etc..). Currently we have no procedures in place; until now my partner and I have been the primary deveopers (this is about to change). Are there any resources out there that could help me develop a formal process for our soon-comming developers?
Thanks,
Jason
Jason -
You can check out InformIT.com - they have lots of information there on a "professional" nature, not just technical info. I do the SQL Server "Guide", and I've got an article or two that might be useful.
Most of the Software Development articles will point towards a particular methodology or tool. I've found that most shops develop their own methods and call it an "SDLC" or Software Development Life Cycle. Also check out a book called "Code Complete".
Buck
Development Procedures
Hello,
Recently my partner in crime (so to speak) and I have been asked to develop procedures and/or methods for our software development group. Currently we're running SQL Server 8 with several Access apps and Crystal Reports. In a nutshell, I'm looking for resources.
We're supposed to develop a process (we're both DBA's) where our development team can formally submit new stored procedures, views, or whatever they've come up with to solve for buisiness requirements. It'll be our job to take thier scripts and execute them on the production database after ensuring someone has tested the logic and signed-off on it.
Unfortunately, I have been charged with developing this process (ie: development, sign-off, testing, etc..). Currently we have no procedures in place; until now my partner and I have been the primary deveopers (this is about to change). Are there any resources out there that could help me develop a formal process for our soon-comming developers?
Thanks,
Jason
Jason -
You can check out InformIT.com - they have lots of information there on a "professional" nature, not just technical info. I do the SQL Server "Guide", and I've got an article or two that might be useful.
Most of the Software Development articles will point towards a particular methodology or tool. I've found that most shops develop their own methods and call it an "SDLC" or Software Development Life Cycle. Also check out a book called "Code Complete".
Buck
Development Environment Needs?
Trying to figure out what development enviroment we need in order to
do the following:
do the following:
- develop a non-native SQL server stored procedure;
- call a web service or java program from the stored procedure;
- return static values;
- call the stored procedure from a view.
How do I get a hold of the right tools and what do I need to put the
pieces together?
Obviously, I've not used SQL server and I'm looking for the basic
starting point.
Thanks!CG (chelseagraylin@.hotmail.com) writes:
> Trying to figure out what development enviroment we need in order to
> do the following:
> - develop a non-native SQL server stored procedure;
> - call a web service or java program from the stored procedure;
> - return static values;
> - call the stored procedure from a view.
You cannot call stored procedures from views. You can call extended
stored procedures from used-defined functions though, and these you
call from views. (Or use table-valued functions which are basically
parameterized views, and which can be multi-statement.)
Typically you develop extended stored procedures in C++. If you want to
talk .Net you would need a COM interop.
Since you appear to be forward-looking, you might find interest in
the upcoming version of SQL Server, where you can program CLR directly
in SQL Server. In SQL 2005 you can develop the function directly in
CLR. To call a web service there would still be a few things to go
through, but it would certainly be easier.
Beta 2 of SQL Server is expected soon, and this will be a public beta.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||So if I want to do this with the current version (yes, looks like this
will be much easier in the future!), I need a SQL Server environment
set up (hopefully just the desktop version) and then I need an
environment to be able to write a C++ program that is accessible by
SQL Server?
Sounds so easy...|||CG (chelseagraylin@.hotmail.com) writes:
> So if I want to do this with the current version (yes, looks like this
> will be much easier in the future!), I need a SQL Server environment
> set up (hopefully just the desktop version) and then I need an
> environment to be able to write a C++ program that is accessible by
> SQL Server?
For SQL Server I would recommend using Developer Edition, which is at
49 USD only. Developer Edition comes with graphic tools, and having
Query Analyzer to submit queries is invaluable.
However, once you go in production, you are better of with MSDE, since
Developer Edition is not licensed for production. (And for some strange
reason, the graphic tools can be used against MSDE according to the
license.)
You will also need a couple of include files and link libraries. They
come with Devloper Edition.
For the C++ environment I am not really the guy to ask, but Visual
Studio is of course a safe bet. If you go for GNU C++ to use freeware,
you will probably need the Platform SDK, which I have no idea how it
is available outside VS.
> Sounds so easy...
Getting the environment is indeed the easy part. The actual development
is likely to be tougher. Writing extended stored procedures is not for
the faint of heart. Keep in mind that they execute in-process, so an
access violation in your XP can crash the entire SQL Server.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog (esquel@.sommarskog.se) writes:
> (And for some strange reason, the graphic tools can be used against MSDE
> according to the license.)
An important word disappeared here, so I take it again:
> (And for some strange reason, the graphic tools can *not* be used against
> MSDE according to the license.)
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi
To add to Erland's post...
Don't forget source code control, such as Visual Source Safe or PVCS... If
you go the whole Microsoft suite then a MSDN subscription would be an
excellent investment.
John
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns951B2905B452Yazorman@.127.0.0.1...
> CG (chelseagraylin@.hotmail.com) writes:
> > So if I want to do this with the current version (yes, looks like this
> > will be much easier in the future!), I need a SQL Server environment
> > set up (hopefully just the desktop version) and then I need an
> > environment to be able to write a C++ program that is accessible by
> > SQL Server?
> For SQL Server I would recommend using Developer Edition, which is at
> 49 USD only. Developer Edition comes with graphic tools, and having
> Query Analyzer to submit queries is invaluable.
> However, once you go in production, you are better of with MSDE, since
> Developer Edition is not licensed for production. (And for some strange
> reason, the graphic tools can be used against MSDE according to the
> license.)
> You will also need a couple of include files and link libraries. They
> come with Devloper Edition.
> For the C++ environment I am not really the guy to ask, but Visual
> Studio is of course a safe bet. If you go for GNU C++ to use freeware,
> you will probably need the Platform SDK, which I have no idea how it
> is available outside VS.
> > Sounds so easy...
> Getting the environment is indeed the easy part. The actual development
> is likely to be tougher. Writing extended stored procedures is not for
> the faint of heart. Keep in mind that they execute in-process, so an
> access violation in your XP can crash the entire SQL Server.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp
Development database, what to use?
The web hotel I am using have MS SQL server installed. I do not have it on my local development PC.
How do I develop and test a website, locally, using MS SQL DB, without having MS SQL sever. Is there any light MS SQL sever I can use with a good user interface, and then just upload the DB to MS SQL server?
Please advise, NewBe2Get SQL Server developer edition. And you are set.
SQL Server IS light, compared to the serious competition.
Saturday, February 25, 2012
Developing WAP using ASP.NET and Web Services
Hi all,
I would like to develop WAP using ASP.NET which can connect to the Database( MS SQL Server ). Is it possible to do it? I try to find the tutorial but I cannot find it.
Another thing I want to ask is can I connect the WAP to the web services that I create using ASP.NET, anyone can tell me how to do it.
Thanks, Regards.
REDWAP is something that is sent to and displayed on the client. ASP.NET and Web Services are server side technologies. You can certainly have your ASP.NET application call out to a Web service, and then send the results to your WAP device.
Developing Thirty Party Controls for RS2005
I want to develop a new report control or extend the existing textbox control in RS2005. Is there any documentation or examples on how to do this?
Thanks,
Check out Teo Lachev's recent MSDN article on the CustomReportItem feature of RS 2005: http://msdn.microsoft.com/msdnmag/issues/06/10/SQLServer2005/default.aspx
-- Robert
developing enterprise using c# and dmo
hi all,
i have a question ,
i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop engine,for you it is legal develop and sell this software?
Thanks.
AFAIK, yes. DMO is re-distributable. Just note that there already exists a number of these admin tools, where
some are free...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GMC" <killthedrake@.yahoo.it> wrote in message news:9601E139-1667-4C83-8A7F-7EC2564EFBB4@.microsoft.com...
> hi all,
> i have a question ,
> i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop
engine,for you it is legal develop and sell this software?
> Thanks.
i have a question ,
i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop engine,for you it is legal develop and sell this software?
Thanks.
AFAIK, yes. DMO is re-distributable. Just note that there already exists a number of these admin tools, where
some are free...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GMC" <killthedrake@.yahoo.it> wrote in message news:9601E139-1667-4C83-8A7F-7EC2564EFBB4@.microsoft.com...
> hi all,
> i have a question ,
> i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop
engine,for you it is legal develop and sell this software?
> Thanks.
developing enterprise using c# and dmo
hi all,
i have a question ,
i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop engine,for you it is legal develop and sell this software?
Thanks.AFAIK, yes. DMO is re-distributable. Just note that there already exists a number of these admin tools, where
some are free...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GMC" <killthedrake@.yahoo.it> wrote in message news:9601E139-1667-4C83-8A7F-7EC2564EFBB4@.microsoft.com...
> hi all,
> i have a question ,
> i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop
engine,for you it is legal develop and sell this software?
> Thanks.
i have a question ,
i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop engine,for you it is legal develop and sell this software?
Thanks.AFAIK, yes. DMO is re-distributable. Just note that there already exists a number of these admin tools, where
some are free...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GMC" <killthedrake@.yahoo.it> wrote in message news:9601E139-1667-4C83-8A7F-7EC2564EFBB4@.microsoft.com...
> hi all,
> i have a question ,
> i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager for use it with Desktop
engine,for you it is legal develop and sell this software?
> Thanks.
developing enterprise using c# and dmo
hi all,
i have a question ,
i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager
for use it with Desktop engine,for you it is legal develop and sell this s
oftware?
Thanks.AFAIK, yes. DMO is re-distributable. Just note that there already exists a n
umber of these admin tools, where
some are free...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GMC" <killthedrake@.yahoo.it> wrote in message news:9601E139-1667-4C83-8A7F-7EC2564EFBB4@.mic
rosoft.com...
> hi all,
> i have a question ,
> i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager
for use it with Desktop
engine,for you it is legal develop and sell this software?
> Thanks.
i have a question ,
i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager
for use it with Desktop engine,for you it is legal develop and sell this s
oftware?
Thanks.AFAIK, yes. DMO is re-distributable. Just note that there already exists a n
umber of these admin tools, where
some are free...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"GMC" <killthedrake@.yahoo.it> wrote in message news:9601E139-1667-4C83-8A7F-7EC2564EFBB4@.mic
rosoft.com...
> hi all,
> i have a question ,
> i'm interested to develop (using c# and SqlDmo) a little Enterprise Manager
for use it with Desktop
engine,for you it is legal develop and sell this software?
> Thanks.
Developing a Search Case
hi all,
I am developing a search case...and i got to develop a stored procedure.
the procedure will be called in the following way...
exec search_text('t1@.c1%c2%c3%t2@.c1%c2%c3%t3@.c1%c2%,'he llo')
i.e. i want to search for 'hello' in the t1,t2,t3 tables and c1,c2,c3..are the corresponding columns in respective tables..
writing select statement is easy.,..but need a best solution to divide the tables and columns and then writing the procedure...
help me out...
thanks and regards
sai sreenivasHi,
it all depends on what database server you want to run the Stored Procedure...
So, what's the database and we try again...|||hii ,
My Database server is SQLSERVER on windows 2000 platform.....
looking forward for your reply...
thanks and regards
SAI SREENIVAS JEEDIGUNTA|||I'm sorry man, I'm not that familiar with Microsoft software.
If it were DB2 or Informix I could give you the solution...|||Will you always have the pattern 1 table and 3 columns ? Can you post the sql statement you have already designed that you want emulated in the sp ? Will you be running this sp in sql server or through a front-end like visual basic ... ? Will you always be searching for "hello" or some unknown string ?|||What results are you expecting back from your stored procedure ?
I am developing a search case...and i got to develop a stored procedure.
the procedure will be called in the following way...
exec search_text('t1@.c1%c2%c3%t2@.c1%c2%c3%t3@.c1%c2%,'he llo')
i.e. i want to search for 'hello' in the t1,t2,t3 tables and c1,c2,c3..are the corresponding columns in respective tables..
writing select statement is easy.,..but need a best solution to divide the tables and columns and then writing the procedure...
help me out...
thanks and regards
sai sreenivasHi,
it all depends on what database server you want to run the Stored Procedure...
So, what's the database and we try again...|||hii ,
My Database server is SQLSERVER on windows 2000 platform.....
looking forward for your reply...
thanks and regards
SAI SREENIVAS JEEDIGUNTA|||I'm sorry man, I'm not that familiar with Microsoft software.
If it were DB2 or Informix I could give you the solution...|||Will you always have the pattern 1 table and 3 columns ? Can you post the sql statement you have already designed that you want emulated in the sp ? Will you be running this sp in sql server or through a front-end like visual basic ... ? Will you always be searching for "hello" or some unknown string ?|||What results are you expecting back from your stored procedure ?
Sunday, February 19, 2012
Developer Edition
We are looking at putting Developer Edition on a server to allow us to test and develop databases/applications which will then be moved to one of our live standard licensed servers. I have a couple of questions as the licencing is confusing
1. Is the licence per developer? Our developers often work together, so can we licence each developer so they can all access one test server
2. Some documentation refers to a maximum of 5 connections. Is this in total or concurrently
2. Can users with existing CAL's access the server for the purpose of testing and evaluation
ThnakLicencing is per developer if bought standalone. If you are getting
Developer edition via MSDN subscription or similar, it is governed by the
EULA for MSDN.
Lots of info here;
http://www.microsoft.com/sql/howtobuy/development.asp
Cheers
Ken
"El" <anonymous@.discussions.microsoft.com> wrote in message
news:2B485FC0-48B8-4668-B8AB-67B1D890814F@.microsoft.com...
: We are looking at putting Developer Edition on a server to allow us to
test and develop databases/applications which will then be moved to one of
our live standard licensed servers. I have a couple of questions as the
licencing is confusing.
:
: 1. Is the licence per developer? Our developers often work together, so
can we licence each developer so they can all access one test server?
: 2. Some documentation refers to a maximum of 5 connections. Is this in
total or concurrently?
: 2. Can users with existing CAL's access the server for the purpose of
testing and evaluation?
:
: Thnaks
:
1. Is the licence per developer? Our developers often work together, so can we licence each developer so they can all access one test server
2. Some documentation refers to a maximum of 5 connections. Is this in total or concurrently
2. Can users with existing CAL's access the server for the purpose of testing and evaluation
ThnakLicencing is per developer if bought standalone. If you are getting
Developer edition via MSDN subscription or similar, it is governed by the
EULA for MSDN.
Lots of info here;
http://www.microsoft.com/sql/howtobuy/development.asp
Cheers
Ken
"El" <anonymous@.discussions.microsoft.com> wrote in message
news:2B485FC0-48B8-4668-B8AB-67B1D890814F@.microsoft.com...
: We are looking at putting Developer Edition on a server to allow us to
test and develop databases/applications which will then be moved to one of
our live standard licensed servers. I have a couple of questions as the
licencing is confusing.
:
: 1. Is the licence per developer? Our developers often work together, so
can we licence each developer so they can all access one test server?
: 2. Some documentation refers to a maximum of 5 connections. Is this in
total or concurrently?
: 2. Can users with existing CAL's access the server for the purpose of
testing and evaluation?
:
: Thnaks
:
Friday, February 17, 2012
develop RS2000 report through V Studio.NET 2005
Hi all, is it possible to create RS2000 format reports through Visual Studio
.NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
reports as my ERP system only supports SQL server 2000.No. If you need to develop RS 2000 reports then you need some version of VS
2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
work with rhe RS 2000 report designer. RS 2005 comes with its own version of
VS and not purchase of VS is needed.
Also, note that RS 2005 can be installed using SQL Server 2000. However, as
I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> Hi all, is it possible to create RS2000 format reports through Visual
> Studio
> .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> reports as my ERP system only supports SQL server 2000.|||Bruce, thank you for your reply.
My problem is, I will not purchase SQL 2005 until my ERP system is going to
support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
need to use Studio .NET 2005 in near future.
Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
future, say half year?
Any suggestion?
"Bruce L-C [MVP]" wrote:
> No. If you need to develop RS 2000 reports then you need some version of VS
> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
> work with rhe RS 2000 report designer. RS 2005 comes with its own version of
> VS and not purchase of VS is needed.
> Also, note that RS 2005 can be installed using SQL Server 2000. However, as
> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> > Hi all, is it possible to create RS2000 format reports through Visual
> > Studio
> > .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> > reports as my ERP system only supports SQL server 2000.
>
>|||You do not need to buy anything expensive for the VS 2003 requirement. Just
get VB.Net 2003 ($100).
I don't know about upgrades.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:8E045A08-069B-4395-AAD8-7FC57055B66A@.microsoft.com...
> Bruce, thank you for your reply.
> My problem is, I will not purchase SQL 2005 until my ERP system is going
> to
> support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
> need to use Studio .NET 2005 in near future.
> Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
> future, say half year?
> Any suggestion?
> "Bruce L-C [MVP]" wrote:
>> No. If you need to develop RS 2000 reports then you need some version of
>> VS
>> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will
>> not
>> work with rhe RS 2000 report designer. RS 2005 comes with its own version
>> of
>> VS and not purchase of VS is needed.
>> Also, note that RS 2005 can be installed using SQL Server 2000. However,
>> as
>> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
>> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
>> > Hi all, is it possible to create RS2000 format reports through Visual
>> > Studio
>> > .NET 2005? I am going to purchase Visual Studio .NET for developing
>> > RS2000
>> > reports as my ERP system only supports SQL server 2000.
>>
.NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
reports as my ERP system only supports SQL server 2000.No. If you need to develop RS 2000 reports then you need some version of VS
2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
work with rhe RS 2000 report designer. RS 2005 comes with its own version of
VS and not purchase of VS is needed.
Also, note that RS 2005 can be installed using SQL Server 2000. However, as
I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> Hi all, is it possible to create RS2000 format reports through Visual
> Studio
> .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> reports as my ERP system only supports SQL server 2000.|||Bruce, thank you for your reply.
My problem is, I will not purchase SQL 2005 until my ERP system is going to
support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
need to use Studio .NET 2005 in near future.
Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
future, say half year?
Any suggestion?
"Bruce L-C [MVP]" wrote:
> No. If you need to develop RS 2000 reports then you need some version of VS
> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will not
> work with rhe RS 2000 report designer. RS 2005 comes with its own version of
> VS and not purchase of VS is needed.
> Also, note that RS 2005 can be installed using SQL Server 2000. However, as
> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
> > Hi all, is it possible to create RS2000 format reports through Visual
> > Studio
> > .NET 2005? I am going to purchase Visual Studio .NET for developing RS2000
> > reports as my ERP system only supports SQL server 2000.
>
>|||You do not need to buy anything expensive for the VS 2003 requirement. Just
get VB.Net 2003 ($100).
I don't know about upgrades.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
news:8E045A08-069B-4395-AAD8-7FC57055B66A@.microsoft.com...
> Bruce, thank you for your reply.
> My problem is, I will not purchase SQL 2005 until my ERP system is going
> to
> support SQL 2005. But I do not want to purchase Studio .NET 2003 because I
> need to use Studio .NET 2005 in near future.
> Can I buy Studio .NET 2003 now and upgrade to .NET 2005 for free in near
> future, say half year?
> Any suggestion?
> "Bruce L-C [MVP]" wrote:
>> No. If you need to develop RS 2000 reports then you need some version of
>> VS
>> 2003 (VB.Net 2003 is the cheapest option). DO NOT buy VS 2005. That will
>> not
>> work with rhe RS 2000 report designer. RS 2005 comes with its own version
>> of
>> VS and not purchase of VS is needed.
>> Also, note that RS 2005 can be installed using SQL Server 2000. However,
>> as
>> I mentioned, RS 2005 only creates 2005 reports, not 2000 reports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Eric Wang" <EricWang@.discussions.microsoft.com> wrote in message
>> news:1B5711D1-D3B3-4C93-AC34-5058A5BF0942@.microsoft.com...
>> > Hi all, is it possible to create RS2000 format reports through Visual
>> > Studio
>> > .NET 2005? I am going to purchase Visual Studio .NET for developing
>> > RS2000
>> > reports as my ERP system only supports SQL server 2000.
>>
develop reports(public on report server 1.0) in vs2005 ?
as title,is anyway to translate two different format rdl files?
thx !
thank you.
thx !
I'm not 100% sure I understand your question, but I think you are asking if you can create reports using Visual Studio 2005 that will run under SSRS 2000: Please correct me if I've misunderstood.
The answer to your question is "no". SSRS 2005 uses an updated RDL schema that 2000 doesn't understand. If you use VS 2005 to create a report, you use the updated schema, therefore 2000 won't work.
I've started a list of these questions / answers at the following location if you want to contribute and/or read:
http://blogs.msdn.com/bimusings/archive/2005/12/13/503110.aspx
|||
thank you.
But translate between two schema is possible ,right?
Hope some experient program such tool:).
thanks again and your blog.
|||By the way,ask the other question.
I need develop rs2000's report.but after i install vs2005,i cant do it again in vs2003,something is broken and raise error.
can i develop rs2000's report with vs2005 installed environment? how?
thanks very much!
|||A translation between the 2003/10 RDL namespace and the 2005/01 RDL namespace is done for instance automatically by loading a report in report designer and saving it. It is performed implicitly when uploading a report on a RS 2005 report server.
A translation from 2005/01 back to 2003/10 is doable (e.g. with a XSLT), but I'm not aware of any publicly available tool at this point. There are not many differences between the 2003/10 and the 2005/01 RDL schemas - you can look at the specs at: http://www.microsoft.com/sql/technologies/reporting/rdlspec.mspx
You can also download the XSDs at:
http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition/reportdefinition.xsd
http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition/ReportDefinition.xsd
-- Robert
Develop multiusers applications with SQL Server Express
Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?
SQL Server Express will support multiple users. To connect from other computers you must first enable "Local and remote connections" in the Surface Area configuration tool .
Karl
|||You should also read the Blog entry at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx. You may need to enable SQL Browser and create Excpetions in your Firewall to allow people to connect to your SQL Express server. It all depends on the configuration of your computer and how you want to connect.
Regards,
Mike Wachal
SQL Express
Develop in VS2005 and deployment to SQL 2000
I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/report...y/default.mspx.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> glsD:%23AjCbjKzF
HA.1092@.TK2MSFTNGP10.phx.gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/report...y/default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
> glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> gl
sD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/report...y/default.mspx.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> glsD:%23AjCbjKzF
HA.1092@.TK2MSFTNGP10.phx.gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/report...y/default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
> glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> gl
sD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>
Develop in VS2005 and deployment to SQL 2000
I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?
If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporti.../default.mspx.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>
|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporti.../default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>
|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si >
> glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>
|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?
If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporti.../default.mspx.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>
|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporti.../default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>
|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si >
> glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>
|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > glsD:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx .gbl...
>
Develop in VS2005 and deployment to SQL 2000
I find I can use VS2005 to develop reports of Reporting Service and the
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>
datasource of reports is from SQL2000.
Can I develop these report to SQL2000 after I developed?If you get Reporting Services, you will get Report Designer as a template in
VS.NET. Check how to obtain RS at
http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>I find I can use VS2005 to develop reports of Reporting Service and the
>datasource of reports is from SQL2000.
> Can I develop these report to SQL2000 after I developed?
>|||Thanks,
I have licence of SQL Server Standard, there is no problem about licence.
My problem is technique issue.
If the report is desgined in VS2005, then I deployment it to Sql2000, will
it be OK?
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
> If you get Reporting Services, you will get Report Designer as a template
> in VS.NET. Check how to obtain RS at
> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
> --
> Dejan Sarka, SQL Server MVP
> Mentor
> www.SolidQualityLearning.com
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>|||Hi
No. The file format has changed and AFAIK, you can not tell it at design
time what version you are building for.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:un%23yFqKzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> Thanks,
> I have licence of SQL Server Standard, there is no problem about licence.
> My problem is technique issue.
> If the report is desgined in VS2005, then I deployment it to Sql2000, will
> it be OK?
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si>
> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>|||Hi,
I have read your question a couple of times and am unsure if you are
referring to the server-based Reporting Services or the new report
controls which are included in Visual Studio 2005.
If you want to use server-based Reporting Services then I believe
Mike's answer is correct, since the RDL format has changed between
RS2000 and RS2005.
If you want to use the new report controls, which don't depend on
server-based Reporting Services, I think you are likely to be ok. I
should mention that it's a scenario I haven't tested personally.
Andrew Watt
MVP - InfoPath
On Sun, 9 Oct 2005 16:21:50 +0800, "ad" <flying@.wfes.tcc.edu.tw>
wrote:
>Thanks,
>I have licence of SQL Server Standard, there is no problem about licence.
>My problem is technique issue.
>If the report is desgined in VS2005, then I deployment it to Sql2000, will
>it be OK?
>
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> ¼¶¼g©ó¶l¥ó·s»D:%23AjCbjKzFHA.1092@.TK2MSFTNGP10.phx.gbl...
>> If you get Reporting Services, you will get Report Designer as a template
>> in VS.NET. Check how to obtain RS at
>> http://www.microsoft.com/sql/reporting/howtobuy/default.mspx.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor
>> www.SolidQualityLearning.com
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:uxZSnyEzFHA.460@.TK2MSFTNGP15.phx.gbl...
>>I find I can use VS2005 to develop reports of Reporting Service and the
>>datasource of reports is from SQL2000.
>> Can I develop these report to SQL2000 after I developed?
>>
>>
>
Develop Database on Local machine? MSDE
Hi all
I am experiencing a problem comming to grip[s with MSDE and what it does.
I need to develop an SQL Server Database but i only have a Windos XP OS
and not a server type system.
From what i understand i should be able to use msde as the engine and
utilsie the tools that i can install with SQL SERVER eg enterprise manager.
To my way odf thinking that would enable me to develop a database with
out the need for a server OS.
If this is correct i am having trouble installing MSDE 2000 and using it
with enterprise manager. can some please put me on the right path.
I have used the MSDE with SQL Server but the service seems to stop and i
cant get it restarted, so i am beliveing i just dont have it setup
properly.
Please any docs or sites and advice sent my way will be greatly appreciated.
What is the best environment to develop with one PC?
Thanks in advance
Greg
hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
> Hi all
> I am experiencing a problem comming to grip[s with MSDE and what it does.
> I need to develop an SQL Server Database but i only have a Windos XP OS
> and not a server type system.
> From what i understand i should be able to use msde as the engine and
> utilsie the tools that i can install with SQL SERVER eg enterprise
manager.
> To my way odf thinking that would enable me to develop a database with
> out the need for a server OS.
> If this is correct i am having trouble installing MSDE 2000 and using it
> with enterprise manager. can some please put me on the right path.
> I have used the MSDE with SQL Server but the service seems to stop and i
> cant get it restarted, so i am beliveing i just dont have it setup
> properly.
> Please any docs or sites and advice sent my way will be greatly
appreciated.
> What is the best environment to develop with one PC?
WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
the latest solution, the Dev edition, shoul'd be the best one to go, both
for pricing and for tools... you have all the tools you (usually) need to
develop, test and tune your application(s), and then you cna bundle MSDE
with tem, as MSDE was really not intended for develping phase, even if it
can...
as regard your MSDE instance, it's not clear to me your inconvenient... does
it starts and then stops? or does it not start at all?
please check, in the services control panel applet, the account running SQL
Server and SQL Server Agent services...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi andrea
Thanks for your advice, the MSDE instance does start, but for a reason i
cannot find it stops and i cant seem to get it to restart, My only way
to get going again was to uninstall msde and reinstall. I have my
database saved
I have tried the 2000a version of MSDE but get very confused as a
service manager does not appear. so i have no idea on how to get things
going. The doco is more towards deploying than stting up on a local machine.
Can i ask if the developer version is in the Visual studio .net package?
as i might get this (still a student).
Or maybe your view on an ideal developer environment for SQL Server
(Oracle is so much easier) i intend doing the front end with VB
your help is greatly appreciated
regards
greg
Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
>
> manager.
>
> appreciated.
>
> WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
> Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
> the latest solution, the Dev edition, shoul'd be the best one to go, both
> for pricing and for tools... you have all the tools you (usually) need to
> develop, test and tune your application(s), and then you cna bundle MSDE
> with tem, as MSDE was really not intended for develping phase, even if it
> can...
> as regard your MSDE instance, it's not clear to me your inconvenient... does
> it starts and then stops? or does it not start at all?
> please check, in the services control panel applet, the account running SQL
> Server and SQL Server Agent services...
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
> I have tried the 2000a version of MSDE but get very confused as a
> service manager does not appear. so i have no idea on how to get things
> going. The doco is more towards deploying than stting up on a local
machine.
if you set up MSDE without enabling network protocols, the installed
instance can not be shown in service manager combobox as reported in
http://support.microsoft.com/default...b;EN-US;814132
> Can i ask if the developer version is in the Visual studio .net package?
> as i might get this (still a student).
the Dev edition of SQL Server comes only in VS.Net enterprise package... the
other VS.Net editions only provides MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
>
> machine.
> if you set up MSDE without enabling network protocols, the installed
> instance can not be shown in service manager combobox as reported in
> http://support.microsoft.com/default...b;EN-US;814132
>
>
> the Dev edition of SQL Server comes only in VS.Net enterprise package... the
> other VS.Net editions only provides MSDE...
Hi andrea
Thanks for your reply, after a long night last night i worked it all
out, i had to actually go to the services window and physically start
service manager, somehow it was set to manual.
Now i have another issue, when i create a database i get a suspect next
to the DB and and an error 5105 "database already exists".
i have searched long and hard on this issue and it seems to be one of
those things that a number of problems could be causing it. do you have
any sugestions.
regards
Greg
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:eszInS$VEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Now i have another issue, when i create a database i get a suspect next
> to the DB and and an error 5105 "database already exists".
> i have searched long and hard on this issue and it seems to be one of
> those things that a number of problems could be causing it. do you have
> any sugestions.
please have a look at Hugo answer in http://tinyurl.com/3ecnj ... it might
help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I am experiencing a problem comming to grip[s with MSDE and what it does.
I need to develop an SQL Server Database but i only have a Windos XP OS
and not a server type system.
From what i understand i should be able to use msde as the engine and
utilsie the tools that i can install with SQL SERVER eg enterprise manager.
To my way odf thinking that would enable me to develop a database with
out the need for a server OS.
If this is correct i am having trouble installing MSDE 2000 and using it
with enterprise manager. can some please put me on the right path.
I have used the MSDE with SQL Server but the service seems to stop and i
cant get it restarted, so i am beliveing i just dont have it setup
properly.
Please any docs or sites and advice sent my way will be greatly appreciated.
What is the best environment to develop with one PC?
Thanks in advance
Greg
hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
> Hi all
> I am experiencing a problem comming to grip[s with MSDE and what it does.
> I need to develop an SQL Server Database but i only have a Windos XP OS
> and not a server type system.
> From what i understand i should be able to use msde as the engine and
> utilsie the tools that i can install with SQL SERVER eg enterprise
manager.
> To my way odf thinking that would enable me to develop a database with
> out the need for a server OS.
> If this is correct i am having trouble installing MSDE 2000 and using it
> with enterprise manager. can some please put me on the right path.
> I have used the MSDE with SQL Server but the service seems to stop and i
> cant get it restarted, so i am beliveing i just dont have it setup
> properly.
> Please any docs or sites and advice sent my way will be greatly
appreciated.
> What is the best environment to develop with one PC?
WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
the latest solution, the Dev edition, shoul'd be the best one to go, both
for pricing and for tools... you have all the tools you (usually) need to
develop, test and tune your application(s), and then you cna bundle MSDE
with tem, as MSDE was really not intended for develping phase, even if it
can...
as regard your MSDE instance, it's not clear to me your inconvenient... does
it starts and then stops? or does it not start at all?
please check, in the services control panel applet, the account running SQL
Server and SQL Server Agent services...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi andrea
Thanks for your advice, the MSDE instance does start, but for a reason i
cannot find it stops and i cant seem to get it to restart, My only way
to get going again was to uninstall msde and reinstall. I have my
database saved
I have tried the 2000a version of MSDE but get very confused as a
service manager does not appear. so i have no idea on how to get things
going. The doco is more towards deploying than stting up on a local machine.
Can i ask if the developer version is in the Visual studio .net package?
as i might get this (still a student).
Or maybe your view on an ideal developer environment for SQL Server
(Oracle is so much easier) i intend doing the front end with VB
your help is greatly appreciated
regards
greg
Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:OQClCBnVEHA.2408@.tk2msftngp13.phx.gbl...
>
> manager.
>
> appreciated.
>
> WinXP is fine, and you cna install on it bot MSDE and/or SQL Server Desktop
> Edition or SQL Server Developer edition, now priced at $49.00 =;-D.
> the latest solution, the Dev edition, shoul'd be the best one to go, both
> for pricing and for tools... you have all the tools you (usually) need to
> develop, test and tune your application(s), and then you cna bundle MSDE
> with tem, as MSDE was really not intended for develping phase, even if it
> can...
> as regard your MSDE instance, it's not clear to me your inconvenient... does
> it starts and then stops? or does it not start at all?
> please check, in the services control panel applet, the account running SQL
> Server and SQL Server Agent services...
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
> I have tried the 2000a version of MSDE but get very confused as a
> service manager does not appear. so i have no idea on how to get things
> going. The doco is more towards deploying than stting up on a local
machine.
if you set up MSDE without enabling network protocols, the installed
instance can not be shown in service manager combobox as reported in
http://support.microsoft.com/default...b;EN-US;814132
> Can i ask if the developer version is in the Visual studio .net package?
> as i might get this (still a student).
the Dev edition of SQL Server comes only in VS.Net enterprise package... the
other VS.Net editions only provides MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea Montanari wrote:
> hi Greg,
> "oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
> news:%23OdPlByVEHA.1164@.tk2msftngp13.phx.gbl...
>
> machine.
> if you set up MSDE without enabling network protocols, the installed
> instance can not be shown in service manager combobox as reported in
> http://support.microsoft.com/default...b;EN-US;814132
>
>
> the Dev edition of SQL Server comes only in VS.Net enterprise package... the
> other VS.Net editions only provides MSDE...
Hi andrea
Thanks for your reply, after a long night last night i worked it all
out, i had to actually go to the services window and physically start
service manager, somehow it was set to manual.
Now i have another issue, when i create a database i get a suspect next
to the DB and and an error 5105 "database already exists".
i have searched long and hard on this issue and it seems to be one of
those things that a number of problems could be causing it. do you have
any sugestions.
regards
Greg
|||hi Greg,
"oldgradgreg" <oldgradgreg@.netscape.net> ha scritto nel messaggio
news:eszInS$VEHA.3368@.TK2MSFTNGP10.phx.gbl...
> Now i have another issue, when i create a database i get a suspect next
> to the DB and and an error 5105 "database already exists".
> i have searched long and hard on this issue and it seems to be one of
> those things that a number of problems could be causing it. do you have
> any sugestions.
please have a look at Hugo answer in http://tinyurl.com/3ecnj ... it might
help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Dev cube on 32-bit, production on 64?
Please help me confirm that the following scenario is reasonable.
I believe that I can develop an SSAS DB and cube on SQL 2005 "Dev/32 bit" and deploy dev builds locally using BIDS, and then deploy a production version, still using my local BIDS, straight to the "Production/64 bit" server (with same SP).
Am I correct that this will work and is a standard approach? Are there any obvious gotchas I should know about?
Thanks very much.
Daniel Upton
Yes this will work, and this approach is used by many users.
Subscribe to:
Posts (Atom)