Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
9
Erster Beitrag:
vor 6 Jahren, 2 Monaten
Letzter Beitrag:
vor 6 Jahren, 2 Monaten
Beteiligte Autoren:
DanM , Piet van Zanten, Arie, Peter Holemans, Jimbo , Al

WD16: How do you move the HFCS database on development machine to a server?

Startbeitrag von DanM am 04.05.2012 22:31

This is a continue of my journey from http://27130.foren.mysnip.de/read.php?27131,129485

Guenter's program on connecting to a server work perfectly but I was unable to connect to the database on my development machine due to internal firewalls (I spent 2 days with no success).

So I got a test server andset up a HF Client Server on it.

Now I need to get the Database and datafiles from my development machine to the server.

Again, I am reading lots of help screens but have not found one that clearly explains how to move the datafiles and database to the server?

Any help and directly is greatly appreciated...

Dan

Antworten:

Hi Dan,

I found no way to import a hfcs database from one server to another, so what I'm using is the import a classic database option (right click on the server in the tree).
If the servers are on the same network, you can just point to the BDD directory of the original server where the file reside, otherwise you have to copy these files to an usb device. You also need the analysis.

Regards,
Piet

von Piet van Zanten - am 05.05.2012 07:52
Quote
DanM
This is a continue of my journey from http://27130.foren.mysnip.de/read.php?27131,129485

Guenter's program on connecting to a server work perfectly but I was unable to connect to the database on my development machine due to internal firewalls (I spent 2 days with no success).

So I got a test server andset up a HF Client Server on it.

Now I need to get the Database and datafiles from my development machine to the server.

Again, I am reading lots of help screens but have not found one that clearly explains how to move the datafiles and database to the server?

Any help and directly is greatly appreciated...

Dan


Hi Dan, I'd try to make a backup - using HF Control Center - from HFCS database A and restore this backup on database B. If that doesn't work, I'd try to see the files in the \BDD folder as 'Classic' files and import them with HF CC. Regards, Guenter

von Jimbo - am 05.05.2012 08:15
Hello Piet

I have only played with the HFCS but my impression was that because PCSoft support an application switch at will between HF Classic and HFCS it meant the HFCS engine was just a wrapper around a set of standard HF Classic files.

If that is the case couldn't you just copy and paste the Fic,Ndx and Mmo files onto the new server and then load the HFCS engine onto that server and tell it to us those files ?

Regards
Al

von Al - am 05.05.2012 11:37
Hi Al,

I have done a simple copy and it seemed to work, but just to be sure I use the import option, because it uses the analysis. I'm assuming that it's better, because HFCS needs to import the integrity rules from the analysis.

Regards,
Piet

von Piet van Zanten - am 05.05.2012 12:07
Hi Piet, Al,

The copy of HF Classic files into a DB directory in \BDD works fine.
However, to make sure all is OK just:
1) Via HF CC: Maintain database option 4 (Re-indexing and all that stuff)
2) Via your Analysis in the IDE do a 'File Structure Update' (somewhere in the menu) of the database on the server. This will make sure that all contraints etc are well copied to the HFCS system.

Cheers,

Peter

von Peter Holemans - am 05.05.2012 12:26
Hello All,

Thank you for your input and suggestions.

I did just copy the files from the development machine to the server using GoToMyPC's file transfer and ... it all works. Some times it is too simple I cannot believe it!

My concern going forward is that now as the user are finding items to improve, we are modifying the Analysis in development. Meanwhile the users are adding and modifying data on the Live server.

So at this point I cannot just copy over the data files from the development machine as I will loose all the adds, edits, and delete that have been done to the Live data.

I am new to the processes for WinDev (6 weeks now), but during the last 2 years I have been developing in WebDev ... when I uploaded the site to the server, part of the process was it automatically modified the data files if the Analysis was modified since the last upload. This allowed users to continue working with the data and the ability to continue improving the data files to support our new needs.

Is there a way to do this using WinDev?

Any input and suggestion are always appreciated!

Dan

von DanM - am 06.05.2012 19:13
Dan,
for WD it is the same. If you use the build-in installer to create a setup for you, it will add these modification steps.
However, to get your hands on it, I would advice you to do it yourself the first time(s). Just to learn what is happening.
Basicly the same proces is started when developing. Whenever you change your analysis the ide is asking you if you want to start the modification proces.

In all cases a utility called 'wdmodfic' is started. Try to locate it in your WD-map and start it yourself. I think you will get the idea.
The setup does the same. It includes this utility and start it during setup.

If you are familiair with it, you can even start it from you own software. I keep track of the version myself and whenever I detect a new version is started the first time, I start (using ExeRun() ) wdmodfic with a bunch of commandline options. Then it runs fully automated for just the database I want (sometimes my users have different database, using different version of my software)

von Arie - am 07.05.2012 07:25
Thank you Arie

von DanM - am 07.05.2012 12:44
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.