Update View from another database of another instance 
Author Message
 Update View from another database of another instance

Hi there,

I'm faced with a challenging task. I wonder if someone could guide me on how
I can accomplish it.

I have a view in a database - A
I need to update the records of this view based on the another similar table
which sits in another database (B1) of another instance. Update's set to all
other columns in A is only done if the Field PODNo of A matches the PODNo of

How can I accomplish this. Can stored procedure do the job?

If I were to code it in VB.Net,
How do I store my B1's records into an arraylist then using this arraylist,
populate my A table?

Tue, 26 Apr 2005 18:40:02 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Updating a database view from VB4

2. Updating a single OLE link for a record OR updating existing database

3. Updating unexposed field on single instance of recurring appointment

4. Updating a Combobox after Database Update

5. (DBGrid) Updating Appearance with out updating Database

6. updating controls on a form when database is updated

7. (DBGrid) Updating appearance without updating Database

8. Synchronising a prod database schema with an updated dev database

9. updating user database using server database

10. Updating records on Database #1 from another database #2

11. remove outlook view control security update

12. Problem with Updated View Control


Powered by phpBB® Forum Software