Copy View From DBC-1 to DBC-2

[JRB-Bldr]

I saw that Tamar had a tutorial on Copying a View from one DBC to another DBC posted on the web, but that link is no longer available.

And I did not find it in my Tek-Tips search.

Therefore, without anything else to refer to, can anyone tell me how to Copy a View from one DBC to a different one?

Thanks,
JRB-Bldr

 

[markros]

You can save View script to a file and run it against different database. If you use View Editor by Steve Saywer, then it has this functionality, otherwise one of the ways would be to use GenDBC utility to get view script.

 

[TamarGranor]

I don't remember having such a tutorial, but you should be able to do something using DBGetProp() to retrieve the view's settings and then use CREATE VIEW and DBSetProp() to create the new view.

Tamar

 

[JRB-Bldr]

Hello Tamar,

If you do a Google search for
"copy view" vfp
your previous article/tutorial pops up as the first find.

It's URL used to be:

http://zones.advisor.com/dMSVFP001....29D760FD92FE54B7B6491D233DCBB3C1?OpenDocument

But it is a "dead end" link now.

Everyone - thanks for the suggestions.
I have a new remote system to add and I need to copy quite a few of the existing Views into a new system-specific database. A "short-cut" would have been convenient, but I can always do it the "hard way".

Thanks,
JRB-Bldr

 

[Mike Lewis]

JRB-Bldr,

I haven't tested this, but you should be able to do something like the following:

SET DATABASE TO SourceDBC
lcSQL = DBGETPROP("MyView","VIEW","SQL")
SET DATABASE TO TargetDBC
CREATE SQL VIEW MyView &lcSQL

That would create the basic view. You could then use a similar technique if you need to copy any of the properties, such as the update criteria.

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Olaf Doschke]

To copy the view, markros already pointed out some tools, eView (UT Download) is another one. Perhaps the easiest way would be copying the whole DBC, then dropping the tables and views you don't need in that copied DBC.

Bye, Olaf.

 

[pthalacker]

One other suggestion is to use the View SQL code window.
-Open the view in the view designer, right click on the data table section and select "View SQL" from the shortcut menu.
-Copy all the code from the resulting code window.
-Go to the target database.
-Open the view designer and select "New Local View" from the same shortcut menu.
-Close the resulting "Add a Table or View" dialog.
-Open the "View SQL" code window in View Designer of the target database. (It will be empty)
-Paste your code and save the view.

pamela

 

[TamarGranor]

Wow, I don't remember that at all. Looks like it was probably in the Q&A column. It's not in my list of my articles at my website (

http://www.tomorrowssolutionsllc.com/articles.htm),

so it must have been before June '98, which is as far back as I've found the time to go.

Tamar

 

[Imaginecorp]

JRB-Bldr:

Keep it simple, Use Pamelas suggestion...short and effective... Just make sure in the SQL code you change the name of the database to that of the new one...