Showing posts with label version. Show all posts
Showing posts with label version. Show all posts

Friday, March 23, 2012

Minimum version of Visual Studio.NET

What is the minimum requirement or version of Visual Studio.NET
necessary for editing reports when running Reporting Services. I am
running on a SQL 2000 sp3 and Windows 2003 server.Anything that comes with VS.2003 (It cannot be VS 2005). The cheapest is
VB.Net
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"refdk" <fuhlendorf@.gmail.com> wrote in message
news:1140804364.362272.141300@.z34g2000cwc.googlegroups.com...
> What is the minimum requirement or version of Visual Studio.NET
> necessary for editing reports when running Reporting Services. I am
> running on a SQL 2000 sp3 and Windows 2003 server.
>|||Thanks, I will try that :-)
/Ren=E9

Wednesday, March 21, 2012

Minimal install possible?

The smallest downloadable version seems to be 53MB. Is there any way to create a smaller version to use as an embedded DB for an application? I only need it to be single-user, for what that's worth. I'm thinking more in the 10MB to 20MB range.to my knowledge NO and the SQLExpress team made every effort to ensure the smallest D/Ls possible.|||

You have an option to use SQL Server 2005 Everywhere edition. It has to be run in-process and won't run as a service (however, I think it might be possible to create your own windows service where you embed SQL Server Everywhere). It only uses a few MB HD space, and uses about 5 MB RAM. Available at http://www.microsoft.com/sql/ctp_sqlserver2005everywhereedition.mspx, though only in CTP. Scheduled for release at the end of 2006.

Best regards

Bj?rnar Sundsb?

Minimal install possible?

The smallest downloadable version seems to be 53MB. Is there any way to create a smaller version to use as an embedded DB for an application? I only need it to be single-user, for what that's worth. I'm thinking more in the 10MB to 20MB range.to my knowledge NO and the SQLExpress team made every effort to ensure the smallest D/Ls possible.|||

You have an option to use SQL Server 2005 Everywhere edition. It has to be run in-process and won't run as a service (however, I think it might be possible to create your own windows service where you embed SQL Server Everywhere). It only uses a few MB HD space, and uses about 5 MB RAM. Available at http://www.microsoft.com/sql/ctp_sqlserver2005everywhereedition.mspx, though only in CTP. Scheduled for release at the end of 2006.

Best regards

Bj?rnar Sundsb?

Friday, March 9, 2012

Migration Problems: 7 to 2000

Not surprisingly, SQL Server 2000 seems to do some things differently than did version 7. In general, it seems to be less forgiving of sloppiness, such that queries that probably shouldn't have worked in 7 (but did) no longer work in 2000.

I've found at least three such things:
1) Default sort is different.
2) Concatenating a varchar column that contains a value with a column containing a null now produces a null.
3) I may have some old stored procs held over from 6.5 or something. They checked a bit column for -1. These worked in SQL 7. Even though the column actually contained a 1. They no longer work in 2000.

My question is this: Is there anywhere I can go to find a list of these differences, so I can make preventive changes to my SP's before I move them to 2000? Or do I just have to move them and fix the problems as they occur?I would start with this...

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_da-di_5c8c.asp?frame=true|||Thanks! That's just the kind of thing I was looking for.

Wednesday, March 7, 2012

Migration of Crystal Report 7.4 to version 11.0

Hi,
Is it possible to migrate the crystal reports developed in version 7.4 to version 11.0 directly?
Please let me know if any one knows.
Thanks and Regards,
AmitYou shouldn't have any issue. This is what BO has to say on the issue:

Crystal Reports XI, 10, and 9 support Unicode. Earlier versions of Crystal Reports do not support Unicode. Therefore, once an RPT file has been saved in Crystal Reports XI, 10, or 9 the RPT cannot be opened in Crystal Reports 8.5 or earlier.

I have brought over v8.0 reports to CR XI and didn't have any issues.

Brian
http://www.briankuipers.com

Saturday, February 25, 2012

migration from Beta 2 to Final edition

Will you please let me know how to have a smooth and NO DOWNTIME migration
from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
version does not upgrade itself from Beta 2.
Thanks
John
I don't think there's any way to do a "smooth" migration. You cannot do an
in-place upgrade, so you'll have to do a side-by-side migration. I'm not
certain whether backed-up Beta 2 databases will restore on an RTM instance.
That's something you'll have to test on your end. Have you listened to any
of the migration webcasts? They discuss how to do side-by-side migrations
somewhat smoothly -- but no downtime might not be possible, depending on
your definition of that term.
Speaking of which, if you are running Beta 2 in production can we assume
that you're a TAP customer? Ask Microsoft for assistance.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"John" <netconsul@.gmail.com> wrote in message
news:OX$3NSc9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Will you please let me know how to have a smooth and NO DOWNTIME migration
> from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
> version does not upgrade itself from Beta 2.
> Thanks
> John
>

migration from Beta 2 to Final edition

Will you please let me know how to have a smooth and NO DOWNTIME migration
from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
version does not upgrade itself from Beta 2.
Thanks
JohnI don't think there's any way to do a "smooth" migration. You cannot do an
in-place upgrade, so you'll have to do a side-by-side migration. I'm not
certain whether backed-up Beta 2 databases will restore on an RTM instance.
That's something you'll have to test on your end. Have you listened to any
of the migration webcasts? They discuss how to do side-by-side migrations
somewhat smoothly -- but no downtime might not be possible, depending on
your definition of that term.
Speaking of which, if you are running Beta 2 in production can we assume
that you're a TAP customer? Ask Microsoft for assistance.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"John" <netconsul@.gmail.com> wrote in message
news:OX$3NSc9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Will you please let me know how to have a smooth and NO DOWNTIME migration
> from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
> version does not upgrade itself from Beta 2.
> Thanks
> John
>

migration from Beta 2 to Final edition

Will you please let me know how to have a smooth and NO DOWNTIME migration
from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
version does not upgrade itself from Beta 2.
Thanks
JohnI don't think there's any way to do a "smooth" migration. You cannot do an
in-place upgrade, so you'll have to do a side-by-side migration. I'm not
certain whether backed-up Beta 2 databases will restore on an RTM instance.
That's something you'll have to test on your end. Have you listened to any
of the migration webcasts? They discuss how to do side-by-side migrations
somewhat smoothly -- but no downtime might not be possible, depending on
your definition of that term.
Speaking of which, if you are running Beta 2 in production can we assume
that you're a TAP customer? Ask Microsoft for assistance.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"John" <netconsul@.gmail.com> wrote in message
news:OX$3NSc9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Will you please let me know how to have a smooth and NO DOWNTIME migration
> from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
> version does not upgrade itself from Beta 2.
> Thanks
> John
>

Monday, February 20, 2012

Migrating to Sql25k

We’ve got hundreds of branch which are working with MSDE. As we are moving sql25k, what the ideal version would be adviceable to install there? Sql Express?

How to handle this? I have a fuss on my head because of there are many vesions available.

Thanks in advance for any comment or further information,

Yes, SQLExpress is the succesor to MSDE however "Express" is a much better core database engine as it support more hardware, less restrictions (including the fabled 5 connection limit of MSDE) etc.

Here is a link that lists out the differences between versions:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

And as far as the actual upgrade process you could perform either direct "inplace" upgrades or using named instances perform a slower migration. Either way backup everything!

Derek

|||Thank you|||

enric, could you please mark an answer. And your welcome.

thanks,

Derek