Copying tables

I have a dual boot system with SQL Server 2000 on each operating system. I
would like to copy tables from one system to the other.
The problem is that when one os is running the other is not available. I
could create scripts to recreate all the tables, export data to a text file,
and then import the data into the newly created tables.
Is there an easier way?
TIA
DavidAre you wanting to copy all tables? How about a backup and restore?
Ray Higdon MCSE, MCDBA, CCNA
--
"David Rose" <drose2929@.yahoo.com> wrote in message
news:equf4qAnDHA.2364@.TK2MSFTNGP11.phx.gbl...
> I have a dual boot system with SQL Server 2000 on each operating system.
I
> would like to copy tables from one system to the other.
> The problem is that when one os is running the other is not available. I
> could create scripts to recreate all the tables, export data to a text
file,
> and then import the data into the newly created tables.
> Is there an easier way?
> TIA
> David
>|||Hi
You should be able to attach the databases from SQL Server on second OS
instance to the SQL Server instance on the first, they will always be up to
date.
John
"David Rose" <drose2929@.yahoo.com> wrote in message
news:equf4qAnDHA.2364@.TK2MSFTNGP11.phx.gbl...
> I have a dual boot system with SQL Server 2000 on each operating system.
I
> would like to copy tables from one system to the other.
> The problem is that when one os is running the other is not available. I
> could create scripts to recreate all the tables, export data to a text
file,
> and then import the data into the newly created tables.
> Is there an easier way?
> TIA
> David
>|||Ray,
No, not all the tables. However, I could do that and take what I need after
the restore.
Is there something like writing the tables to a structured storage file?
That would be ideal.
Thanks.
David
"Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
news:OAQwZ8AnDHA.2652@.TK2MSFTNGP09.phx.gbl...
> Are you wanting to copy all tables? How about a backup and restore?
>
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "David Rose" <drose2929@.yahoo.com> wrote in message
> news:equf4qAnDHA.2364@.TK2MSFTNGP11.phx.gbl...
> > I have a dual boot system with SQL Server 2000 on each operating system.
> I
> > would like to copy tables from one system to the other.
> >
> > The problem is that when one os is running the other is not available.
I
> > could create scripts to recreate all the tables, export data to a text
> file,
> > and then import the data into the newly created tables.
> >
> > Is there an easier way?
> >
> > TIA
> >
> > David
> >
> >
>|||> Is there something like writing the tables to a structured storage file?
> That would be ideal.
Nope. To get at the table level, you would need to generate script to get the table structure and
then BCP or similar for the data. Or use some of the tools that generate INSERT statements from an
existing table:
http://vyaskn.tripod.com/code.htm#inserts
http://rac4sql.net/objectscriptr_main.asp
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"David Rose" <drose2929@.yahoo.com> wrote in message news:uT%23EJSBnDHA.964@.TK2MSFTNGP10.phx.gbl...
> Ray,
> No, not all the tables. However, I could do that and take what I need after
> the restore.
> Is there something like writing the tables to a structured storage file?
> That would be ideal.
> Thanks.
> David
>
> "Ray Higdon" <rayhigdon@.higdonconsulting.com> wrote in message
> news:OAQwZ8AnDHA.2652@.TK2MSFTNGP09.phx.gbl...
> > Are you wanting to copy all tables? How about a backup and restore?
> >
> >
> >
> > --
> > Ray Higdon MCSE, MCDBA, CCNA
> > --
> > "David Rose" <drose2929@.yahoo.com> wrote in message
> > news:equf4qAnDHA.2364@.TK2MSFTNGP11.phx.gbl...
> > > I have a dual boot system with SQL Server 2000 on each operating system.
> > I
> > > would like to copy tables from one system to the other.
> > >
> > > The problem is that when one os is running the other is not available.
> I
> > > could create scripts to recreate all the tables, export data to a text
> > file,
> > > and then import the data into the newly created tables.
> > >
> > > Is there an easier way?
> > >
> > > TIA
> > >
> > > David
> > >
> > >
> >
> >
>|||Hi
If the database is available on the second OS then a DTS job can be
scheduled to transfer the data/tables required.
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:bnhjj7$4bf$1@.titan.btinternet.com...
> Hi
> You should be able to attach the databases from SQL Server on second OS
> instance to the SQL Server instance on the first, they will always be up
to
> date.
> John
> "David Rose" <drose2929@.yahoo.com> wrote in message
> news:equf4qAnDHA.2364@.TK2MSFTNGP11.phx.gbl...
> > I have a dual boot system with SQL Server 2000 on each operating system.
> I
> > would like to copy tables from one system to the other.
> >
> > The problem is that when one os is running the other is not available.
I
> > could create scripts to recreate all the tables, export data to a text
> file,
> > and then import the data into the newly created tables.
> >
> > Is there an easier way?
> >
> > TIA
> >
> > David
> >
> >
>