Live DB Version Upgrade
Jun 13, 2001
I need to create a DB version upgrade schema on client site that will preserve the existing data.
Provide the user with a patch that he can run on his database that wiil apply changes to his DB structure and keep the old data.
One approach that I am thinking of is to create a differential DB patch - a and apply that to the client database.
Is there any strategy any algorithm to do that. Can it be automated?
If there any accomplishments or approaches known on the subject?
I would greatly appreciate any ideas you can come up with.
Zaven
View 1 Replies
ADVERTISEMENT
Jan 31, 2007
Want to upgrade Evaluation version of SQL 2005 to full retail version. How would I do that. Thanks very much for your hel
Sam Commar
View 1 Replies
View Related
Apr 20, 2007
We want to licence a trail version 2005 EN with an fullversion of MS Sql server 2005 EN. Is that possible?
Conworx
View 4 Replies
View Related
Nov 8, 2007
Can some one here give me more insight about how to upgrade a SQL Server 2005 Standard Version (32 bits) to a SQL Server 2005 Enterprise Version (32 bits) as default instance on a Windows 2003 enterprise OS (32 bits). I want to know what is the easist way and what is the safest way. May I preserve some settings I have for the STD version, or I have to start from strach again to configure the server? Is there any catches, anything I should have attention to (We are using heavily about CLR and fulltext indexing)?
Thanks a milliom
Ning
View 1 Replies
View Related
Sep 11, 2007
I'm not sure this is the exact forum in which to ask this question, so if there is a more appropriate forum, please point me in that direction.
Basically I'm looking for advice and best practices for dealing with an upgrade plan for a hosted database. Here is the situation:
- Hosted software application (.Net)
- Uses SQL Server 2005
- When we upgrade the software application to a new version, there will be schema and data changes that need to be applied to the database
- For the software application, we have considered upgrading an offline machine and then switching old one instantaneously.
- For the database, I'm trying to figure out if we can keep everything live for upgrades, or if we should have a small amount of scheduled downtime to upgrade.
So we have identified 2 basic directions:
1) Keep the database live and apply the new script changes just after the application software is upgraded. This means zero downtime, but we'd have to design and test our application to be backward compatible, so that the new version of the application code could handle both the new schema design, and the old schema design. It seems that this option would add a huge amount of complexity because we would essentially be testing a 3rd app/schema combination.
2) Take a small amount of scheduled downtime and upgrade the application code and database all at once.
Obviously option #2 is the most desirable from a development process point of view, and #1 is the most desirable option from a business point of view (zero downtime).
So, I'm looking for some advice on this. Do most people take the whole system down? Are there 100% live systems that deal with this? Are there other approaches I'm not considering?
Any information would be greatly appreciated. Thanks.
View 4 Replies
View Related
Feb 23, 2007
is there a tsql or stored proc to find when was the sqlserver got upgraded from 2000 to sqlserver 2005?
thanks in advance
View 1 Replies
View Related
Feb 6, 2007
Hi All,
Currently we are using standard edition SQL Server 2005. In couple of days we will upgrade our system to Enterprise ed. How to do the right upgrade without losing any data? Do we have to uninstall the current version before upgrade it? Also, what is the best practice to have, keep using standard edition in my development box while later I will deploy it in enterprise on production server, or using Developer ed in my development box?
Thanks in advance.
View 5 Replies
View Related
Jul 20, 2000
I have a database running on what transpires to be an evaluation copy of SQL 6.5 which has expired. How can I install a full licenced copy of 6.5 whilst retaining databases, users etc.
Note:when starting the SQL server service it immediately shuts down due to the eval expiry. Any help is greatly appreciated.
View 1 Replies
View Related
Aug 2, 2007
Hi Experts,
We have SQL Server 2005 Standard edition in a box. We need to update (install) that box with SQL Server Developer editions. Please let me know what are the ways to do it.
Thanks in advance,
Hariarul
View 4 Replies
View Related
Aug 2, 2007
Hi Experts,
We have SQL Server 2005 Standard edition in a box. We need to update (install) that box with SQL Server Developer editions. Please let me know what are the ways to do it.
Thanks in advance,
Hariarul
View 3 Replies
View Related
May 9, 2006
Hello,
Can I install
Microsoft SQL Server 2005 Express Edition with Advanced Services
over
Microsoft SQL Server 2005 Express Edition
or must I uninstall the basic version?
Thanks
Frank
View 1 Replies
View Related
Feb 16, 1999
Hi All,
I am doing an upgrade of SQL Server from Beta 3 release to the release version. I will appreciate if I get some information , some tips that I should follow which will make my task simpler. The database is very critical and big. It has huge amounts of stored procedures.
If you can tell me any site which gives information regarding this that will be also helpful..
Thanks
Ajay
View 3 Replies
View Related
Aug 3, 1999
Hi Guyz
We are currently running with Eval 120day limit SQL6.5 SP4 and now wish to upgrade to the full version. We have now purchased the full version but whenever we try to "upgrade" the server all we get told is that we should "Use control panel to add or remove components" or we are told that we should "use service pack 3 to update". I can only assume that this message is refering to Add/Remove programs in the control panel but there is no reference to SQL here.
Any ideas how we can upgrade to the full legal version without loosing our SMS data?
Very best regards to all
Stuart
View 1 Replies
View Related
May 17, 2006
We started out with the trial version of sql2005 and we later purchased the full standard version I belive, I just realized our trial is going to expire which we have data we are using on it. Is it possible to enter our liscense number in the trial to continue using or do I have to detach all of the databases and install the new sql version and then reattach all of the databases and setup any maintence plans again.
View 5 Replies
View Related
Oct 13, 2006
I just installed 2005 and accepted all the defaults to upgrade the default instance of 2000 as prompted. However, when I open the SQL Server Mgnt Studio, my server shows 8.0.2039 as the version which is 2000, and I can't restore a backup from another 2005 server, because it gives an error message like it still thinks its 2000. The whole installation process went fine including sp1. I looked in Services to see if there was more than one instance of SQL Server, and there isn't. Also, all my database files are still in the old 2000 (mssqldata) directory. Any ideas, solutions? Thanks.
Michael
View 14 Replies
View Related
Aug 15, 2007
Greetings,
I am about to let users upgrade their SQL Express installations to Standard Edition. They will all run the upgrade program by a command line argument that I will supply along with a setup.ini that I will supply. Is it possible by simple means "hack" the setup.ini file in order to only allow upgrade to x86 Standard Edition? We have DVDs with all kinds of editions for both x86 and 64-bit and I would not want the users to accidentally upgrade to Enterprise Edition or a 64-bit Standard edition.
Is this possible to attain by simply means or do I have to upgrade all clients myself?
Regards,
Harald Hedlund
View 5 Replies
View Related
Apr 21, 2015
We migrated the MDS database to a new server (win 2012 & sql 2014). We did this by detaching attaching. After the move, I tried to upgrade the MDS database using the master configuration manager and i am getting the following error. I couldn't find any relevant articles online. "The upgrade from the version of the database is not supported or the sql scripts for the upgrade are misisng".
View 2 Replies
View Related
Sep 11, 2006
Hi, all,
I am having a question about SSIS. Is it a totally new product in SQL Server 2005 or it is a upgrade version of previous version DTS? Thanks a lot for any guidance for that.
With best regards,
Yours sincerely,
View 3 Replies
View Related
Sep 13, 2007
Hi All,
I have been using the 180 day evaluation version of SQL Server 2005 Standard Edition and I have my license key now for the purchased version. I read on the Microsoft site I am able to upgrade to the non-trial version without uninstalling the eval version. But for Standars Edition Microsoft states:
"... If upgrading to the fully licensed version of SQL Server 2005 Standard Edition, Workgroup Edition, or Developer Edition, it is recommended that you uninstall the 180-day trial version of SQL Server 2005 Enterprise Edition before installing the fully licensed version of the other editions..."
Is there anyway out where I don't need to uninstall my eval database server?
If it is necessary to uninstall eval version, then what is the best way to preserve all my current databases?
Thanks,
Sumit
View 1 Replies
View Related
Sep 7, 2007
We have been using the 180 day evaluation version and I have my license key now for the purchased version. I read on the Microsoft site I am able to upgrade to the non-trial version without uninstalling the eval version. But it doesn't tell me HOW to do it. I was expecting a menu option, maybe on the About Screen of Management Studio to enter it. (How naive is that?) Is there a simple way to tell the Eval version I am now licensed?
TIA
Chris
View 19 Replies
View Related
Mar 9, 2007
Our application installation setup needs to be able to detect:
Is SQL Server 2005 Express Installed?
If false, run the SP2 Installation
Is SQL Server 2005 Express or SQL Express SP1 Installed?
If false, run the SP2 Installation with Update Switch
Is SQL Server 2005 (not Express) Installed
If true, abort installation with a mesage.
Can you direct me to some documentation about testing for these environments or just if someone has some scripts that will run in InstallShield, that would be great.
ALSO, can you direct me to information about using the command line update switch for the Express SP2 Installer?
Thanks.
Pat
View 1 Replies
View Related
Oct 11, 2006
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.
View 1 Replies
View Related
Jan 23, 2007
i am working on upgrading the clients and server computers from 2000 MSDE to 2005 SQL Express Adv. Plan to upgrade using the template.ini.
i can find the version of sql server running on th server by @@version but how do i find the version of client connctivity components the computer has installed in order to ugrade?
1. somehow i need to know whether to upgrade a client computer CONNECTIVITY COMPONENTS from 2000 to 2005?
2. is there a way to enable tcp/ip in installation script of SQL Express?
THANKS
View 9 Replies
View Related
Sep 1, 2014
Is there any way to restore a database of higher version to lower version.
E.g. I have created a database in sql server 2012, created some tables & procedures in that.I took Full backup of that database. Can I restore it to sql 2008r2 or any lower version.
I know direct restore is not possible, I have to use either import or export option or generating script,but i want to know is there any easy step to do so.
Vimal Lohani
SQL DBA | MCP (70-461,70-462)
View 4 Replies
View Related
Jul 25, 2006
Hi all,
Since some analysis services features are only available in Enterprise version , I have to upgrade my SQL 2005 server from standard edition to enterpise edition.
So I uninstall originial standard version of analysis service and install a Enterprise version. However, the analysis service is still a standard version after installation.
Is it possible to keep data engine as standard version and install a enterprise version of analysis service?
Thank you very much
Tony
View 1 Replies
View Related
Feb 19, 2008
Hello,I have been searching and reading a lots of information on the microsoft website about the different version of SQL server, but still can not make my decision.In term of performance, is there a real big difference between the workgroup and the standard version? The workgroup is limited to 3 GB of RAM while the standard is unlimited, would that really change the performance if my server has 16Gb or RAM?The price difference is pretty substantial so if could only have to buy the workgroup , it would be better.One more question, regarding the type of licence, my server has 2 processors, could I avoid buying 2 licences and get the Server plus CAL instead. I am using this server to host 4 web-application running on SQL server. Each database is about 15 MB.Thanks in adavance for your advises.Arno
View 3 Replies
View Related
Oct 30, 2007
I 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 Related
Mar 11, 2006
Hi,
I have tried to attatch a database ,created by SQL server Express within a C# application , in SQL server 2005 Enterprise edition, but the following error message appears:
-----------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'MEDO'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&ProdVer=9.00.1187.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach database+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The database 'E:X.MDF' cannot be opened because it is version 611. This server supports version 607 and earlier. A downgrade path is not supported.
Could not open new database 'E:X.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)
------------------------------
so , how can I solve this problem , I need to reed the data resides in the tables of 'X' database , how can I do it?? please help me.
Thanks in advance for any help.
Aya.
View 7 Replies
View Related
Jan 7, 2008
I have an ssis package that downloads a SQL Server 2000 database and restores it to a SQL 2005 server. Ninety-five percent of the time it runs just fine, but every so often the job fails and I get the following set of error messages in the log file. (I have had to delete some of the proprietary information for this message to satisfy my boss like putting in [Database name] in place of the actual name of the database in the error message).
OnError, Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Converting database [Database name] from version 539 to the current version 611.
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Converting database [Database name] from version 539 to the current version 611.
OnError,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Database [Database name] running the upgrade step from version 539 to version 551.
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,Database [Database name] running the upgrade step from version 539 to version 551.
OnError,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,The transaction log for database [Database name] is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,The transaction log for database [Database name] is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,RESTORE could not start database [Database name].
OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,RESTORE could not start database [Database name].
OnError,SQL5,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,-1073548784,0x,Executing the query "RESTORE DATABASE [Database name]
FROM DISK = '[Path to back up file]' WITH REPLACE,
MOVE 'ASP_Live_Data' TO [Path to MDF file],
MOVE 'ASP_Live_Log' TO [Path to LDF file]" failed with the following error: "RESTORE DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
OnError,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,-1073548784,0x,Executing the query "RESTORE DATABASE [Database name]
FROM DISK = '[Path to backup file]' WITH REPLACE,
MOVE 'ASP_Live_Data' TO [Path to MDF file]',
MOVE 'ASP_Live_Log' TO [Path to LDF file]" failed with the following error: "RESTORE DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
OnTaskFailed,Restore backup file to DB,,,1/6/2008 2:59:31 AM,1/6/2008 2:59:31 AM,0,0x,(null)
Does anyone have any suggestions?
View 1 Replies
View Related
Sep 22, 2015
I have received the error message "Package migration from version 8 to version 6 failed".I have developed a SSIS package with Visual Studio 2013 which gives me PackageFormatVersion of 8. I then deploy my package to the ssisdb catalog that is running on a SQL Server 2012, this works fine but when I try to execute the package the error arises…due to SQL Server 2012 has a PackageFormatVersion of 6 and it can’t run something that has a greater version.I haven’t seen any good solution for this but one that would work for me would be to upgrade the Integration Services Server from 2012 to 2014, leaving everything else in 2012 (database, ssms, ssas, ssrs).Would this solve the package format problem? Would I then be able to execute my packages in the ssisdb catalog?
View 3 Replies
View Related
Jul 16, 2007
Now, I checked and verified that my backup version of SQL Server is the same as the version installed on the computer I'm restoring too.
I have SQL Server on a production machine that I backed up and want to test a full restore on a dev machine to make sure it will work when I need it to.
Now that I've run the restore command on my tape backup and go to restart the SQL server service I receive:
Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.
I'm afraid I don't understand why this is happening. If the builds are the same, then shouldn't restoring the MASTER database have worked normally and I'd be able to restart the service now?
Any thoughts or suggestions?
View 4 Replies
View Related
Dec 7, 2007
I have the trial version of SQL Server 2005 installed and have setup a couple of databases. This trial version will expire in another few weeks. I recently purchased a copy of the software and want to install it. Will I lose my databases, user info, etc? How do I go about installing without losing anything?
View 3 Replies
View Related
Mar 12, 2007
We have a 64bit os machine that we accidently loaded the 32 bit version of sql server on. We now want to upgrade it to 64 bit sql server, but we now have a production database on it. My understanding is that all I have to do is detach the production database, upgrade to 64bit sql server, then reattach the database. Is this really all I have to do?
View 4 Replies
View Related
