Create Tables on Remote Server ?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Create Tables on Remote Server ?

Create Tables on Remote Server ?

Rate Topic

Display Mode

Topic Options

Author

Message

homebrew01

Posted Sunday, January 06, 2013 6:54 PM

SSCrazy

Group: General Forum Members
Last Login: Sunday, June 16, 2013 9:23 AM
Points: 2,580, Visits: 7,292

Hi, what I would like to do is run a job on Server_A that will drop and repopulate tables on Server_B. I can use linked server to push data from A to B, and can drop a table remotely on Server_B, but can't run "Select * into table_a ..." to create & repopulate the table on server_b. I don't want to run the job on B to pull the data because B is a cloud server and I want reliable alerts from server_A if the job fails. The reason I want to drop & recreate the tables on B is in case there are any schema changes on server_A, I want them to get pushed to server_B.

This needs to be as foolproof and low maintenance as possible because I won't be available to babysit it. Perhaps snapshot replication would be a good candidate here ?

If a column gets added to table_A on server_A, will snapshot replication automatically push the new schema & data to server_b ? EDIT: i think the answer is "yes" if "replicate schemas" is checked.

Post #1403392

« Prev Topic | Next Topic »

Permissions