MSsql Developer Vs Standard
Oct 4, 2007100% new to SQL and have a choice of whether to start learning on standard or developer. Which one would the you folks reccommend (and why if possible)? Thanks in advance
View 6 Replies100% new to SQL and have a choice of whether to start learning on standard or developer. Which one would the you folks reccommend (and why if possible)? Thanks in advance
View 6 RepliesCan SQL 2005 Standard and Developer Editions co-exist on the same server?
View 1 Replies View RelatedHi,
Has anyone tried an in-place upgrade from SQL Server 2005 Developer to Standard Edition?
It apears to be a valid upgrade path according to this:
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Is it just a case of changing the registered licensing info? (I presume all the functionality for Standard exists in the Developer Edition) Or is it a reinstall job?
I want to use a dev license for development on the server, then once its finished, just leave it in place on the box and upgrade the licensing to standard edition. (The client doesn't yet have a Standard License, but does have a Dev License - and wants me to start right away!)
If its going to boil down to having to do a full re-installation then I should get a Standard license from the start, if its just a minor license key change, then I can use a Dev license straight away!
Pls. help. Thank you!
Hi, I currently have a license for SQL Server Standard 2005 that I would like to implement, but do not have the media. Is there a way to upgrade the developer edition and apply the license to it, thus creating a valid, licensed, Standard 2005 copy? Thanks!
View 1 Replies View RelatedHi,
I have Sql server 2005 Standard edition on my system and was wondering whats the difference between Standard edition and developer edition which one is better..most of the things that i do on sql server is
write sprocs, create table etc...
any ideas will be appreciated..
regards
Karen
hello we want to evaluate TS foundation server but it says it won't support developer edition sql, only sql2k5 stanard. But now we have DEVELOPER version on our development sql server, DEVDATA1, i.e. instances DEVDATA1DEV, and DEVDATA1QA are both installed on the same sql server box with both SP1 applied.
How can we update DEVDATA1QA to Standard version while still have SP1 applied? we just install Standard CD and then apply SP1 again?
Because this instance is our QA version, before we do something silly, if any of you did that before, any advice would be really helpful.
thanks in advance.
Would there be any issues with installing an MSSQL 2000 32 bit instance onto a windows 2003 64 bit server?
View 5 Replies View RelatedI am running MS SQL Server 7 with SP3 installed and am having some problems getting replication to work correctly. I want to replicate all tables from one database to another database on the same server. I can setup replication, add publications and add subscriptions without any problem and all goes well until the replication process starts when the job aborts because it cannot find the sp_MSins..., sp_MSupd... or the sp_MSdel... stored procedures. I have used the New Publication wizard to create a Transactional publication, published all tables and allowed the wizard to use the default stored procedures which it says will be created when the subscribers are initialized but although I have created push subcriptions the stored procedures are never created and hence the replication fails whenever the job runs.
I have SA access to the databases concerned and as far as I am aware the jobs are running as my login - can anybody help me out as this is beginning to drive me nuts.
Thanks
Chris
I installed SQL Server 2005 flawlessly yesterday. When login as "sa" through SQL Server Management Studio, I get an error message saying it cannot connect to my PC.
I checked the MSSQL Server Service. It is not started and cannot be started because it's looking for a path that does not exist!.
The folder in question is missing.
C:Program FilesMicrosoft SQL ServerMSSQL
The following folders do exist:
C:Program FilesMicrosoft SQL ServerMSSQL.1
C:Program FilesMicrosoft SQL ServerMSSQL.2
I initially suspected this problem was cause by a previous MSDE 2000 installation.
I uninstalled SQL Server 2005 & MSDE 2000.
I re-installed SQL Server 2005. Same problem.
I executed
http://support.microsoft.com/default.aspx/kb/320873
to make sure all registries are removed and manually deleted C:Program FilesMicrosoft SQL Server€™s content
Re-installed SQL Server 2005. Same problem.
I do not know what do in order to get SQL Server 2005 up & running.
All help is greatly appreciated.
Frank
Hi,
I have a question about using MSSQL server 2005 standard edition in Clustering mode.
I would like to build a msql cluster with only 2 servers (2 nodes).
I read here -> http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&DisplayLang=en
page 5 that you can use MSSQL server 2005 standard edition in Clustering mode with 2 nodes.
But my question is :
Can I use windows 2003 standard edition (Clustering mode managed ????) or I only can use windows 2003 enterprise edition ?
J.
Hi,
I have recently upgraded a SQL x64 server from Developer Edition to Standard Edition, This succeeded without issue. Following a reboot SQL Server yielded the following message
Your SQL Server installation is either corrupt or has been tampered with unable to load SQLBoot.DLL. Please uninstall then re-run setup to correct this issue.
Please can anyone help ?
Many Thanks
Marcus Stuart
As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?
View 3 Replies View RelatedWe have a performance problem with a SQL statement (never completes) on one of our customer€™s sites. They are running SQL Server 2005 Standard Edition with SP2. The server is dual core with 3GB or RAM.
We requested a backup of the database and restored it to a SQL Server 2005 Developer Edition Server with SP2. The server has a single CPU with 2GB or RAM. However the exact same SQL (cut and paste) executes in approx 35 seconds.
We restored the backup of the customers database SQL Server 2005 Standard Edition with SP2. The server is dual core with 2GB or RAM. However as on eth customer site the SQL never completes.
So our question is why is this happening and is there a solution?
Our understanding is that the SQL Server 2005 engine is the same but Developer Edition (aka Enterprise Edition) has additional options.
I tried to download PerformancePoint Server Trial Version to ther server today and I got to the configuration point of the Analysis Services Setting, and when I clicked next to proceed with the configuration I got a popup error message:
"Microsoft Analysis Server must be Evaluation, Developer or Enterprise Edition".
Now I have SQL Server 2005 Developer Edition Disc (Bought it with Visual Studio 2005) but on the server I have SQL Server 2005 Standard Edition, if I try to run the sql server developer Edition disc, I use the wizard download and it seems that the download is going through the SQL Server entire download, it's like I'm re-downloading SQL Server all over again.
Does that seem right?
what is the best approach to work around this probelm?
I appreciate any help
Thanks
Hi All,
Do I need to remove Microsoft SQL Server 2005 (Standard) from the Add or Remove program to replace it with Developer Edition?
I also wondering if I would need to backup my data and log files first, would they be deleted during the process?
Thanks.
Hi All,
Do I need to remove Microsoft SQL Server 2005 (Standard) from the Add or Remove program to replace it with Developer Edition?
I also wondering if I would need to backup my data and log files first, would they be deleted during the process?
Thanks.
I have a problem,
because we installed the SQL Server 2005-64Bit Developer Edition on a 2003 Server R2-64Bit with 10GB RAM an 2 Xeon. Now we have huge performance problems wich should be better using the Stadard Edition...
I don't know if it is easily possible to upgrade by only inserting the DVD and start the Setup...
Has anybody some experiences?
Please give some information....
Hello 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?
I 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
I have installed the SQL Server 2000 developer that came with Office XP Developer. I now have a copy of SQL Server 2000 Standard. What will happen if I try to install the standard version? Will I loss any of my current database logins or settings, etc...?
Thank you for any help,
There 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.
Hi All,
Good Evening.
I need a comparision between Evaluation copy and Standard license version of SQL Server 2005 /SSIS.
I'm assigned a task to evaluate SSIS and migrate a project to SSIS.
I have downloaded SSIS evaluation version and started working on that.
Now i'm being posed questions for the complete functionality of the tool...
- Whether it has a Bulk load trasformation ?
- Whether the evaluation version contain all the features of a standard license version ?
I need to submit a consolidated report for SSIS in comparision to the current ETL tool features.
Can you please let me is there any considerable features not given with a evaluation copy ?
Thanks in advance,
Suresh N
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??
View 1 Replies View RelatedCan 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
Hi, 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?
How many result-rows does mssql return should be used asynchronous method to use mssql cursor, can get the best performance in any time in any result offset?
i want to make the cursor fast in any time whatever how many results returned
Hi,
i was planning to create a database migration tool ..
its a certain database of a DMS (document management system) to
another DMS (two different DMS)... from DMS using msde 2000 server .. and tranfer to a DMS using a postgre sql or mssql .. depends ..
they have different table structures and names . . :D
i was thing of what language shall i use.. or what language is the best to work on this kind of project :)
hoping for your kind help guys. thanks :)
br
Frozenice
Does enabling/disabling Data Execution Prevention have a performanceimpact on SQL 2000 or SQL 2005?For SQL best performance - how should I configure for:Processor Scheduling:Programs or Background servicesMemory Usage:Programs or System Cache
View 9 Replies View RelatedHi,
I am a bit new to the MSSQL server. In our application, we use so many SQL queries. To imporve the performance, we used the Database enigine Tuning tool to create the indexes. The older version of the application supports MSSQL 2000 also. To re-create these new indexes, I have an issue in running these "CREATE INDEX" commands as the statements generated for index creation are done in MSSQL 2005. The statements include "INCLUDES" keyword which is supported in MSSQL 2005 but not in MSSQL 2000.
Ex:-
CREATE INDEX IND_001_PPM_PA ON PPM_PROCESS_ACTIVITY
(ACTIVITY_NAME ASC, PROCESS_NAME ASC, START_TIME ASC, ISMONITORED ASC)
INCLUDE
(INSTANCE_ID, ACTIVITY_TYPE, STATUS, END_TIME, ORGANIZATION);
Any help in creating such indexes in 2000 version is welcome.
Thanks,
Suresh.
Hello
We are using SQL 2005 and now we are planning to use SQL 2000. what are the ways to do the process.
We taken the script spcificall for 2000 and run it in SQL 200. But we are getting the error in SCRIPT?
Could you please give me the step to do?
Thanks,
Sankar R
Hello:
I am currently work on mssql 6.5. On my workstation, I have mssql 6.5
cient software.
However, I would like to install mssql 7.0 server on my nt workstation
and work with it to become familiar with 7.0. Can I install mssql 7.0
server on my nt workstation? Can mssql 6.5 client coexist with mssql 7.0
on the same machine if they are in different directories?
Thanks.
David Spaisman
Ben writes "I have a sql script that doesn't function very well when it's executed on a SQL 2000 server.
The scrpt looks like this:
---------------------------------------------------------------------------------------------------
USE [master]
GO
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
EXEC sp_addlogin N'SSDBUSERNAME', N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
If EXISTS (Select * FROM master.dbo.syslogins WHERE loginname = N'SSDBUSERNAME')
ALTER LOGIN [SSDBUSERNAME] WITH PASSWORD=N'SSDBPASSWORD'
GO
GRANT ADMINISTER BULK OPERATIONS TO [SSDBUSERNAME]
GO
GRANT AUTHENTICATE SERVER TO [SSDBUSERNAME]
GO
GRANT CONNECT SQL TO [SSDBUSERNAME]
GO
GRANT CONTROL SERVER TO [SSDBUSERNAME]
GO
GRANT CREATE ANY DATABASE TO [SSDBUSERNAME]
GO
USE [master]
GO
IF EXISTS (select * from dbo.sysdatabases where name = 'ISIZ')
DROP DATABASE [ISIZ]
GO
USE [SurveyData]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
GO
USE [SurveyManagement]
GO
exec sp_adduser 'SSDBUSERNAME'
GRANT INSERT, UPDATE, SELECT, DELETE
TO SSDBUSERNAME
---------------------------------------------------------------
I need to be converted to a script that can be executed on both MSSQL 2000 and MSSQL 2005.
I was wondering if somebody there could help me with this problem?!
Thanks,
Ben"
I've been tasked to move our production databases on MSSQL 2000 to 2005. I've supported MSSQL since version 6.5 and performed migrations to successor versions.
Current Environment is MSSQL 2000 32-bit with current Service Packs.
I've performed mock migrations on Test servers upgrading all Production instances simultaneously from MSSQL 2000 to 2005 32-bit. The Test environment is identical to Production minus server name, IP etc. Also I have a separate server with MSSQL 2005 installed where I use the DETACH / ATTACH and BACKUP / RESTORE method for migration / acceptance testing. There are approximately 30 databases totaling 70 GB. This has gone as expected and fairly successful. Vendors have been coordinated with to update code and staff for acceptance testing.
I'd prefer going directly to MSSQL 2005 64-bit instead if possible due to memory benefits etc. This is where I'd like some feedback prior to borrowing a 64-bit server for testing.
Upgrade options:
1. Is it better to migrate from MSSQL 2000 32-bit to 2005 64-bit via:
a. DETACH / ATTACH
b. BACKUP / RESTORE
c. Is one method more advantageous relating to the end result?
2. Regarding XP clients, have issues been experienced with the default SQL Server driver or is an alternate recommended for XP clients to connect to a MSSQL 64-bit server databases?
3. If you have performed this migration and have relevant experience please pass them along.