 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / August 2008Migrating from SQL 6.5 to SQL 2005
I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can I copy databases from SQL 6.5 to SQL 2000? If not, I will need to install SQL 7.0. Will it install on XP Pro? I have an install CD from MSDN but I can't find any product keys for a CD this old. Any ideas? Thanks, BrianR Brian upgrade you server to 2000 and then upgrade to 2005 see the link bellow for more details on upgrading 6.5 to 2000 http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx I have an install CD from MSDN but I can't find any product keys for a CD this old. Any ideas? Do you mean cd key of sql 2000 if so open regedit.exe and locate the following node HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Registration your cd is stored in "cd_key" vinu http://oneplace4sql.blogspot.com/ > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. > Can [quoted text clipped - 8 lines] > > BrianR Thanks for the information about hte CD key. I wasn't aware of that. I guess did forget some information. I can't currently upgrade from 6.5 to 2000 because I need to keep the old 6.5 version around for a while. So now I'm stuck trying to find a 2000 cd key. Again, I have the MSDN CDs but I can't find the keys for applications that far back. BrianR > Brian > [quoted text clipped - 29 lines] > > > > BrianR Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance and based on that creates the database, the objects and finally copies over the data from the 6.5 install to your 2000 install. So, no in-place upgrade of any type. You cannot restore or attach 6.5 backups/databases on 7.0, 2000, 2005 or 2008. Upgrade wizard is the way to go and the most recent version it was shipped with was 2000.  SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > I've read that I can't copy databases directly from SQL 6.5 to SQL 2005. Can > I copy databases from SQL 6.5 to SQL 2000? [quoted text clipped - 7 lines] > > BrianR Since I have to keep my v6.5 computer around, I need to either install 7.0 or 2000 on another computer. This is now where I'm in a bind. I have the MSDN install CDs (Developer Edition) for it but I can't find the CD keys for either of these. When I try and look up the keys under MSDN (online), it doesn't go back that far. If I can copy databases from 6.5 to 2000 then that is what I would like to do. I've What's the best solution? BrianR > Basically the same upgrade wizard that is in 7.0 also came with 2000. There's a whole section in > 2000 Books Online on how to upgrade from 6.5. Basically the Wizard connects to your 6.5 instance and [quoted text clipped - 15 lines] > > > > BrianR As far as I recall, SQL Server never required CD keys, at least not the MSDN version. IT is either not at all required or already filled in for you. SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi > Since I have to keep my v6.5 computer around, I need to either install 7.0 or > 2000 on another computer. This is now where I'm in a bind. I have the MSDN [quoted text clipped - 28 lines] >> > >> > BrianR I only had time to try installing 7.0 this morning and it did ask for a CD key. I'll try 2000 later on today and hopefully you are right. BrianR > As far as I recall, SQL Server never required CD keys, at least not the MSDN version. IT is either > not at all required or already filled in for you. [quoted text clipped - 31 lines] > >> > > >> > BrianR > I only had time to try installing 7.0 this morning and it did ask for > a CD key. I'll try 2000 later on today and hopefully you are right. Since you are only intending to use 2000 as a staging post, MSDE Edition A (=2000) might suffice - it's a free download: http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC- 479F-BAFA-E4B278EB9147&displaylang=en Of course it has some limitations, e.g. database size <= 4GB Thanks for the tip Chris. I've downloaded it and I'll give it a shot. Will I have any issue with having SQL 2005 Dev. Ed. already installed? Will they work side by side? BrianR > > I only had time to try installing 7.0 this morning and it did ask for > > a CD key. I'll try 2000 later on today and hopefully you are right. [quoted text clipped - 6 lines] > > Of course it has some limitations, e.g. database size <= 4GB What tool do I use to copy the databases from 6.5 to MSDE2000A? > > I only had time to try installing 7.0 this morning and it did ask for > > a CD key. I'll try 2000 later on today and hopefully you are right. [quoted text clipped - 6 lines] > > Of course it has some limitations, e.g. database size <= 4GB I doubt that MSDE comes with the upgrading wizard... SignatureTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi >> I only had time to try installing 7.0 this morning and it did ask for >> a CD key. I'll try 2000 later on today and hopefully you are right. [quoted text clipped - 6 lines] > > Of course it has some limitations, e.g. database size <= 4GB > I doubt that MSDE comes with the upgrading wizard... True :-( And in response to the other postings: you might look at http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-msde/1501/How-to- upgrade-from-SQL-Server-6-5-to-MSDE-2000 which I had not seen previous to my original reply (which I had based on the stated intention of going from 6.5 via 2000). Sorry for misleading you. You are no doubt aware of: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx As to side by side - I don't think there should be a problem. FWIW I run 2005 Express side by side with 2000 Developers Edition. I was finally able to track down and install SQL Server 2000 Dev. Ed. but that has led to another small problem. When I use Server Enterprise Mgr and try to register this new sql 2000 server it doesn't show up in the list of available servers to register. I made sure the server was up and running but it doesn't find it in the list. Is there a configuration somewhere I missed during installation? BrianR > > I doubt that MSDE comes with the upgrading wizard... > [quoted text clipped - 13 lines] > As to side by side - I don't think there should be a problem. FWIW I run > 2005 Express side by side with 2000 Developers Edition. I was able to get the server to show up under the list of available servers by disabling my windows firewall (XP Pro SP3). I don't quite understand why the Enter. Mgr couldn't find the server when they were both running on the same (local) machine. I find that a little strange. I was able to get the new 2000 server registered. What's the best method to copy my 6.5 db(s) to my new 2000 server? I tried using the export wizard but it errored out saying one of the logins wasn't on the destination server (2000). I thought that's what it was doing for me was copying the whole database including the logins under the database. What am I missing? By the way, if you haven't noticed I'm fairly new with databases especially SQL (any flavor). BrianR > I was finally able to track down and install SQL Server 2000 Dev. Ed. but > that has led to another small problem. When I use Server Enterprise Mgr and [quoted text clipped - 22 lines] > > As to side by side - I don't think there should be a problem. FWIW I run > > 2005 Express side by side with 2000 Developers Edition. I continue to make progress.... I'm able to copy most of the tables to the SQL2000 server but it's erroring out during the transfer. I thought that transfer from 6.5 to 2000 was going to be pretty painless. The wizard was suppose to handle any translation issues. Here's one of the errors: Error at Destination for Row number 1. Errors encountered so far in this task:1 The statment has been termnated. Violation of PRIMARY KEY constrain 'PK__tblAward__32AB8735'. Cannot insert duplicate key in object 'tblAward'. I need some help deciphering this one. Any one??? Is there a setting somewhere that I missed? BrianR > I was able to get the server to show up under the list of available servers > by disabling my windows firewall (XP Pro SP3). I don't quite understand why [quoted text clipped - 38 lines] > > > As to side by side - I don't think there should be a problem. FWIW I run > > > 2005 Express side by side with 2000 Developers Edition. > I continue to make progress.... > I'm able to copy most of the tables to the SQL2000 server but it's [quoted text clipped - 12 lines] > I need some help deciphering this one. Any one??? Is there a setting > somewhere that I missed? <snip> >> What am I missing? By the way, if you haven't noticed I'm fairly new >> with databases especially SQL (any flavor). tblAward has (been defined with) a PRIMARY KEY constraint. Values used for a PRIMARY KEY must be unique. That error message is generated when a new row is being added but the key for the new row matches an existing key in the table, i.e. it would break the uniqueness constraint. I note that the error refers to row 1 so I wonder if you are perhaps trying to rerun this part of the transfer. HTH When I looked at this tblAward table, it only has one row. What other choices do I have to copy a database from 6.5 to 2000? I thought a simple "Export Data" would have executed without error. Thanks for your help Chris. BrianR > > I continue to make progress.... > > I'm able to copy most of the tables to the SQL2000 server but it's [quoted text clipped - 29 lines] > > HTH > When I looked at this tblAward table, it only has one row. Is that the table on 6.5 or 2000? You haven't said whether or not there was an attempt to write the table twice. Also, a NULL primary key field (which I believe is possible on 6.5) might be a problem. > What other > choices do I have to copy a database from 6.5 to 2000? I thought a > simple "Export Data" would have executed without error. Perhaps see http://www.mydatabasesupport.com/forums/sqlserver-tools/201942-sql-server- 6-5-data-conversion.html http://msdn.microsoft.com/en-us/library/ms177398(SQL.90).aspx (I Googled on "transfer sql server 6.5 database") Chris The funny thing is when I look at both DBs (using enterprise mgr), the table in both 6.5 and 2000 look the same. It's like it went ahead and copied the table. I deleted the DB and tried to copy again and got the same errors. BrianR > > When I looked at this tblAward table, it only has one row. > [quoted text clipped - 16 lines] > > Chris |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.