Compare/Sync functions and plug-ins

I have two questions.

Q1 : (Note: I had posted a similar query in Data Dude (Visual Studio Team System for DB Professionals) forums and got an answer (nothing conclusive though). Given the context, thought this will also be a good forum to run the post). Onto my question :

Data Dude has Compare and Synchronization functionality for SQL Server. Are there any plans to integrate the same as part of SQL Server Management Studio ? We DBAs work only with SSMS and not Visual Studio. Are there any near term/long terms plans in this direction ?

My original post in Data Dude forums can be found here :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1016505&SiteID=1

Q2 : I came across this thread which discusses about developing Plug-ins for Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=192769&SiteID=1
Any approximate time line by which we can expect this ?

Appreciate your response.

Krish

I believe it will be good if you have upadted the same on http://connect.microsoft.com/ with the requirement, as they are monitored on daily basis and your request might be considered in future releases of Service pack.

sqlsql

compare two text files

Dear all,

What software can compare two text files? They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily. Please give me some suggestions. Thanks.

Alex

I think VSS (source safe) is suitable for that|||

thanks Eisa. it is helpful.

Could you suggest some freewares?

|||Hi Alex,
I don't know if it is allowed to share free software here or not, howere you can serach google for compare text files free|||Thank your for your help|||Windows has a command line utility (fc) that compares two files. Type "fc /?" at a command prompt, and it will list the options/switches. It's a good solution if it has the features you need, because it's built into Windows, and you won't have to bother installing it everywhere you need it. If you want to use it in a job, you can invoke it with an operating system type step, or use xp_cmdshell if you need to call it after dynamically building the command at run-time. In a job, you would have to pipe the results to another text file, for review.|||

CompareIt! - cool

http://www.grigsoft.com/

|||thanks a lot

compare two text files

Dear all,

What software can compare two text files? They are contains about 100k data generated from Visual Basic 6.0 program and MS SQL 2000. I have many files to compare daily. Please give me some suggestions. Thanks.

Alex

I think VSS (source safe) is suitable for that|||

thanks Eisa. it is helpful.

Could you suggest some freewares?

|||Hi Alex,
I don't know if it is allowed to share free software here or not, howere you can serach google for compare text files free|||Thank your for your help|||Windows has a command line utility (fc) that compares two files. Type "fc /?" at a command prompt, and it will list the options/switches. It's a good solution if it has the features you need, because it's built into Windows, and you won't have to bother installing it everywhere you need it. If you want to use it in a job, you can invoke it with an operating system type step, or use xp_cmdshell if you need to call it after dynamically building the command at run-time. In a job, you would have to pipe the results to another text file, for review.|||

CompareIt! - cool

http://www.grigsoft.com/

|||thanks a lot

compability of visual studio express vs visual studio

Can anyone tell me if Visual Studio Express and Visual Studio Report Designer
are compatible when designing reports? We tried to import .RDL files between
the two and were unsuccessful.
Our intent is to give our user something like Visual Studio Express to
develop reports , but yet be flexiable enough to maintain them or enhance
them using the full Visual Studio version. Or, take a report done in the full
version and allow he user to modify it in the Visual Studio Express version.
I highly doubt this is possible but I need some outside opinions on this.
Thanks for your time,
Dave SundellNone of this is necessary if you are using RS 2005. It comes with its own
version of VS. It will integrate with it if you have it, otherwise it will
install its own. If you are not writing your own assemblies then no need for
buying VS. This is a change from RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> Can anyone tell me if Visual Studio Express and Visual Studio Report
> Designer
> are compatible when designing reports? We tried to import .RDL files
> between
> the two and were unsuccessful.
> Our intent is to give our user something like Visual Studio Express to
> develop reports , but yet be flexiable enough to maintain them or enhance
> them using the full Visual Studio version. Or, take a report done in the
> full
> version and allow he user to modify it in the Visual Studio Express
> version.
> I highly doubt this is possible but I need some outside opinions on this.
> Thanks for your time,
> Dave Sundell|||Are you talking about Report Builder in RS 2005?
I need users to beable to modify reports that were designed/developed using
Report Designer. And visa versa, beable to modify reports that were done with
Vistual Studio Express and edit them in full Visual Stduio.
I suppose we can buy them a full version of Visual Studio but some asked me
to look into Visual Studio Express. I am installing it now in a Virtual PC
mode as to not mess my normal Visual Studio environment.
Back to Report Builder. I am sorry but it is not the same as Report Designer
and we have had user experienced in Crystal reports and we need to give them
something a little closer, like Report Designer. But we were pointed towards
Visual Studio Express as a solution.
"Bruce L-C [MVP]" wrote:
> None of this is necessary if you are using RS 2005. It comes with its own
> version of VS. It will integrate with it if you have it, otherwise it will
> install its own. If you are not writing your own assemblies then no need for
> buying VS. This is a change from RS 2000.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> > Designer
> > are compatible when designing reports? We tried to import .RDL files
> > between
> > the two and were unsuccessful.
> >
> > Our intent is to give our user something like Visual Studio Express to
> > develop reports , but yet be flexiable enough to maintain them or enhance
> > them using the full Visual Studio version. Or, take a report done in the
> > full
> > version and allow he user to modify it in the Visual Studio Express
> > version.
> >
> > I highly doubt this is possible but I need some outside opinions on this.
> >
> > Thanks for your time,
> >
> > Dave Sundell
>
>|||No, I am talking about Report Designer not Report Builder. RS 2005 when it
installed BI (or whatever it calls it, when you install Report Designer) it
will integrate with VS 2005 if you have it, otherwise it installs a special
version just for RS 2005 Report Designer.
This was not the case with RS 2000 report designer. For that you first had
to have VS 2003. Again, that is not the case for RS 2005 report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> Are you talking about Report Builder in RS 2005?
> I need users to beable to modify reports that were designed/developed
> using
> Report Designer. And visa versa, beable to modify reports that were done
> with
> Vistual Studio Express and edit them in full Visual Stduio.
> I suppose we can buy them a full version of Visual Studio but some asked
> me
> to look into Visual Studio Express. I am installing it now in a Virtual PC
> mode as to not mess my normal Visual Studio environment.
> Back to Report Builder. I am sorry but it is not the same as Report
> Designer
> and we have had user experienced in Crystal reports and we need to give
> them
> something a little closer, like Report Designer. But we were pointed
> towards
> Visual Studio Express as a solution.
>
> "Bruce L-C [MVP]" wrote:
>> None of this is necessary if you are using RS 2005. It comes with its own
>> version of VS. It will integrate with it if you have it, otherwise it
>> will
>> install its own. If you are not writing your own assemblies then no need
>> for
>> buying VS. This is a change from RS 2000.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> > Can anyone tell me if Visual Studio Express and Visual Studio Report
>> > Designer
>> > are compatible when designing reports? We tried to import .RDL files
>> > between
>> > the two and were unsuccessful.
>> >
>> > Our intent is to give our user something like Visual Studio Express to
>> > develop reports , but yet be flexiable enough to maintain them or
>> > enhance
>> > them using the full Visual Studio version. Or, take a report done in
>> > the
>> > full
>> > version and allow he user to modify it in the Visual Studio Express
>> > version.
>> >
>> > I highly doubt this is possible but I need some outside opinions on
>> > this.
>> >
>> > Thanks for your time,
>> >
>> > Dave Sundell
>>|||Ist it free to anyone or if do you need a license. Is it a download or can
we allow any person to install from a SQL Server 2005 cd?
By the way, thanks for your response/time.
dave
"Bruce L-C [MVP]" wrote:
> No, I am talking about Report Designer not Report Builder. RS 2005 when it
> installed BI (or whatever it calls it, when you install Report Designer) it
> will integrate with VS 2005 if you have it, otherwise it installs a special
> version just for RS 2005 Report Designer.
> This was not the case with RS 2000 report designer. For that you first had
> to have VS 2003. Again, that is not the case for RS 2005 report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> > Are you talking about Report Builder in RS 2005?
> >
> > I need users to beable to modify reports that were designed/developed
> > using
> > Report Designer. And visa versa, beable to modify reports that were done
> > with
> > Vistual Studio Express and edit them in full Visual Stduio.
> >
> > I suppose we can buy them a full version of Visual Studio but some asked
> > me
> > to look into Visual Studio Express. I am installing it now in a Virtual PC
> > mode as to not mess my normal Visual Studio environment.
> >
> > Back to Report Builder. I am sorry but it is not the same as Report
> > Designer
> > and we have had user experienced in Crystal reports and we need to give
> > them
> > something a little closer, like Report Designer. But we were pointed
> > towards
> > Visual Studio Express as a solution.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> None of this is necessary if you are using RS 2005. It comes with its own
> >> version of VS. It will integrate with it if you have it, otherwise it
> >> will
> >> install its own. If you are not writing your own assemblies then no need
> >> for
> >> buying VS. This is a change from RS 2000.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> >> > Designer
> >> > are compatible when designing reports? We tried to import .RDL files
> >> > between
> >> > the two and were unsuccessful.
> >> >
> >> > Our intent is to give our user something like Visual Studio Express to
> >> > develop reports , but yet be flexiable enough to maintain them or
> >> > enhance
> >> > them using the full Visual Studio version. Or, take a report done in
> >> > the
> >> > full
> >> > version and allow he user to modify it in the Visual Studio Express
> >> > version.
> >> >
> >> > I highly doubt this is possible but I need some outside opinions on
> >> > this.
> >> >
> >> > Thanks for your time,
> >> >
> >> > Dave Sundell
> >>
> >>
> >>
>
>|||It is free. RS 2005 is licensed by the server. There is no cost/licensing
for the report designer. Just use the SQL 2005 CD and install Report
Designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> Ist it free to anyone or if do you need a license. Is it a download or
> can
> we allow any person to install from a SQL Server 2005 cd?
> By the way, thanks for your response/time.
> dave
> "Bruce L-C [MVP]" wrote:
>> No, I am talking about Report Designer not Report Builder. RS 2005 when
>> it
>> installed BI (or whatever it calls it, when you install Report Designer)
>> it
>> will integrate with VS 2005 if you have it, otherwise it installs a
>> special
>> version just for RS 2005 Report Designer.
>> This was not the case with RS 2000 report designer. For that you first
>> had
>> to have VS 2003. Again, that is not the case for RS 2005 report designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
>> > Are you talking about Report Builder in RS 2005?
>> >
>> > I need users to beable to modify reports that were designed/developed
>> > using
>> > Report Designer. And visa versa, beable to modify reports that were
>> > done
>> > with
>> > Vistual Studio Express and edit them in full Visual Stduio.
>> >
>> > I suppose we can buy them a full version of Visual Studio but some
>> > asked
>> > me
>> > to look into Visual Studio Express. I am installing it now in a Virtual
>> > PC
>> > mode as to not mess my normal Visual Studio environment.
>> >
>> > Back to Report Builder. I am sorry but it is not the same as Report
>> > Designer
>> > and we have had user experienced in Crystal reports and we need to give
>> > them
>> > something a little closer, like Report Designer. But we were pointed
>> > towards
>> > Visual Studio Express as a solution.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> None of this is necessary if you are using RS 2005. It comes with its
>> >> own
>> >> version of VS. It will integrate with it if you have it, otherwise it
>> >> will
>> >> install its own. If you are not writing your own assemblies then no
>> >> need
>> >> for
>> >> buying VS. This is a change from RS 2000.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
>> >> > Designer
>> >> > are compatible when designing reports? We tried to import .RDL files
>> >> > between
>> >> > the two and were unsuccessful.
>> >> >
>> >> > Our intent is to give our user something like Visual Studio Express
>> >> > to
>> >> > develop reports , but yet be flexiable enough to maintain them or
>> >> > enhance
>> >> > them using the full Visual Studio version. Or, take a report done in
>> >> > the
>> >> > full
>> >> > version and allow he user to modify it in the Visual Studio Express
>> >> > version.
>> >> >
>> >> > I highly doubt this is possible but I need some outside opinions on
>> >> > this.
>> >> >
>> >> > Thanks for your time,
>> >> >
>> >> > Dave Sundell
>> >>
>> >>
>> >>
>>|||I discovered my problem. I forgot that I was sharing a report from Visual
Studio 2003 with Visual Studio Express and visa versa. Once I shared between
Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
I will look at Report Designer. Is that a simlar environment as Visual
Studio Express?
Dave
"Bruce L-C [MVP]" wrote:
> It is free. RS 2005 is licensed by the server. There is no cost/licensing
> for the report designer. Just use the SQL 2005 CD and install Report
> Designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> > Ist it free to anyone or if do you need a license. Is it a download or
> > can
> > we allow any person to install from a SQL Server 2005 cd?
> >
> > By the way, thanks for your response/time.
> >
> > dave
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, I am talking about Report Designer not Report Builder. RS 2005 when
> >> it
> >> installed BI (or whatever it calls it, when you install Report Designer)
> >> it
> >> will integrate with VS 2005 if you have it, otherwise it installs a
> >> special
> >> version just for RS 2005 Report Designer.
> >>
> >> This was not the case with RS 2000 report designer. For that you first
> >> had
> >> to have VS 2003. Again, that is not the case for RS 2005 report designer.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> >> > Are you talking about Report Builder in RS 2005?
> >> >
> >> > I need users to beable to modify reports that were designed/developed
> >> > using
> >> > Report Designer. And visa versa, beable to modify reports that were
> >> > done
> >> > with
> >> > Vistual Studio Express and edit them in full Visual Stduio.
> >> >
> >> > I suppose we can buy them a full version of Visual Studio but some
> >> > asked
> >> > me
> >> > to look into Visual Studio Express. I am installing it now in a Virtual
> >> > PC
> >> > mode as to not mess my normal Visual Studio environment.
> >> >
> >> > Back to Report Builder. I am sorry but it is not the same as Report
> >> > Designer
> >> > and we have had user experienced in Crystal reports and we need to give
> >> > them
> >> > something a little closer, like Report Designer. But we were pointed
> >> > towards
> >> > Visual Studio Express as a solution.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> None of this is necessary if you are using RS 2005. It comes with its
> >> >> own
> >> >> version of VS. It will integrate with it if you have it, otherwise it
> >> >> will
> >> >> install its own. If you are not writing your own assemblies then no
> >> >> need
> >> >> for
> >> >> buying VS. This is a change from RS 2000.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> >> >> > Designer
> >> >> > are compatible when designing reports? We tried to import .RDL files
> >> >> > between
> >> >> > the two and were unsuccessful.
> >> >> >
> >> >> > Our intent is to give our user something like Visual Studio Express
> >> >> > to
> >> >> > develop reports , but yet be flexiable enough to maintain them or
> >> >> > enhance
> >> >> > them using the full Visual Studio version. Or, take a report done in
> >> >> > the
> >> >> > full
> >> >> > version and allow he user to modify it in the Visual Studio Express
> >> >> > version.
> >> >> >
> >> >> > I highly doubt this is possible but I need some outside opinions on
> >> >> > this.
> >> >> >
> >> >> > Thanks for your time,
> >> >> >
> >> >> > Dave Sundell
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||It is a version of VS just for hosting the Report Designer. Functionally no
difference. However, it only installs if you do not have VS 2005 installed.
If VS 2005 is there then it integrates with it. Also, I found out that if
you have installed Report Designer first and then VS 2005 that you will not
see Report Designer in it. If you want Report Designer integrated with VS
(for instance you have VB.Net 2005 installed) then install VB.Net 2005
first, then report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:760A572F-7A63-45F5-87B1-21AD05436FF2@.microsoft.com...
>I discovered my problem. I forgot that I was sharing a report from Visual
> Studio 2003 with Visual Studio Express and visa versa. Once I shared
> between
> Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
> I will look at Report Designer. Is that a simlar environment as Visual
> Studio Express?
> Dave
> "Bruce L-C [MVP]" wrote:
>> It is free. RS 2005 is licensed by the server. There is no cost/licensing
>> for the report designer. Just use the SQL 2005 CD and install Report
>> Designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
>> > Ist it free to anyone or if do you need a license. Is it a download or
>> > can
>> > we allow any person to install from a SQL Server 2005 cd?
>> >
>> > By the way, thanks for your response/time.
>> >
>> > dave
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> No, I am talking about Report Designer not Report Builder. RS 2005
>> >> when
>> >> it
>> >> installed BI (or whatever it calls it, when you install Report
>> >> Designer)
>> >> it
>> >> will integrate with VS 2005 if you have it, otherwise it installs a
>> >> special
>> >> version just for RS 2005 Report Designer.
>> >>
>> >> This was not the case with RS 2000 report designer. For that you first
>> >> had
>> >> to have VS 2003. Again, that is not the case for RS 2005 report
>> >> designer.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
>> >> > Are you talking about Report Builder in RS 2005?
>> >> >
>> >> > I need users to beable to modify reports that were
>> >> > designed/developed
>> >> > using
>> >> > Report Designer. And visa versa, beable to modify reports that were
>> >> > done
>> >> > with
>> >> > Vistual Studio Express and edit them in full Visual Stduio.
>> >> >
>> >> > I suppose we can buy them a full version of Visual Studio but some
>> >> > asked
>> >> > me
>> >> > to look into Visual Studio Express. I am installing it now in a
>> >> > Virtual
>> >> > PC
>> >> > mode as to not mess my normal Visual Studio environment.
>> >> >
>> >> > Back to Report Builder. I am sorry but it is not the same as Report
>> >> > Designer
>> >> > and we have had user experienced in Crystal reports and we need to
>> >> > give
>> >> > them
>> >> > something a little closer, like Report Designer. But we were pointed
>> >> > towards
>> >> > Visual Studio Express as a solution.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> None of this is necessary if you are using RS 2005. It comes with
>> >> >> its
>> >> >> own
>> >> >> version of VS. It will integrate with it if you have it, otherwise
>> >> >> it
>> >> >> will
>> >> >> install its own. If you are not writing your own assemblies then no
>> >> >> need
>> >> >> for
>> >> >> buying VS. This is a change from RS 2000.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio
>> >> >> > Report
>> >> >> > Designer
>> >> >> > are compatible when designing reports? We tried to import .RDL
>> >> >> > files
>> >> >> > between
>> >> >> > the two and were unsuccessful.
>> >> >> >
>> >> >> > Our intent is to give our user something like Visual Studio
>> >> >> > Express
>> >> >> > to
>> >> >> > develop reports , but yet be flexiable enough to maintain them or
>> >> >> > enhance
>> >> >> > them using the full Visual Studio version. Or, take a report done
>> >> >> > in
>> >> >> > the
>> >> >> > full
>> >> >> > version and allow he user to modify it in the Visual Studio
>> >> >> > Express
>> >> >> > version.
>> >> >> >
>> >> >> > I highly doubt this is possible but I need some outside opinions
>> >> >> > on
>> >> >> > this.
>> >> >> >
>> >> >> > Thanks for your time,
>> >> >> >
>> >> >> > Dave Sundell
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Bruce,
Thank you for your time and response to this matter.
In conclusion, I did install Report Designer and it seems to be a better
route then installing SQL Express since the user really doesn't need SQL
installed but simply the environment to design a report.
Thanks again.
"Bruce L-C [MVP]" wrote:
> It is a version of VS just for hosting the Report Designer. Functionally no
> difference. However, it only installs if you do not have VS 2005 installed.
> If VS 2005 is there then it integrates with it. Also, I found out that if
> you have installed Report Designer first and then VS 2005 that you will not
> see Report Designer in it. If you want Report Designer integrated with VS
> (for instance you have VB.Net 2005 installed) then install VB.Net 2005
> first, then report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:760A572F-7A63-45F5-87B1-21AD05436FF2@.microsoft.com...
> >I discovered my problem. I forgot that I was sharing a report from Visual
> > Studio 2003 with Visual Studio Express and visa versa. Once I shared
> > between
> > Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
> >
> > I will look at Report Designer. Is that a simlar environment as Visual
> > Studio Express?
> >
> > Dave
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> It is free. RS 2005 is licensed by the server. There is no cost/licensing
> >> for the report designer. Just use the SQL 2005 CD and install Report
> >> Designer.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> >> > Ist it free to anyone or if do you need a license. Is it a download or
> >> > can
> >> > we allow any person to install from a SQL Server 2005 cd?
> >> >
> >> > By the way, thanks for your response/time.
> >> >
> >> > dave
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> No, I am talking about Report Designer not Report Builder. RS 2005
> >> >> when
> >> >> it
> >> >> installed BI (or whatever it calls it, when you install Report
> >> >> Designer)
> >> >> it
> >> >> will integrate with VS 2005 if you have it, otherwise it installs a
> >> >> special
> >> >> version just for RS 2005 Report Designer.
> >> >>
> >> >> This was not the case with RS 2000 report designer. For that you first
> >> >> had
> >> >> to have VS 2003. Again, that is not the case for RS 2005 report
> >> >> designer.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> >> >> > Are you talking about Report Builder in RS 2005?
> >> >> >
> >> >> > I need users to beable to modify reports that were
> >> >> > designed/developed
> >> >> > using
> >> >> > Report Designer. And visa versa, beable to modify reports that were
> >> >> > done
> >> >> > with
> >> >> > Vistual Studio Express and edit them in full Visual Stduio.
> >> >> >
> >> >> > I suppose we can buy them a full version of Visual Studio but some
> >> >> > asked
> >> >> > me
> >> >> > to look into Visual Studio Express. I am installing it now in a
> >> >> > Virtual
> >> >> > PC
> >> >> > mode as to not mess my normal Visual Studio environment.
> >> >> >
> >> >> > Back to Report Builder. I am sorry but it is not the same as Report
> >> >> > Designer
> >> >> > and we have had user experienced in Crystal reports and we need to
> >> >> > give
> >> >> > them
> >> >> > something a little closer, like Report Designer. But we were pointed
> >> >> > towards
> >> >> > Visual Studio Express as a solution.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> None of this is necessary if you are using RS 2005. It comes with
> >> >> >> its
> >> >> >> own
> >> >> >> version of VS. It will integrate with it if you have it, otherwise
> >> >> >> it
> >> >> >> will
> >> >> >> install its own. If you are not writing your own assemblies then no
> >> >> >> need
> >> >> >> for
> >> >> >> buying VS. This is a change from RS 2000.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio
> >> >> >> > Report
> >> >> >> > Designer
> >> >> >> > are compatible when designing reports? We tried to import .RDL
> >> >> >> > files
> >> >> >> > between
> >> >> >> > the two and were unsuccessful.
> >> >> >> >
> >> >> >> > Our intent is to give our user something like Visual Studio
> >> >> >> > Express
> >> >> >> > to
> >> >> >> > develop reports , but yet be flexiable enough to maintain them or
> >> >> >> > enhance
> >> >> >> > them using the full Visual Studio version. Or, take a report done
> >> >> >> > in
> >> >> >> > the
> >> >> >> > full
> >> >> >> > version and allow he user to modify it in the Visual Studio
> >> >> >> > Express
> >> >> >> > version.
> >> >> >> >
> >> >> >> > I highly doubt this is possible but I need some outside opinions
> >> >> >> > on
> >> >> >> > this.
> >> >> >> >
> >> >> >> > Thanks for your time,
> >> >> >> >
> >> >> >> > Dave Sundell
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Committing data to SQL from a Visual Basic Form

