copying the whole table from one server to another server [modified]

venu656

Hi Experts iam having two sqlservers .where i want to move entire table from the server1 database with the data to anothers server(server2) datbase using query .plz guide me...... regards venu

modified on Friday, July 24, 2009 5:55 AM

DoctorMick · modified on Friday, July 24, 2009 5:55 AM

You could use SSIS or linked servers.

venu656

i know using linked servers but using query i shuld get it becoz this query is used in c#..... to execute so many tables ...

Robin_Roy

Hey Venu, Please elaborate a bit more on what exactly are you looking for inside your C# code. Are you trying to transfer data between different databases having identical schema from inside your C# code or you want to query different database at the same time??? Robin

venu656

hi robin. actual i want to transfer the entire table structure along with datafrom local sqlserver to hosting sqlserver using c#

icanmakeiteasy · modified on Friday, July 24, 2009 5:55 AM

hi venu, server1 database structure is static or dynamic??

icanmakeiteasy

venu656

Server1 is static server

Mycroft Holmes

This is usually achieved by backing up the local database and restoring it on the host. Additionaly you can script the database and uses SSIS to move the data Or use SQL Compare from http://www.red-gate.com/index.htm?gclid=CLDSwcDM6JsCFcItpAod-kAU5Q to move the code and Data Compare to move the data. This is what I use.

Never underestimate the power of human stupidity RAH

icanmakeiteasy

then if the table structure is static create a script file for server1 database.., read that file from c#, then manipulate it...

icanmakeiteasy