Dolores,
I copy the sql statement in word (as a matter of fact, I copied it from
Epicor's documentation on views - 6.1) and paste it once I connect to
the right database.
I think that is easier than trying to copy the view from database to
database.
Good luck.
Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Hernandez, Dolores
Sent: Friday, May 04, 2007 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] copying a view from one db to another
I am trying to copy my customer view in one database into our test
database using SQL Explorer Tool. Can anybody tell me how to do that?
Thanks.
____________________
Dolores Hernandez
IT Department
Energy Cranes, LLC
713-896-5178
dhernandez@... <mailto:dhernandez%40energycranes.com>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
I copy the sql statement in word (as a matter of fact, I copied it from
Epicor's documentation on views - 6.1) and paste it once I connect to
the right database.
I think that is easier than trying to copy the view from database to
database.
Good luck.
Mario E. Aguirre - IT Manager
Lakin General Corporation, Inc.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Hernandez, Dolores
Sent: Friday, May 04, 2007 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] copying a view from one db to another
I am trying to copy my customer view in one database into our test
database using SQL Explorer Tool. Can anybody tell me how to do that?
Thanks.
____________________
Dolores Hernandez
IT Department
Energy Cranes, LLC
713-896-5178
dhernandez@... <mailto:dhernandez%40energycranes.com>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]