I have novice level visual basic knowledge using Visual Studio 2005 and have little knowledge of SQL using SQL express. I am attempting to create a SQL database which initially consists of a single table bound to a Visual Basic form for data entry. So far I have been able to bind a VB form to a SQL database creating a DataSet, DataAdapter, and utilizing the default binding navigator. I also seem to have functioning Stored Procedures.

The VB form is able to add data to the SQL table and I can toggle through the data while the VB app is running but when I terminate the app and load it again all newly added data is not available from the SQL table.

I have seen other strings on this subject and viewed many tutorials but they only bring me as far as I am. None of them address the concept of permanently committing data to SQL from the VB form. FYI…data entered manually into the SQL table is stored, just not data from the form.

Does anyone have any idea what is wrong?

Are you using the user instance feature in SQL Server express ? Then you will have to set the "Copy" property to "Never" for the in your solution included datafile.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I am not clear on the instructions please clarify for the newbie.

Thanks.

|||If you are starting your program from inside visual basic the application is being rebuilt and the SQL database as created in visual basic is overwriting the database you created last time you ran your program. If you open your program from the bin\debug directory within your project folder, make changes to the data, exit the program, then go back into the program the same way, your database should have been updated with the changes.|||@.Bluebuddha: Did you find the setting ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Committing data to SQL from a Visual Basic Form

