Copying Tables Across Servers

I'm trying to copy data from a remote server connected thru enterprise
manager. I' assuming there shld be a means to script the table structure an
d
the contents. Is this possible and how can I go about it.
--
Beaversuse import/export wizard
"Beavers" wrote:

> I'm trying to copy data from a remote server connected thru enterprise
> manager. I' assuming there shld be a means to script the table structure
and
> the contents. Is this possible and how can I go about it.
> --
> Beavers
>|||I had problems with that because of the server names. Nevertheless I have
managed to copy with the age old copy and paste function.
Thanks!
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use import/export wizard
>
> "Beavers" wrote:
>

Copying Tables Across Servers

I'm trying to copy data from a remote server connected thru enterprise
manager. I' assuming there shld be a means to script the table structure and
the contents. Is this possible and how can I go about it.
Beavers
use import/export wizard
"Beavers" wrote:

> I'm trying to copy data from a remote server connected thru enterprise
> manager. I' assuming there shld be a means to script the table structure and
> the contents. Is this possible and how can I go about it.
> --
> Beavers
>
|||I had problems with that because of the server names. Nevertheless I have
managed to copy with the age old copy and paste function.
Thanks!
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use import/export wizard
>
> "Beavers" wrote:

copying a DB from one SQL Server to another SQL server which are not in the sam

Hello All,
I am new to SQL Server.

I want to copy a Database from my SQL server to another SQL server ,which are not connected in same LAN. The destination SQL server also has the same DB ,Table structures.

Can you suggest me any idea of doing this.

I would appriciate your fastest suggestion.

Thanks!!.Backup Database
Copy
Paste
Restore Database|||Originally posted by Enigma
Backup Database
Copy
Paste
Restore Database

Hi Enigma,
Thanks for your reply.

If I am not wrong ,the DBBackup will copy all the Tables in the DB.

Is it possible to take a backup of few tables from a DB.(This is what needed, sorry for not giving full information on my first question).|||Yup
1st server... script tables ... bcp out ...

2nd server ... run script ... bcp in|||Originally posted by Enigma
Yup
1st server... script tables ... bcp out ...

2nd server ... run script ... bcp in

Hi,
Please give some Examples using VB for the above.
thanx in advance. Looking forward for your reply.

Premnath