Do I want the Developer version?

I've downloaded 2005 Express but I want to do SSIS and don't see any way to do that with Express. The Developer Edition apparently has all features, but says you can upgrade to Enterprise, which I don't need (Standard would probably be fine).

Here are my questions:

1) Is there any way to develop SSIS packages in Developer and run them in Express?

2) Is it possible to upgrade Developer to something less than Enterprise, such as Workgroup or Standard?

3) This page is titled "How to Obtain SQL Server 2005 Developer Ediiton" but doesn't explain how to obtain it. Instead it talks about which edition to select, trial software, blah blah:

http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

Are there any catches or preconditions to buying Developer, or is it just a simple $50 (or less, depending on where you buy it)? I want to explore more 2005 features than Express offers but I don't want a trial version that will expire.

Thanks for any clarification that can be provided.

Hi,

1)

SQL Server 2005 Editions and Integration Services
(http://www.sqlis.com/default.aspx?31)

Microsoft SQL Server: SQL Server 2005 Features Comparison
(http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx)

2) Yes, sure but the developer edition has the exact same features as the enterprise edition, so you have to keep in mind only to use the standard feature while developing if you want to deploy them later on a standad licenced server.

3) The only limitation to Developer Edition is that you can use it in production due to the agreed licence agreement during the setup process.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I understand the answers to 2 and 3 but still not clear on 1.

Is there a way to run 2005 integration packages created in Developer Edition under Express Edition? I've browsed the links and they don't give me a clear answer to this question.

|||

I'm going to move your thread to the Integration Services forum where I think you'll get a quicker response.

-Jeffrey

|||

I am pretty sure you can NOT run SSIS packages using only installable components from the sql server express edition. Basically, there is no free runtime available to run SSIS packages, you have to pay...

|||

Ken is correct, you can't run packages using Express Edition.

Also, just to correct one thing that Jens said. Functionality in Enterprise and Standard is NOT the same. You get extra functionality in Enterprise.

-Jamie

|||Thats not hat I said, if you read my post you will recognize that I compaed developer against the enterpise edition (not the standard edition) :-)

-Jens Suessmeyer.|||

Pardon me Jens, you did indeed. My apologies!!! :)

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.
Start|Run|msinfo32.exe should sort it.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
|
|||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.
|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editions/64bit/overview.mspx
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
|
|||Cheers Dave.
Dave Patrick wrote:

> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editions/64bit/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.Start|Run|msinfo32.exe should sort it.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
||||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editio...t/overview.mspx
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
||||Cheers Dave.
Dave Patrick wrote:

> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editio...t/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]|||You're welcome.
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.sql

Do I need x86, x64 or IA64?

Can anyone please help me select the correct version of SQL Server 2005
to order?
I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
as far as I've been able to work out that rules out the IA64 which is
only for Intel Itanium based machines, but as for the choice between
x86 and x64 I am still confused. Does the x64 version need to be run on
a special x64 version of Windows 2003? And if so, how can I tell if
that's what I'm running?
Many thanks, TH.Start|Run|msinfo32.exe should sort it.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Can anyone please help me select the correct version of SQL Server 2005
| to order?
|
| I'm running Windows Server 2003 Standard Edition on an AMD Opteron. Now
| as far as I've been able to work out that rules out the IA64 which is
| only for Intel Itanium based machines, but as for the choice between
| x86 and x64 I am still confused. Does the x64 version need to be run on
| a special x64 version of Windows 2003? And if so, how can I tell if
| that's what I'm running?
|
| Many thanks, TH.
||||Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
so does that mean that SQL Server x86 is the only version I can use,
even though the Opteron is a 64 bit processor?
Thanks again. TH.|||Seems you need a 64 bit OS to take full advantage.
http://www.microsoft.com/sql/editions/64bit/overview.mspx
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Thanks Dave. Msinfo32.exe seems to be telling me my Windows is 32 bit,
| so does that mean that SQL Server x86 is the only version I can use,
| even though the Opteron is a 64 bit processor?
|
| Thanks again. TH.
||||Cheers Dave.
Dave Patrick wrote:
> Seems you need a 64 bit OS to take full advantage.
> http://www.microsoft.com/sql/editions/64bit/overview.mspx
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"TH" wrote:
| Cheers Dave.

Do I need to change hardware when migrating from SQL 2000 to SQL 2005?

Hi Everybody!!!!

Do I need to consider investing in new and more powerful hardware when migrating from SQL 2000 (or any other previous version) to SQL 2005?

I have a friend / client who migrated from SQL 2000 to SQL 2005 sp 1. The performance of the server got really bad, and now he's trying to fix the problem by any means necesary.

I think it would be very understandable if investing in hardware would be recommended, as we all have seen that there are so many new platforms to use and integrate to (.NET framework, XML, soap, ADO.NET, etc, etc,) and keeping the old platforms as compatible as always (ADODB, ODBC, etc.)

Any feedback is greatelly appreciated!!!!

Tarh Ik

I would recommend having a fresh, new server with Windows Server 2003 R2 SP2 and then installing SQL Server 2005 SP2 on it. Then, you can either detach/attach or restore from a backup to migrate from SQL Server 2000. This is much less risky than upgrading in place from 2000 to 2005 and will perform better than installing a named instance on the same server where SQL 2000 is running.

As far as hardware goes, obviously, new, faster hardware is better if you have the budget for it. Hardware prices continue to get lower all the time, and nobody has ever complained about a database server being too fast.

DLL Error & Legend Question

I'm using version 8.5.
Is there a way to limit the legend to only show elements that are shown on the chart (i.e have a value)?

