Friday, March 23, 2012

Saving and Restoring a SQL SERVER Table

Can anyone tell me how I can save or copy a SQL Server table and restore it
on another system?
I am running SQL Server 2000.
I see how I can export it to another database on my machine. But I need to
copy the table to another PC.
Any help is appreciated.
Ron
Hi
If you can export it into it's own database then a backup can be made and
restored on the other PC.
If the whole database is not big, then just take the whole backup. It is not
clear why you want the one table and not a whole consistent backup!
http://support.microsoft.com/kb/304692/EN-US/
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
> it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
> to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>
|||John
I only need one table to test with at another location.
I want to be able to copy one table to a floppy and then restore.
The backup option copies the whole database.
How can this be done?
"John Bell" wrote:

> Hi
> If you can export it into it's own database then a backup can be made and
> restored on the other PC.
> If the whole database is not big, then just take the whole backup. It is not
> clear why you want the one table and not a whole consistent backup!
> http://support.microsoft.com/kb/304692/EN-US/
> John
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
>
>
|||DTS can copy individual tables and their data to databases
on different servers.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> Can anyone tell me how I can save or copy a SQL Server table and restore
it
> on another system?
> I am running SQL Server 2000.
> I see how I can export it to another database on my machine. But I need
to
> copy the table to another PC.
> Any help is appreciated.
> Ron
>
|||I assume DTS stands for Data Transformation Service but that still doesn't
give me a clue how to save and restore an individual table.
"Armando Prato" wrote:

> DTS can copy individual tables and their data to databases
> on different servers.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:3AD5917E-4CFF-4A6C-8DC3-54E98F92E6C6@.microsoft.com...
> it
> to
>
>
|||Why do you need to save it and restore it? I think if worse came to worse,
you
could place it on it's on filegroup and go that route.
With DTS, you can copy the table directly and not jump through any hoops.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...[vbcol=seagreen]
> I assume DTS stands for Data Transformation Service but that still doesn't
> give me a clue how to save and restore an individual table.
> "Armando Prato" wrote:
restore[vbcol=seagreen]
need[vbcol=seagreen]
|||Are you going to tell me how to do that with DTS or do you just want to keep
me in suspence?
I already explained why I need to save & restore?
"Armando Prato" wrote:

> Why do you need to save it and restore it? I think if worse came to worse,
> you
> could place it on it's on filegroup and go that route.
> With DTS, you can copy the table directly and not jump through any hoops.
> "Ron" <Ron@.discussions.microsoft.com> wrote in message
> news:893AFAE7-4648-4A1D-81AD-9F23559BDCC0@.microsoft.com...
> restore
> need
>
>
|||Well, you could've done a wee bit of leg work and researched DTS.
DTS is a very simple tool that can be accessed right from
the Microsoft SQL Server folder on your server. The folder
entry is called "Import and Export Data". From there a wizard
launches that asks you your source and destination servers along
with a screen that lists all available tables on the source where you check
off the
one you want to export.
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:DC936A64-DF31-45CB-B560-AADE917754B7@.microsoft.com...
> Are you going to tell me how to do that with DTS or do you just want to
keep[vbcol=seagreen]
> me in suspence?
> I already explained why I need to save & restore?
> "Armando Prato" wrote:
worse,[vbcol=seagreen]
hoops.[vbcol=seagreen]
doesn't[vbcol=seagreen]
I[vbcol=seagreen]
|||Hi
The point was that you can create a new database and copy the one table into
that. Then you backup contains the one table. You can then restore that
database and if necessary copy the table again. Alternatives would be to to
script the table and use DTS or BCP to export the data.
You may want to use a CD or USB flash device if this data/backup is bigger
than 1.44 MB.
John
"Ron" <Ron@.discussions.microsoft.com> wrote in message
news:CA95E845-DA13-4589-BAEC-D0B2852ED2CB@.microsoft.com...[vbcol=seagreen]
> John
> I only need one table to test with at another location.
> I want to be able to copy one table to a floppy and then restore.
> The backup option copies the whole database.
> How can this be done?
> "John Bell" wrote:

No comments:

Post a Comment