| Groups | Blog | Home |
sql server new users : Import from SQL 6.5 to 2005
I have some tables that I'd like to copy from a SQL6.5 database into a SQL 2005 database. The table structure and data needs to come across, ideally automatically so I don't have to create the tables first in 2005. What is the best way to do this? Thanks, SW
SW,
You should be able to use the Import and Export Wizard to get data and tables from 6.5 to 2005. You can get to the wizard by right mouse click on a database, then choose Tasks / Import and go through the prompts. You can read about this in the Books Online topic "Copying Databases from SQL Server 6.5 or Earlier". RLF [quoted text, click to view] "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message news:OfIE3$ooHHA.4192@TK2MSFTNGP06.phx.gbl... > Hi, > > I have some tables that I'd like to copy from a SQL6.5 database into a SQL > 2005 database. > The table structure and data needs to come across, ideally automatically > so I don't have to create the tables first in 2005. > What is the best way to do this? > > Thanks, > SW >
Steve,
It has been several years since I ran instcat.sql, but it caused me no problem at that time. It updated a few things so that the newer tools (e.g. 7.0 Enterprise Manager talking to 6.5 servers) worked just fine. http://support.microsoft.com/kb/137636 says: The system catalog stored procedures installed by INSTCAT.SQL are backward- compatible. I Googled a few people who have run it for 2005 to 2000 connections and they had no problems, either. Although a brief look did _not_ find someone commenting on 2005 connecting to 6.5, I would not expect a problem. RLF [quoted text, click to view] "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message news:uUmNxztoHHA.588@TK2MSFTNGP06.phx.gbl... > Russell, > > Thanks for your input. It seems that I have to run a script called > instcat.sql in order to proceed. > What isn't clear though its probably me being overcautious is what are the > consequences of running this script? I assume that I have to get the > version of the script from a 2005 installation, and then run it on the 6.5 > server. > > Is there a rollback script if anything goes wrong? > > Regards, > > SW > > "Russell Fields" <russellfields@nomail.com> wrote in message > news:OY2j%23zsoHHA.4032@TK2MSFTNGP02.phx.gbl... >> SW, >> >> You should be able to use the Import and Export Wizard to get data and >> tables from 6.5 to 2005. You can get to the wizard by right mouse click >> on a database, then choose Tasks / Import and go through the prompts. >> >> You can read about this in the Books Online topic "Copying Databases from >> SQL Server 6.5 or Earlier". >> >> RLF >> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >> news:OfIE3$ooHHA.4192@TK2MSFTNGP06.phx.gbl... >>> Hi, >>> >>> I have some tables that I'd like to copy from a SQL6.5 database into a >>> SQL 2005 database. >>> The table structure and data needs to come across, ideally automatically >>> so I don't have to create the tables first in 2005. >>> What is the best way to do this? >>> >>> Thanks, >>> SW >>> >> >> > >
Russell,
Thanks for your input. It seems that I have to run a script called instcat.sql in order to proceed. What isn't clear though its probably me being overcautious is what are the consequences of running this script? I assume that I have to get the version of the script from a 2005 installation, and then run it on the 6.5 server. Is there a rollback script if anything goes wrong? Regards, SW [quoted text, click to view] "Russell Fields" <russellfields@nomail.com> wrote in message news:OY2j%23zsoHHA.4032@TK2MSFTNGP02.phx.gbl... > SW, > > You should be able to use the Import and Export Wizard to get data and > tables from 6.5 to 2005. You can get to the wizard by right mouse click > on a database, then choose Tasks / Import and go through the prompts. > > You can read about this in the Books Online topic "Copying Databases from > SQL Server 6.5 or Earlier". > > RLF > "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message > news:OfIE3$ooHHA.4192@TK2MSFTNGP06.phx.gbl... >> Hi, >> >> I have some tables that I'd like to copy from a SQL6.5 database into a >> SQL 2005 database. >> The table structure and data needs to come across, ideally automatically >> so I don't have to create the tables first in 2005. >> What is the best way to do this? >> >> Thanks, >> SW >> > >
Hello,
Instcat do not have any issues, I have used that multiple times some time back. If you do not want to run the INSTCAT.SQL. What you can do is:- (This is a manuall process) 1. Create the script of all tables includes dependents from SQL 6.5 (Use 6.5 enterprise manager) 2. Execute the script in SQL 2005 3. Extract the data from tables in SQL 6.5 using BCP OUT 4. Copy the files to SQL 2005 server 5. use BCP IN or BULK insert into load the data Thanks Hari [quoted text, click to view] "Russell Fields" <russellfields@nomail.com> wrote in message news:ewMPbDuoHHA.2596@TK2MSFTNGP06.phx.gbl... > Steve, > > It has been several years since I ran instcat.sql, but it caused me no > problem at that time. It updated a few things so that the newer tools > (e.g. 7.0 Enterprise Manager talking to 6.5 servers) worked just fine. > > http://support.microsoft.com/kb/137636 says: The system catalog stored > procedures installed by INSTCAT.SQL are backward- compatible. > > I Googled a few people who have run it for 2005 to 2000 connections and > they had no problems, either. Although a brief look did _not_ find someone > commenting on 2005 connecting to 6.5, I would not expect a problem. > > RLF > "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message > news:uUmNxztoHHA.588@TK2MSFTNGP06.phx.gbl... >> Russell, >> >> Thanks for your input. It seems that I have to run a script called >> instcat.sql in order to proceed. >> What isn't clear though its probably me being overcautious is what are >> the consequences of running this script? I assume that I have to get the >> version of the script from a 2005 installation, and then run it on the >> 6.5 server. >> >> Is there a rollback script if anything goes wrong? >> >> Regards, >> >> SW >> >> "Russell Fields" <russellfields@nomail.com> wrote in message >> news:OY2j%23zsoHHA.4032@TK2MSFTNGP02.phx.gbl... >>> SW, >>> >>> You should be able to use the Import and Export Wizard to get data and >>> tables from 6.5 to 2005. You can get to the wizard by right mouse click >>> on a database, then choose Tasks / Import and go through the prompts. >>> >>> You can read about this in the Books Online topic "Copying Databases >>> from SQL Server 6.5 or Earlier". >>> >>> RLF >>> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >>> news:OfIE3$ooHHA.4192@TK2MSFTNGP06.phx.gbl... >>>> Hi, >>>> >>>> I have some tables that I'd like to copy from a SQL6.5 database into a >>>> SQL 2005 database. >>>> The table structure and data needs to come across, ideally >>>> automatically so I don't have to create the tables first in 2005. >>>> What is the best way to do this? >>>> >>>> Thanks, >>>> SW >>>> >>> >>> >> >> > >
Thanks to all for your input.
I've done this by running instcat.sql on the 6.5 server, then by using the import wizard to import the tables first into a SQL 2000 database, then from there into my SQL2005 database. I kept getting errors when I tried to import directly from 6.5 to 2005, telling me that SQL2005 couldn't obtain a rowset and I should check if the data actually exists. Regards, SW [quoted text, click to view] "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message news:uLNDjpyoHHA.716@TK2MSFTNGP05.phx.gbl... > Hello, > > Instcat do not have any issues, I have used that multiple times some time > back. > > If you do not want to run the INSTCAT.SQL. What you can do is:- (This is a > manuall process) > > 1. Create the script of all tables includes dependents from SQL 6.5 (Use > 6.5 enterprise manager) > 2. Execute the script in SQL 2005 > 3. Extract the data from tables in SQL 6.5 using BCP OUT > 4. Copy the files to SQL 2005 server > 5. use BCP IN or BULK insert into load the data > > Thanks > Hari > > > "Russell Fields" <russellfields@nomail.com> wrote in message > news:ewMPbDuoHHA.2596@TK2MSFTNGP06.phx.gbl... >> Steve, >> >> It has been several years since I ran instcat.sql, but it caused me no >> problem at that time. It updated a few things so that the newer tools >> (e.g. 7.0 Enterprise Manager talking to 6.5 servers) worked just fine. >> >> http://support.microsoft.com/kb/137636 says: The system catalog stored >> procedures installed by INSTCAT.SQL are backward- compatible. >> >> I Googled a few people who have run it for 2005 to 2000 connections and >> they had no problems, either. Although a brief look did _not_ find >> someone commenting on 2005 connecting to 6.5, I would not expect a >> problem. >> >> RLF >> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >> news:uUmNxztoHHA.588@TK2MSFTNGP06.phx.gbl... >>> Russell, >>> >>> Thanks for your input. It seems that I have to run a script called >>> instcat.sql in order to proceed. >>> What isn't clear though its probably me being overcautious is what are >>> the consequences of running this script? I assume that I have to get the >>> version of the script from a 2005 installation, and then run it on the >>> 6.5 server. >>> >>> Is there a rollback script if anything goes wrong? >>> >>> Regards, >>> >>> SW >>> >>> "Russell Fields" <russellfields@nomail.com> wrote in message >>> news:OY2j%23zsoHHA.4032@TK2MSFTNGP02.phx.gbl... >>>> SW, >>>> >>>> You should be able to use the Import and Export Wizard to get data and >>>> tables from 6.5 to 2005. You can get to the wizard by right mouse >>>> click on a database, then choose Tasks / Import and go through the >>>> prompts. >>>> >>>> You can read about this in the Books Online topic "Copying Databases >>>> from SQL Server 6.5 or Earlier". >>>> >>>> RLF >>>> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >>>> news:OfIE3$ooHHA.4192@TK2MSFTNGP06.phx.gbl... >>>>> Hi, >>>>> >>>>> I have some tables that I'd like to copy from a SQL6.5 database into a >>>>> SQL 2005 database. >>>>> The table structure and data needs to come across, ideally >>>>> automatically so I don't have to create the tables first in 2005. >>>>> What is the best way to do this? >>>>> >>>>> Thanks, >>>>> SW >>>>> >>>> >>>> >>> >>> >> >> > >
It's too late now but for next time, if you attach your 6.5 database to SQL
2000 and then attach that database to SQL 2005, all the conversion will happen automagically. I assumed you didn't have SQL 2000 available if you were working with 6.5 databases. -- This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm [quoted text, click to view] "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message
news:O03NXg2oHHA.4552@TK2MSFTNGP04.phx.gbl... > Thanks to all for your input. > > I've done this by running instcat.sql on the 6.5 server, then by using the > import wizard to import the tables first into a SQL 2000 database, then > from there into my SQL2005 database. > > I kept getting errors when I tried to import directly from 6.5 to 2005, > telling me that SQL2005 couldn't obtain a rowset and I should check if the > data actually exists. > > Regards, > SW > > > "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message > news:uLNDjpyoHHA.716@TK2MSFTNGP05.phx.gbl... >> Hello, >> >> Instcat do not have any issues, I have used that multiple times some time >> back. >> >> If you do not want to run the INSTCAT.SQL. What you can do is:- (This is >> a manuall process) >> >> 1. Create the script of all tables includes dependents from SQL 6.5 (Use >> 6.5 enterprise manager) >> 2. Execute the script in SQL 2005 >> 3. Extract the data from tables in SQL 6.5 using BCP OUT >> 4. Copy the files to SQL 2005 server >> 5. use BCP IN or BULK insert into load the data >> >> Thanks >> Hari >> >> >> "Russell Fields" <russellfields@nomail.com> wrote in message >> news:ewMPbDuoHHA.2596@TK2MSFTNGP06.phx.gbl... >>> Steve, >>> >>> It has been several years since I ran instcat.sql, but it caused me no >>> problem at that time. It updated a few things so that the newer tools >>> (e.g. 7.0 Enterprise Manager talking to 6.5 servers) worked just fine. >>> >>> http://support.microsoft.com/kb/137636 says: The system catalog stored >>> procedures installed by INSTCAT.SQL are backward- compatible. >>> >>> I Googled a few people who have run it for 2005 to 2000 connections and >>> they had no problems, either. Although a brief look did _not_ find >>> someone commenting on 2005 connecting to 6.5, I would not expect a >>> problem. >>> >>> RLF >>> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >>> news:uUmNxztoHHA.588@TK2MSFTNGP06.phx.gbl... >>>> Russell, >>>> >>>> Thanks for your input. It seems that I have to run a script called >>>> instcat.sql in order to proceed. >>>> What isn't clear though its probably me being overcautious is what are >>>> the consequences of running this script? I assume that I have to get >>>> the version of the script from a 2005 installation, and then run it on >>>> the 6.5 server. >>>> >>>> Is there a rollback script if anything goes wrong? >>>> >>>> Regards, >>>> >>>> SW >>>> >>>> "Russell Fields" <russellfields@nomail.com> wrote in message >>>> news:OY2j%23zsoHHA.4032@TK2MSFTNGP02.phx.gbl... >>>>> SW, >>>>> >>>>> You should be able to use the Import and Export Wizard to get data and >>>>> tables from 6.5 to 2005. You can get to the wizard by right mouse >>>>> click on a database, then choose Tasks / Import and go through the >>>>> prompts. >>>>> >>>>> You can read about this in the Books Online topic "Copying Databases >>>>> from SQL Server 6.5 or Earlier". >>>>> >>>>> RLF >>>>> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >>>>> news:OfIE3$ooHHA.4192@TK2MSFTNGP06.phx.gbl... >>>>>> Hi, >>>>>> >>>>>> I have some tables that I'd like to copy from a SQL6.5 database into >>>>>> a SQL 2005 database. >>>>>> The table structure and data needs to come across, ideally >>>>>> automatically so I don't have to create the tables first in 2005. >>>>>> What is the best way to do this? >>>>>> >>>>>> Thanks, >>>>>> SW >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
Thanks Roger.
Yes I didn't mention I had the luxury of a SQL 2000 database online. It certainly made things easier, and could have made it even easier! Regards, SW [quoted text, click to view] "Roger Wolter[MSFT]" <rwolter@online.microsoft.com> wrote in message news:0C472F26-D044-47A0-B996-A62226D607E6@microsoft.com... > It's too late now but for next time, if you attach your 6.5 database to > SQL 2000 and then attach that database to SQL 2005, all the conversion > will happen automagically. I assumed you didn't have SQL 2000 available > if you were working with 6.5 databases. > > -- > This posting is provided "AS IS" with no warranties, and confers no > rights. > Use of included script samples are subject to the terms specified at > http://www.microsoft.com/info/cpyright.htm > > "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message > news:O03NXg2oHHA.4552@TK2MSFTNGP04.phx.gbl... >> Thanks to all for your input. >> >> I've done this by running instcat.sql on the 6.5 server, then by using >> the import wizard to import the tables first into a SQL 2000 database, >> then from there into my SQL2005 database. >> >> I kept getting errors when I tried to import directly from 6.5 to 2005, >> telling me that SQL2005 couldn't obtain a rowset and I should check if >> the data actually exists. >> >> Regards, >> SW >> >> >> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message >> news:uLNDjpyoHHA.716@TK2MSFTNGP05.phx.gbl... >>> Hello, >>> >>> Instcat do not have any issues, I have used that multiple times some >>> time back. >>> >>> If you do not want to run the INSTCAT.SQL. What you can do is:- (This is >>> a manuall process) >>> >>> 1. Create the script of all tables includes dependents from SQL 6.5 (Use >>> 6.5 enterprise manager) >>> 2. Execute the script in SQL 2005 >>> 3. Extract the data from tables in SQL 6.5 using BCP OUT >>> 4. Copy the files to SQL 2005 server >>> 5. use BCP IN or BULK insert into load the data >>> >>> Thanks >>> Hari >>> >>> >>> "Russell Fields" <russellfields@nomail.com> wrote in message >>> news:ewMPbDuoHHA.2596@TK2MSFTNGP06.phx.gbl... >>>> Steve, >>>> >>>> It has been several years since I ran instcat.sql, but it caused me no >>>> problem at that time. It updated a few things so that the newer tools >>>> (e.g. 7.0 Enterprise Manager talking to 6.5 servers) worked just fine. >>>> >>>> http://support.microsoft.com/kb/137636 says: The system catalog stored >>>> procedures installed by INSTCAT.SQL are backward- compatible. >>>> >>>> I Googled a few people who have run it for 2005 to 2000 connections and >>>> they had no problems, either. Although a brief look did _not_ find >>>> someone commenting on 2005 connecting to 6.5, I would not expect a >>>> problem. >>>> >>>> RLF >>>> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >>>> news:uUmNxztoHHA.588@TK2MSFTNGP06.phx.gbl... >>>>> Russell, >>>>> >>>>> Thanks for your input. It seems that I have to run a script called >>>>> instcat.sql in order to proceed. >>>>> What isn't clear though its probably me being overcautious is what are >>>>> the consequences of running this script? I assume that I have to get >>>>> the version of the script from a 2005 installation, and then run it on >>>>> the 6.5 server. >>>>> >>>>> Is there a rollback script if anything goes wrong? >>>>> >>>>> Regards, >>>>> >>>>> SW >>>>> >>>>> "Russell Fields" <russellfields@nomail.com> wrote in message >>>>> news:OY2j%23zsoHHA.4032@TK2MSFTNGP02.phx.gbl... >>>>>> SW, >>>>>> >>>>>> You should be able to use the Import and Export Wizard to get data >>>>>> and tables from 6.5 to 2005. You can get to the wizard by right >>>>>> mouse click on a database, then choose Tasks / Import and go through >>>>>> the prompts. >>>>>> >>>>>> You can read about this in the Books Online topic "Copying Databases >>>>>> from SQL Server 6.5 or Earlier". >>>>>> >>>>>> RLF >>>>>> "Steve Gr" <MSDNNospam235@nospam.nospam> wrote in message >>>>>> news:OfIE3$ooHHA.4192@TK2MSFTNGP06.phx.gbl... >>>>>>> Hi, >>>>>>> >>>>>>> I have some tables that I'd like to copy from a SQL6.5 database into >>>>>>> a SQL 2005 database. >>>>>>> The table structure and data needs to come across, ideally >>>>>>> automatically so I don't have to create the tables first in 2005. >>>>>>> What is the best way to do this? >>>>>>> >>>>>>> Thanks, >>>>>>> SW >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> >
Roger Wolter[MSFT] (rwolter@online.microsoft.com) writes:
[quoted text, click to view] > It's too late now but for next time, if you attach your 6.5 database to > SQL 2000 and then attach that database to SQL 2005, all the conversion > will happen automagically. I assumed you didn't have SQL 2000 available > if you were working with 6.5 databases. Roger, you can't do that. There is only single piece of software that is capable to read an SQL 6.5 database, and that is SQL Server 6.5. The structure in 6.5 was completely different from SQL 7. There are no mdf or ldf files, instead databases existed on "devices" which were file that could contain several databases, or fragments of several databases. The same also applies to backups. The only software that can read an SQL 6.5 backup is SQL Server 6.5. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |