Moving Table to another SQL server using Linked Server

Hi,

I can't seem to find any information on how exactly to do this. Basically I want to move a particular table on my DB to a remote SQL server, and have write operations (destined for that table) to be written directly to the table on the remote server.

How is this done?

Thanks in advance.

If you have set up one server as a linked server, you should be able to set up one of your tables just as a view, so that operations that happen to it actually happen on the underlying one (on the remote server).

That's the theory at least, and it ought to work, but you should be wary of network latency and things like that. You may find it just doesn't perform well enough, and that you need some sort of a process which polls the table on your database for changes that need to be written back. But then the tables won't be perfectly in sync (for obvious reasons).

Robsql

moving table from one drive to other in sql server 2000

Hi
I wanted the know the syntax, how we can move a particular table (lets say a
database having two filegroup in c, d drive) from c: drive to d: drive
without detaching that particular databaseHello,
If you have a clustered index on that table use CREATE INDEX with
DROP_EXISTING on your clustered index specifying new filegroup. THis will
move the table, data
and clustered index to the new filegroup (Data always follws the clustered
index). Incase if you do not have one then craete it temporarly on the new
file group
and drop it after.
Syntax:-
CREATE CLUSTERED INDEX <Clust_idx_name> ON Table_name
(COlumn_name) WITH DROP_EXISTING ON "NewFileGroup"
For non clustered index you could use DROP_Existing on the Create index
statement to move it to new filegroup.
Thanks
Hari
"shiva" <shiva@.discussions.microsoft.com> wrote in message
news:3EB80D03-5B8B-4032-88B5-5789B3966A5F@.microsoft.com...
> Hi
> I wanted the know the syntax, how we can move a particular table (lets say
> a
> database having two filegroup in c, d drive) from c: drive to d: drive
> without detaching that particular database

moving table from one drive to other in sql server 2000

Hi
I wanted the know the syntax, how we can move a particular table (lets say a
database having two filegroup in c, d drive) from c: drive to d: drive
without detaching that particular database
Hello,
If you have a clustered index on that table use CREATE INDEX with
DROP_EXISTING on your clustered index specifying new filegroup. THis will
move the table, data
and clustered index to the new filegroup (Data always follws the clustered
index). Incase if you do not have one then craete it temporarly on the new
file group
and drop it after.
Syntax:-
CREATE CLUSTERED INDEX <Clust_idx_name> ON Table_name
(COlumn_name) WITH DROP_EXISTING ON "NewFileGroup"
For non clustered index you could use DROP_Existing on the Create index
statement to move it to new filegroup.
Thanks
Hari
"shiva" <shiva@.discussions.microsoft.com> wrote in message
news:3EB80D03-5B8B-4032-88B5-5789B3966A5F@.microsoft.com...
> Hi
> I wanted the know the syntax, how we can move a particular table (lets say
> a
> database having two filegroup in c, d drive) from c: drive to d: drive
> without detaching that particular database

moving table from one drive to other in sql server 2000

Hi
I wanted the know the syntax, how we can move a particular table (lets say a
database having two filegroup in c, d drive) from c: drive to d: drive
without detaching that particular databaseHello,
If you have a clustered index on that table use CREATE INDEX with
DROP_EXISTING on your clustered index specifying new filegroup. THis will
move the table, data
and clustered index to the new filegroup (Data always follws the clustered
index). Incase if you do not have one then craete it temporarly on the new
file group
and drop it after.
Syntax:-
CREATE CLUSTERED INDEX <Clust_idx_name> ON Table_name
(COlumn_name) WITH DROP_EXISTING ON "NewFileGroup"
For non clustered index you could use DROP_Existing on the Create index
statement to move it to new filegroup.
Thanks
Hari
"shiva" <shiva@.discussions.microsoft.com> wrote in message
news:3EB80D03-5B8B-4032-88B5-5789B3966A5F@.microsoft.com...
> Hi
> I wanted the know the syntax, how we can move a particular table (lets say
> a
> database having two filegroup in c, d drive) from c: drive to d: drive
> without detaching that particular database