huskerdoug
IS-IT--Management
Here is my scenario:
I wish to replicate a view (a) to another server (b). Server (b) will have a table that resembles a view but with additional columns for colecting outside data via Active Server Pages.
The information I'm replicating, from server (a), is being collected by 5 tables, which make up the view I'm trying to replicate.
My problem is that replication doesn't seem to be workin.
Can I replicate a view? To a table with the same schema?
Should I use DTS?
I'm new to SQL Server and need some advice.
Thank You!
I wish to replicate a view (a) to another server (b). Server (b) will have a table that resembles a view but with additional columns for colecting outside data via Active Server Pages.
The information I'm replicating, from server (a), is being collected by 5 tables, which make up the view I'm trying to replicate.
My problem is that replication doesn't seem to be workin.
Can I replicate a view? To a table with the same schema?
Should I use DTS?
I'm new to SQL Server and need some advice.
Thank You!
