how to transfer data from one sql server to another sql server

Hi...

Here is my doubt,

1. how can i transfer the data(Full Database) between two servers,
the servers are in two different locations....

Is there any tool for do this.....

some good ideas......

thanks

If the database does not exist on the destination side and the transfer is a one time thing, I think you could just take offline (or detach) the source database, copy over the data and log files to the destination server, and attach them back.

If the database already exists you could check out Import / Export features of Management Studio. This allows you to specifiy which tables you want to copy. (Although I think this will copy over just basic schema info and data -- permissions, triggers, etc. will not be copied.)

Hope this gives you a start.

|||

The Copy Database Wizard of ssms lets you move or copy databases and their objects easily from one server to another.

steps:

1)Open sql server management studio

2) right click on the database you want to copy

3)select "tasks"

4)select "copy database" which is at the last.

Regards

Rajesh Basa

sql