Developer V/s Enterprise (SSIS)
Oct 4, 2006Hell
View 1 Replies
ADVERTISEMENT
SQL Server 200 Developer Vs Enterprise Versions
Aug 11, 2006I am having some problems in the process of moving an Access back-endto an SQL Server back-end. Everything works but there are severeproblems of response times when the number of users builds up.At present we are using the Developer version before committing to theEnterprise version. BOL (quoted below) seems to suggest that, apartfrom licensing, they are the same.Can anyone please confirm that this is so. If not, what is thedifference?I may explain in another topic the problems I am facing but I firstwish to be clear on this particular question.---------------------------------------------------------------------------------------------------------------Quote from BOLMicrosoft® SQL Server™ 2000 is available in these editions:SQL Server 2000 Enterprise EditionUsed as a production database server. Supports all features availablein SQL Server 2000, and scales to the performance levels required tosupport the largest Web sites and enterprise online transactionprocessing (OLTP) and data warehousing systems.SQL Server 2000 Developer EditionUsed by programmers developing applications that use SQL Server 2000 astheir data store. Although the Developer Edition supports all thefeatures of the Enterprise Edition that allow developers to write andtest applications that can use the features, the Developer Edition islicensed for use only as a development and test system, not aproduction server.
View 5 Replies View RelatedTurn Off Enterprise Features In Developer Edition?
Feb 9, 2007Hi,
We have 2005 Standard Edition in our production environment and 2005 Developer Edition in dev. Recently we started using a feature in dev only to realize it was an Enterprise specific feature when we wanted to move it to prod. Is there any way to turn off the enterprise features in developer edition so it behaves just like standard edition?
Thanks
Charlie
SQL 2005 Developer Edition, Where Is Enterprise Manager?
May 17, 2007I just installed SQl 2005 Developer Edition, and don't see an Enterprise Manager icon. Only Configuration Tool icons were installed.
Is this all SQL 2005 Developer is, or shoudl I be seeing an Enterprise Manager?
Thanks for your response,
Nate Terry
How To Install SQL Server Developer From VS.Net Enterprise Architect 2002
Jul 4, 2004How can I install SQL Server 2000 Developer edition from the CD's of Visual Studio.Net 2000 Enterprise Architect ?
When I install VS.Net Enterprise Architect I do not see any install option for SQL Server 2000 Developer, though the MSDE option does appear during the installation. However, I was not interested in MSDE.
FOR XML Works Differently Between Developer And Enterprise Edition In SQL 2005
Jun 22, 2007If I run the same FOR XML query in a Development edition enviornment and a Enterprise Edition environment, the results are different. The query is exactly the same.
Here is the query:
DECLARE @MessageBody XML
DECLARE @AuditTable SYSNAME
DECLARE @SendTrans BIT
DECLARE @SendAudit BIT
DECLARE @RecordCount INT
DECLARE @OperationType CHAR(1)
SET @RecordCount = @@ROWCOUNT
SET @OperationType = 'U'
SET @SendTrans = 1
SET @SendAudit = 1
SET @AuditTable = 'States'
SELECT @MessageBody = (
SELECT * FROM
(
SELECT TOP 10
'INSERTED' AS ActionType, @SendTrans AS SendTrans, @SendAudit AS SendAudit,
COLUMNS_UPDATED() AS ColumnsUpdated, GETDATE() AS AuditDate,
@AuditTable AS AuditTable, 'test' AS UserName, @RecordCount AS RecordCount, *
FROM l_states
)AuditRecord
FOR XML AUTO, ROOT('AuditTable'), BINARY BASE64)
SELECT @MessageBody
In my DEV env (Developer Edition), this result is produced:
<AuditTable>
<AuditRecord ActionType="INSERTED" SendTrans="1" SendAudit="1" AuditDate="2007-06-22T15:43:12.497" AuditTable="States" UserName="test" RecordCount="1" StateAbbreviation="AK" State="Alaska" />
<AuditRecord ActionType="INSERTED" SendTrans="1" SendAudit="1" AuditDate="2007-06-22T15:43:12.497" AuditTable="States" UserName="test" RecordCount="1" StateAbbreviation="AL" State="Alabama" />
</AuditTable>
In my Enterprise Edition evn, this is the result:
<AuditTable>
<AuditRecord ActionType="INSERTED" SendTrans="1" SendAudit="1" AuditDate="2007-06-22T15:44:48.230" AuditTable="States" UserName="test" RecordCount="1">
<l_states StateAbbreviation="AK" State="Alaska" />
<l_states StateAbbreviation="AL" State="Alabama" />
</AuditRecord>
</AuditTable>
Does anyone have any idea what might be wrong? Any help is greatly appreciated.
Tim
Changing From SQL Server Enterprise Evaluation To Developer Edition
Nov 5, 2007I am currently using SQL Server Enterprise Evaluation which runs out after 6months. When this happens or even sooner I plan to install SQL Server Developer.
My questions is can I copy all the things I develop (databases, cubes, reports,) from enterprise evaluation & import/load them into SQL Developer with no problems? Will everything integrate? Is there any implications?
Changing From SQL Server Enterprise Evaluation Version To Developer Version
Oct 30, 2007I am wondering if it is possible to change from SQL Server Enterprise Evaluation Version to Developer Version. The reason is because the Enterprise Evaluation version expires after 180 days. So if I create reports and cubes in Enterprise Evaluation I can import them into Developer Edition right? Should I remove the Enterprise Evaluation version after 180 days or leave it then install Developer Edition?
View 1 Replies View RelatedChange From Developer Edition To Enterprise Edition Of SQL Server 2005 64 Bit
May 20, 2008We have an existing installation of SQL Server 2005 Developer Edition (64bit) that we are ready to go live with and would like to change the edition to Enterprise Edition (64bit). We have purchased all the appropriate licenses. We would like to avoid UN-installing the Developer Edition and RE-installing the Enterprise Edition. There must be some way to change a registry key, provide your serial number via a command line utility or re-run the setup with the license key provided and direct it to just change the edition from Developer to Enterprise and not change any of the other settings like service account, sa account, collation, etc. Any help is most appreciated.
Thank you,
Matt
SSIS - SQL Server Developer To Express Edition
Nov 2, 2006Hi,
Does anyone know if it is possible to use SQL Server Developer Edition to produce SSIS packages that will operate on a remote SQL Server Express Edition database?
The situation is such that it is easiest to install a SQL Server Express Edition database on a remote server (for use within a company intranet) due to server availability and licensing restrictions. It would be great to be able to do Excel round trips with the data though - would it be possible to use SQL Server Developer Edition to do this on another computer, and have it update the data in the Express database?
Thank you for your time.
Kind Regards,
Ray Muirhead
SSRS On 2005 Enterprise Edition Connecting To A Db On SQL Server 2005 Developer's Edition, Possible?
Apr 8, 2008
Is it possible to connect SSRS running on SQL Server 2005 enterprise edition (our production system) to a database running on SQL Server 2005 Developer's edition (our test system)
thanks!
How Can I Transfer A Password For OLEDB Connection Within A SSIS Package To Another Developer's VS2005 PC?
Sep 14, 2007Hi,
After I had transfered SSIS package to another PC I tried to open package and I got an error. ".. Failed to decrypt protected XML node "PackagePassword" with error . ".
It turned out, that the password wasn't saved in a OLEDB connection manager of the Package. However "save password" options checked!
But password field was empty.
As soos as I enter password the package executes successfully.
Question: How can I transfer a password for OLEDB Connection within a SSIS package to another developer's VS2005?
Enterprise Deployment Of SSIS
Jun 13, 2006Hello, we are interested in upgrading our Data Warehouse environment to SQL Server 2005 to take advantage of SSIS. Our current data warehouse environment consists of 2 production servers with over 900 DTS packages between the 2 servers.
Are there any white papers out there detailing what type of deployment works well for an Enterprise wide use of SSIS? We're trying to determine if we should use SSIS on the same server hosting our databases, or separate SSIS onto its own dedicated box. If we went the dedicated route, what type of horsepower would we need on the SSIS box (procs, RAM, etc.)? Also, if we went the dedicated route, does it make sense to have 1 SSIS server that handles the data warehouse packages and the OLTP packages, or should that be separated into 2 SSIS servers having one server for each environment?
Thanks for any help you can provide on this subject!
Eric
Changing Careers - Software Developer To Database Developer
Jul 10, 2006Hello all. I'm giving serious thought on changing gears withing the IT world. For several years I have been a software developer who has been fortunate enough to have been involved in the needed databases. From just sketching out tables for the DBA to doing the database from the ground up and maintaining it during production. Along the way I've known that I didn't do as quality of a job as a knowledgeable DBA would do but given the situations I made do just fine.
I am considering switching gears to the database side only, coding as secondary. Since I am basically familier with most aspects of SQL Server in a general way, I am looking to take that knowledge and become a "Professional". What I am looking for is a few books to help out. Maybe a "Become a DBA for Software Developers" or something. I know that mining these and other forums are very valuble but I'd like some other training materials as well.
Have I been clear enough on what I am looking for? I don't quite feel like I have.
Basically, what would you recommend for a good software developer who is looking on switching to becoming a good database person?
I'd like to stay in SQL Server for now, since that is what they use here and it would give me an opportunity to practice.
Also, do you see value in the studying process for certifications in this area?
Started With Express, But Installed Developer And Don't See Developer Instance...
Jun 19, 2006I can't tell if the SQL Developer install upgraded the service, but left the SqlExpress version information, or if I'm still really only using SqlExpress.
Also, my intended target is SQL Enterprise, so if I am using SQL Express am I asking for trouble when I go to move the database over? Are the database formats compatible?
I've poked around trying to search for this answer for a while and haven't turned anything up. Maybe I'm searching on the wrong terms...
Thanks,
Geoff
Can I Use SQL Server 2005 Developer With Visual Web Developer?
Nov 24, 2007There are conflicting postings everywhere about this. I built a small site using VWD and SQL Server Express, but need to convert to Sql Server 2005 Developer because the DB will exceed 4Gb. Tried to install and could not connect or use from VWD. Tried to uninstall, got into large mess with the byzantine uninstall process, and have now started with a clean machine.
I installed SQL Server 2005 Developer first, then installed VWD Express 2008 without installing SQL Server Express. VWD won't let me connect to an existing database, won't let me add a new database and doesn't even show the Database Tools option under the Tools menu.
Is there someone with specific knowledge that can provide any enlightenment? Would be much appreciated.
SSIS Features - Standard Vs. Enterprise Edition
Jul 23, 2006Hi,
I'm trying to find what features that are in the enterprise edition that we don't have in the standard edition.
I couldn't find any information in the microsoft site.
Could anyone send me a list or point me to a link.
Thanks.
Upgrading SQL 2005 Enterprise Evaluation To Enterprise Full Not Supported On Win XP Professional
Jul 11, 2006This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?
View 3 Replies View RelatedVisual Web Developer 2005 Express -- With SQL Server Developer 2005?
May 4, 2006Can someone here confirm or deny that Visual Web Developer 2005 Express Edition doesn't work with SQL Server Developer Edition 2005?
I
was about to order SQL Server Developer Edition 2005 on Amazon, to use
with Visual Web Developer 2005 Express, when I read a user comment that
the two are incompatible with each other. Does anyone know for sure if
that is true?
What I'm wanting to do is develop an ASP.NET web
application on a web host using a SQL Server database. I use VS2003 and SQL
Server Enterprise 2000 at work, but I'd like to learn the 2005 editions
for this side project. I don't own any of the developer tools/IDEs
personally, so I'm trying to find the most affordable way to do this
for my home business.
Thanks for any advice,
Keith
Connect From 2005 Developer Edition To 2000 Developer Edition
Jun 1, 2007Hi, all -
I'm trying to register a developer's 2000 pc from my 2005 pc.
i'm not sure this is even something possible from Dev Edition to Dev Edition- I can register a 2000 server just fine.
I can ping him. Both our systems have remote access 'on'. His server is (local), i've tried connecting to it by just entering his machine name and by using just the ip address. The error I get is "timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding."
Am I just not registering this properly? I entered just the ip address in the 'server' box. I am connecting as sa with the pw he gave me. When i connect to my server, I use the ip addressinstance. However, I am not sure what to use for the instance when all I see when I look at his machine is (local).
I haven't needed to do this before.
Suggestions?
Difference With SQL Server 2k5 SSIS Dev Edition Vs SQL Server 2k5 SSIS Enterprise Edition
Nov 16, 2006Hi,
Just want to ask if there will be any difference if I start to develeope a a package from the SSIS dev? rather than the enterprise edition?
SSIS Features Comparison Between Enterprise Edition And Standard Edition
Apr 17, 2008I found so many websites wrote that fuzzy grouping ,fuzzy lookup, term extraction, term lookup,Dimension processing destination adapter and Data mining model training destination adapter only available at Enterprise Edition.
Anyway i still can use these components at Standard Edition.
Is that any features different between these two edition for these components? Thanks
Installing SQL Server 2005 Developer Edition On Same Box As SQL Server 2000 Developer Edition
Nov 1, 2005I tried to install this on the same box and I'm not sure how to reply to setup questions since I want to keep my SQL Server 2000 intact.
View 5 Replies View RelatedMigration From SQL 2000 Enterprise Server To The SQL 2005 Enterprise Server (64 Bit-Itanium Server)
Dec 20, 2006We are migration few database from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server)
Problem :
- The performance difference observer was not much (Just 15-18%)
- The CPU Utilization goes to 100% immediately, when the software login screen appears and it sustains in between 90% to 100%
- Multi-User Access (3 or more concurrent users), the sql performance is tremendously slow.
Steps followed for Migration:
- We have used the backup and restore method to migrate the data from SQL 2000 Enterprise Server to the SQL 2005 Enterprise Server (64 bit-Itanium Server).
- We ran the DBCC DBREINDEX for each affected tables
- We executed the sp_updatestats procedure for all the tables
- Upgraded the DB compatibility version to 90
- Installed the SQL 2005 Enterprise Server (64 bit-Itanium Server) Service pack 2.
One thing that we observed, was the memory usage, on SQL 2000 the sqlservr.exe uses around 1.5 GB where as on the SQL 2005 its just 120 MB.
A normal select query on 2000 Server took 11-12 sec, having 10 lac records, and the same query on 2005 took 1 min (3-5 sec CPU process taken by sqlservr and rest by the Sever Management Studio.
The only differance noted was that on 2000 the entire data was displayed at one go where as in 2005 the data was displayed at the 1st sec, and was filling the rest in the buffer, and to finally display entire data it took 1 min.
Also
when we run this query
select * from sys.dm_os_sys_info
one column os_priority_class shows a value = 32 ? what does this means.
In the MSSQLSERVER SERVICES, properties, there is a parameter displaying value
Advanced > Running Under 64 bit OS = No ? what does this means.
Could anyone pls suggest as to how to increase the sqlservr.exe memory area, and also how the enhance the performance.
Developer 00 VS. Developer 05
May 11, 2008I was wondering if it is worth purchasing mssql developer 05 when I have mssql developer 2000
Thanks Jonny
SQL Developer
Jan 11, 2005i hope this is in the right place
i have just downloaded .net framework and web matrix, this is so i can test my .aspx pages witout going directly on the web. but i now have a new problem because i'm not on the web i can't access my sql, so i need to be able to create sql databases on my desktop and test them. obviously i can't afford the full sql server but there is a developer edition for £35 would this allow me to create and link to them through web matrix and if it does would i then be able to upload the created sql database to the web or is the software for testing only and will it block me from actually publishing the database?
DB Developer To DBA ???
Apr 10, 2006Dear all,
I have been working in MS SQL Server for around 6 years ( versions : 7.0 and 2000 ). I have been extensively involved in database design and development. I have not much involved much in administrative activites.
I need to know what are the core activities which makes a Database Developer as a complete DBA ?
Thanks in advance,
Hari Haran Arulmozhi
Web Developer
Jan 1, 2007I am web developer and i decided to use sql server 2005 for my projects ... is there a book you recommended for learning SQL Server 2005 Programming
Thank you
SQL Developer
Jan 7, 2008Wanted to get different opinions about how SQL Developer is being used.
We are fixing to upgrade from SQL 2000 to 2005 and are going to need to buy some licenses. I told my manager I didn't know why they had a processor license for the SQL test box and not just buy the developer copy for each developer to use on the server. This would free up 4 processor licenses.
From my understanding Developer is licensed per person to be used for development, and testing.
Now if you want to load test this do you have to buy a license for every machine? Is this where they stick it to you?
Was wondering what other people are doing out there.
Need Help With Web Developer
Aug 31, 2007hey everyone...guys i'll be honest i am a noob to web developer but i want to learn this real bad..i have been given a task from my teacher to make a table in SQL...i am really confused how to create a table? i have used the sql+ an old version before but i dont find any sort of an editor excep for the visual web developer itself..i can see a table designer but it is not accessible...i am really sorry for my noobness but i really want to learn...awaiting replies
View 2 Replies View RelatedSQL Developer
Oct 19, 2007I am trying to install the Developer edition I think it is installed properly but how can I connect to it? What management tool can I use? You can probably see that I am unfamiliar with SQL 2005 . These might be dumb questions but is there a tutorial on how to install SQL 2005 connect it and then connect Visual Studio Pro to it?
View 4 Replies View RelatedSql Developer Duties
Oct 3, 2000Hi,
I want to start my carrier as a Sql Developer. Can anyone suggest me what exactly i have to do as a developer. I know how to write Stored Procs, triggers, creating tables , views , indexes. What else will be the responsbilities as a Developer.
Thank you very much.
---Devi
Looking For A Senior D.B. Developer (SQL)
Nov 8, 2005hi folks,
I'm looking for a senior d.b. developer with 5+ year of SQL programming, using relational database such as MS SQL Server, Oracle, Sybase with 2+ years focusing on MS SQL Server 7.0 and MS SQL Server 2000.
I have more details - just send me an email and i can provide them to you -thanks!