| Author |
get data from SQL Server to another machine
|
|
|
| How can I get data and structure of a table on SQL Server 2000 on a machine
to re-build that table on a separated machine? I am building tests and I
don't want to mess up with the original one.
Thank you,
Paul
| |
|
|
"Tim" wrote:
> How can I get data and structure of a table on SQL Server 2000 on a machine
> to re-build that table on a separated machine? I am building tests and I
> don't want to mess up with the original one.
> Thank you,
>Tim
| |
| Sreejith G 2005-10-17, 1:24 pm |
| Select * into TempTable From OriginalTable,
This will create replica of OriginalTable in TempTable. And if you want it
in another server which is linked to this server, you can specify
servername.dbo.Temptable in above query. If its not linked, then export and
import using DTS.
"Tim" wrote:
> How can I get data and structure of a table on SQL Server 2000 on a machine
> to re-build that table on a separated machine? I am building tests and I
> don't want to mess up with the original one.
> Thank you,
> Paul
| |
|
| Thank you for your help. I now have a general idea about doing this. I
appreciate it!
"Sreejith G" wrote:
[color=darkred]
> Select * into TempTable From OriginalTable,
>
> This will create replica of OriginalTable in TempTable. And if you want it
> in another server which is linked to this server, you can specify
> servername.dbo.Temptable in above query. If its not linked, then export and
> import using DTS.
>
>
>
>
> "Tim" wrote:
>
| |
| Darren Gosbell 2005-10-17, 1:24 pm |
| You can also right click on a table in Enterprise Manager and choose All
Tasks -> Export Data. if you want to do a one off copy. This way you
don't have to set up linked servers.
--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|
|
|
|