Newbie - Moving a table from one database to another
in [Server Configuration]
|
Prev: Percent of advance in Restore database
Next: Client in a workgroup with SQL Server using Windows Integrated Authentication
From: Starfish on 1 Jul 2008 13:36 Hello, I'm very new with SQL. I wanted to find out if there was an easy way to move (or even copy) a table from one database to another database (on the same server). We are using SQL 2000.
From: Starfish on 1 Jul 2008 14:09 I just discovered, the server we are moving the table from is running SQL 6.5 - the server we are attempting to move the table to is running SQL 2000. "Starfish" wrote: > Hello, I'm very new with SQL. I wanted to find out if there was an easy way > to move (or even copy) a table from one database to another database (on the > same server). We are using SQL 2000.
From: Linchi Shea on 1 Jul 2008 15:38 You can always give DTS Import/Export wizard a try. In Enterprise Manager, right click on the server name -> All Tasks -> Import ... Linchi "Starfish" wrote: > I just discovered, the server we are moving the table from is running SQL 6.5 > - the server we are attempting to move the table to is running SQL 2000. > > "Starfish" wrote: > > > Hello, I'm very new with SQL. I wanted to find out if there was an easy way > > to move (or even copy) a table from one database to another database (on the > > same server). We are using SQL 2000.
From: Roy Harvey (SQL Server MVP) on 1 Jul 2008 15:41 First I would script the CREATE TABLE command in 6.5, and run it in the target database on 2000. The 6.5 management tool can generate the script for you. To move the data I suggest using the data import wizard, which will build a DTS process to perform the transfer. In SQL Server 2000's SQL Enterprise Manager, navigate to the database where you want to create the table. Right click on it, All Tasks, Import Data. For the source you will specify the 6.5 server, and the appropriate database. Since it is 6.5 you might have to try ODBC instead of OLE DB. As you proceed through the process specify the table you already created on the target SQL Server 2000 server. It is worth realizing that toward the end of the wizard process you have the option of saving your work so it can be run again, and modified, which I always find to be a good idea. Hope that is enough to get you started. Roy Harvey Beacon Falls, CT On Tue, 1 Jul 2008 10:36:08 -0700, Starfish <Starfish(a)discussions.microsoft.com> wrote: >Hello, I'm very new with SQL. I wanted to find out if there was an easy way >to move (or even copy) a table from one database to another database (on the >same server). We are using SQL 2000. >I just discovered, the server we are moving the table from is running SQL 6.5 >- the server we are attempting to move the table to is running SQL 2000. > >"Starfish" wrote: > >> Hello, I'm very new with SQL. I wanted to find out if there was an easy way >> to move (or even copy) a table from one database to another database (on the >> same server). We are using SQL 2000.
From: Starfish on 2 Jul 2008 13:44
Your directions were perfect. Thank you! "Roy Harvey (SQL Server MVP)" wrote: > First I would script the CREATE TABLE command in 6.5, and run it in > the target database on 2000. The 6.5 management tool can generate the > script for you. > > To move the data I suggest using the data import wizard, which will > build a DTS process to perform the transfer. > > In SQL Server 2000's SQL Enterprise Manager, navigate to the database > where you want to create the table. Right click on it, All Tasks, > Import Data. For the source you will specify the 6.5 server, and the > appropriate database. Since it is 6.5 you might have to try ODBC > instead of OLE DB. As you proceed through the process specify the > table you already created on the target SQL Server 2000 server. It is > worth realizing that toward the end of the wizard process you have the > option of saving your work so it can be run again, and modified, which > I always find to be a good idea. > > Hope that is enough to get you started. > > Roy Harvey > Beacon Falls, CT > > On Tue, 1 Jul 2008 10:36:08 -0700, Starfish > <Starfish(a)discussions.microsoft.com> wrote: > > >Hello, I'm very new with SQL. I wanted to find out if there was an easy way > >to move (or even copy) a table from one database to another database (on the > >same server). We are using SQL 2000. > > >I just discovered, the server we are moving the table from is running SQL 6.5 > >- the server we are attempting to move the table to is running SQL 2000. > > > >"Starfish" wrote: > > > >> Hello, I'm very new with SQL. I wanted to find out if there was an easy way > >> to move (or even copy) a table from one database to another database (on the > >> same server). We are using SQL 2000. > |