I have novice level visual basic knowledge using Visual Studio 2005 and have little knowledge of SQL using SQL express. I am attempting to create a SQL database which initially consists of a single table bound to a Visual Basic form for data entry. So far I have been able to bind a VB form to a SQL database creating a DataSet, DataAdapter, and utilizing the default binding navigator. I also seem to have functioning Stored Procedures.

The VB form is able to add data to the SQL table and I can toggle through the data while the VB app is running but when I terminate the app and load it again all newly added data is not available from the SQL table.

I have seen other strings on this subject and viewed many tutorials but they only bring me as far as I am. None of them address the concept of permanently committing data to SQL from the VB form. FYI…data entered manually into the SQL table is stored, just not data from the form.

Does anyone have any idea what is wrong?

Are you using the user instance feature in SQL Server express ? Then you will have to set the "Copy" property to "Never" for the in your solution included datafile.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I am not clear on the instructions please clarify for the newbie.

Thanks.

|||If you are starting your program from inside visual basic the application is being rebuilt and the SQL database as created in visual basic is overwriting the database you created last time you ran your program. If you open your program from the bin\debug directory within your project folder, make changes to the data, exit the program, then go back into the program the same way, your database should have been updated with the changes.|||@.Bluebuddha: Did you find the setting ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Committing data to SQL from a Visual Basic Form

I have novice level visual basic knowledge using Visual Studio 2005 and have little knowledge of SQL using SQL express. I am attempting to create a SQL database which initially consists of a single table bound to a Visual Basic form for data entry. So far I have been able to bind a VB form to a SQL database creating a DataSet, DataAdapter, and utilizing the default binding navigator. I also seem to have functioning Stored Procedures.

The VB form is able to add data to the SQL table and I can toggle through the data while the VB app is running but when I terminate the app and load it again all newly added data is not available from the SQL table.

I have seen other strings on this subject and viewed many tutorials but they only bring me as far as I am. None of them address the concept of permanently committing data to SQL from the VB form. FYI…data entered manually into the SQL table is stored, just not data from the form.

Does anyone have any idea what is wrong?

Are you using the user instance feature in SQL Server express ? Then you will have to set the "Copy" property to "Never" for the in your solution included datafile.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

I am not clear on the instructions please clarify for the newbie.

Thanks.

|||If you are starting your program from inside visual basic the application is being rebuilt and the SQL database as created in visual basic is overwriting the database you created last time you ran your program. If you open your program from the bin\debug directory within your project folder, make changes to the data, exit the program, then go back into the program the same way, your database should have been updated with the changes.|||@.Bluebuddha: Did you find the setting ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Comma Delimited Text File

Hi I'm pretty new to using Microsoft Visual C# .NET and I want to upload a comma delimited text file from my local machine into a table in an sql server database through a web app. How would I go about programming this and what controls do I need? Any help would be much appreciated. Thanks in advance.you can upload a file to the server...there are tons of articles that describe how you can do this.all you need to do is goooogle..now do you want to save the text file as it on the server and maintain a link in a table or do you want to parse the textfile and insert the records into a table ?|||I want to be able to parse the comma delimited textfile and insert the records into a table. Thanks.|||check out my blog i have an article ( under SQL Server 2000 ) tht has some sample code too..

hth|||

Hi,

Could you be able to point me to where is your blog link or the link to where the relate article for this topic. Really appreciate and thanks in advance.