Copying a view from one db to another

Yahoo Archive
#1
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]
#2
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@...





[Non-text portions of this message have been removed]