Servoy requires five databases to run. You will need to create 5 new databases with the following names:
repository_server
log_server
migration_server
user_data
example_data
For purposes of this article, we will also create a database called crm to hold the default crm solution that ships with Servoy.
End quote
The ISP does not allow the use of “_” in their mysql db name creation form, so the above db’s cannot be created if they are required. Do you have to use those exact db names?
How would I get the Servoy server to start on the isp machine if I do not have telnet access to the hosting computer? Here are the stats relating to the db support and admin. http://lfchosting.com/index.shtml
SQL Server 2000 and MySQL Support
MS SQL Server 2000 and MySQL are standard software packages for managing large databases through SQL, particularly using ASP. SQL 2000 is the newest Microsoft SQL solution, offering many advantages over MS SQL 7.0, and is beginning to gain support by the hosting industry.
SQL is much faster than ODBC, and is therefore useful for managing large databases.
All of our business-level plans include 25 MB on our dedicated SQL server providing the fastest possible access to SQL databases. SQL space is considered independent from the web space included with our hosting plans, whereas many hosts consider it as part of the normal web space quoted with a hosting plan. Database access rights, etc. can be managed using the SQL Enterprise Manager remotely (SQL Server 2000 only) or through scripting (ASP or otherwise), whereas most competing services limit you to the latter.
LFC Hosting offers superior SQL Server and MySQL database administration with the ability to manage database DSNs, users, and user permissions, view database statistics, download and restore database backups, all on the fly through your account control panel.
All our SQL servers have multiple SCSI hard disks in a RAID configuration for the fastest response time and highest reliability. A RAID configuration means that the information is spread across the hard disks in such a way that the loss of one hard disk does not mean the loss of any data. All SQL Servers are backed up daily to a Backup server that is connected via a separate Gigabit Ethernet connection. All of this means better service for you!
How would I move my data from the existing sybase db’s into the mysql db’s?
Would it be better to skip using mysql and have them provide support for sybase?
This is one wicked post.
It’s an advertisement wrapped in a bunch of questions.
And it’s not clear if you are a customer of that ISP or working for it/owning it since you talk about “we” and “the ISP”.
Bryan Gelyk:
2. The ISP does not allow the use of “_” in their mysql db name creation form, so the above db’s cannot be created if they are required. Do you have to use those exact db names?
As Marcel already answered you can use different names for the databases.
Servoy uses named database connections. Those connection names should be left untouched. The connection settings however can be changed at will.
Bryan Gelyk:
3. How would I get the Servoy server to start on the isp machine if I do not have telnet access to the hosting computer? Here are the stats relating to the db support and admin. http://lfchosting.com/index.shtml
You ask a question and then refer to something unrelated and give an URL to the homepage of the ISP you are talking about.
Anyway it’s up to the (ISP) admin of the box to let Servoy server launch at startup. The ISP customer shouldn’t have to do that unless they (you?) offer dedicated hosting.
Bryan Gelyk:
SQL is much faster than ODBC, and is therefore useful for managing large databases.
Not sure what you are talking about here.
Are you referring to SQL Server or the query language SQL?
Either way you are comparing apples and oranges and therefore your conclusion is moot.
Bryan Gelyk:
4. How would I move my data from the existing sybase db’s into the mysql db’s?
The easy way is to simply export your solutions with data (up to 10,000 rows per table) and import the solution on your new server.
Only thing you need to do is make a named connection on your server and create a database. The tables will be created and filled when Servoy imports the solution.
If your dataset is larger then that you need to use ETL tools to dump the data and import it into the new server. For Sybase iAnywhere you can use SQL Anywhere Studio for this.
Bryan Gelyk:
5. Would it be better to skip using mysql and have them provide support for sybase?
Any database engine that supports transactions can be used.
So it’s a matter of preference.
I don’t mind advertising an ISP that supports Servoy. In fact I applaud it.
But in the form this is done bothers me a bit. (as you probably had noticed)
I would like everyone to know that I am not in anyway trying to promote an ISP.
The “we” refers to Morley at 7office and I. He has contracted me to find the best way to have his solution hosted. I cut and pasted the blub out from his ISP’s support page hoping to give as much info as possible, so someone could point me in the right direction.
Question 3 should have read something like – Help!!! I do not have a clue as to the best database server to use. Morley’s ISP has several available, which is the best to use or should he just co-host his server?
Hoping honesty here is the best policy.
Thanks for the great reply, I totally agree about your stand on ISP promotion, I get enough spam, don’t need more here.
When researching how to remotely host an Servor solution I found this article when searching Servoy. I quoted the part I did not understand. I can see making the “repository_server” because that is where Servoy keeps the solution files. I can also see making the actual solutions database file to hold the data. But, why do I need to make these other databases as stated in the acticle?
Reason for asking – Hosting ISP limits the number of hosted db’s and charges bases on number of db’s and size. I need to know the minumum requirements so I can figure out if the correct method of hosting would be having the ISP serve the data or co-hosting a Servoy only machine. I should have been more clear here, sorry.
To contact databases, servoy uses Database Servers as can be set up in the Servoy properties file or in the preferences panel of Servoy Developer. This gives Servoy all the information necessary to talk to a BACKEND SQL database.
The BACKEND SQL database is an arbitrary SQL database with an arbitrary name. You could have a postgres database, mysql database, oracle database, sqlserver database, whatever.
Servoy needs at least 1 or 2 SERVOY Database Servers (that is, entries pointing to real SQL databases), and these entries must be named repository_server and log_server (if logging is used). They cannot be named anything else.
However, these SERVOY Database Servers can point to ANY backend database with ANY name whatsoever, with as many or as few underscores as you like. That is, the repository_server entry can point to (using the Database Server URL property in the preference panel, or the server..URL property in the servoy.properties file, to the URL
jdbc:postgresql://localhost/myrepositorydb
Note that it does NOT need to contain underscores, and it can have ANY name you wish.
Also note that if you put this in the servoy.properties file you must precede every : (colon) with a \ (backslash).