Also I'm recieving the following error when I attempt to generate a report into PDF:

"ERROR IN DATABASE DLL, CHECK REPORT'S SQL"

The report sql works fine in Query Analzyer, the database is up to and it is verified.

Any advice is greatly appreciated,

Thanks,
GalahadHi,
Change your database driver and try once again.

Regards

Deepak|||Yes i had tried that. But whenever i try to change to any other driver than pdsodbc.dll (ODBC), i get errors that are the same as before.

I'm accessing SQL Server data so I have changed to every driver that i know that would work w/ sql server. But no luck.

Other reports that I run have no issues using the same driver.

FYI, The reports are run locally on my machine for testing and migrated over to a dev server. A java client converts the Crystal into PDF files.

Any suggestions?

Thanks,
Galahad|||Open the report and Do verify Database
Set the Database Location path also|||Dear all in this discussion
i am also stuck with this problem , for an immediate solution , the DNS connection , along with a set location works , but the report speed is slow

The senario, the rpt files are in the local machine , the server has the database , when the report is requested it gives the error "Physical database not found"
please let me know the solution

Divide Integers

I'm trying to divide 2 integers to return a column of C's per thousand with
(Failures / Dropped) * 1000.
I've tried different version of float, cast as decimal etc. I'd like 4-5
didgits after the decimal. What is the correct way to divide integers to
return a usable number.
Yr Mnth Dropped Failures
-- -- -- --
2005 July 126493 610
2005 August 207325 955
2005 September 89714 742
2005 October 225112 1142
2005 November 186264 791
2005 December 146901 774
2006 January 103096 510Try
SELECT CAST((CAST(Failures AS numeric) / Dropped) * 1000 AS decimal(8,4))
FROM [YourTable]
"Paul Ilacqua" wrote:

> I'm trying to divide 2 integers to return a column of C's per thousand wi
th
> (Failures / Dropped) * 1000.
> I've tried different version of float, cast as decimal etc. I'd like 4-5
> didgits after the decimal. What is the correct way to divide integers to
> return a usable number.
> Yr Mnth Dropped Failures
> -- -- -- --
> 2005 July 126493 610
> 2005 August 207325 955
> 2005 September 89714 742
> 2005 October 225112 1142
> 2005 November 186264 791
> 2005 December 146901 774
> 2006 January 103096 510
>
>|||Paul Ilacqua (pilacqu2@.twcny.rr.com) writes:
> I'm trying to divide 2 integers to return a column of C's per thousand
> with (Failures / Dropped) * 1000. I've tried different version of
> float, cast as decimal etc. I'd like 4-5 didgits after the decimal. What
> is the correct way to divide integers to return a usable number.
Does one of:
convert(decimal(18,4), 1E0 * Failures / Dropped * 1000)
round(1E0 * Failures / Dropped * 1000, 4)
meet your requirements? Note that the last expression is float, so it
may have 000000001 or similar at the end when you look at it in Query
Analyzer.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||That does work fine.... Thank You very much.
It is sure odd numeric behavior... calculate it in Access or Excel and
it's automatic. Would you call this method "standard" in handling integer
division?
Thanks again
Paul
"Mark Williams" <MarkWilliams@.discussions.microsoft.com> wrote in message
news:FF7A96CF-B908-4FCD-BE98-6F6AB8FFDC8A@.microsoft.com...
> Try
> SELECT CAST((CAST(Failures AS numeric) / Dropped) * 1000 AS decimal(8,4))
> FROM [YourTable]
>
> --
> "Paul Ilacqua" wrote:
>|||Did you bother to look up the basic rules of integer math in SQL?|||Paul Ilacqua (pilacqu2@.twcny.rr.com) writes:
> That does work fine.... Thank You very much.
> It is sure odd numeric behavior... calculate it in Access or Excel and
> it's automatic. Would you call this method "standard" in handling integer
> division?
Exactly what is odd? integer/integer meaning integer division appears
in several other programming languages as well. And the fact that you
need to round or convert the result to get the number of desired decimals
is not strange at all - how should SQL Server be able to guess what you
want?
Yes, Excel has a number of rules for precisely that, guessing. Sometimes
it works, sometimes it does not. I have some CSV files around which
has data like 19991112093212, which Excel presents as float values
each time I open the file. In fact this is a string (date and time).
But Excel is an interactive tool, so mis-guesses can easily be corrected.
A server like SQL Server must work after more stringent rules.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland,
I agree... after I replied I realized that's why I like SQL Server over
Access or Excel (among other reasons) is that allows a finer control over
things like number formatting. Excel uses it's best guess a lot where it is
not always the desired result. "Odd" is a word that is replaced by
"understanding" after you learn something and that's why I frequent these
boards. (and sometimes take some hits for it)
Thanks again
Paul
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns9755642E25FB4Yazorman@.127.0.0.1...
> Paul Ilacqua (pilacqu2@.twcny.rr.com) writes:
> Exactly what is odd? integer/integer meaning integer division appears
> in several other programming languages as well. And the fact that you
> need to round or convert the result to get the number of desired decimals
> is not strange at all - how should SQL Server be able to guess what you
> want?
> Yes, Excel has a number of rules for precisely that, guessing. Sometimes
> it works, sometimes it does not. I have some CSV files around which
> has data like 19991112093212, which Excel presents as float values
> each time I open the file. In fact this is a string (date and time).
> But Excel is an interactive tool, so mis-guesses can easily be corrected.
> A server like SQL Server must work after more stringent rules.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx