|
| | | Forum Newbie
Group: Forum Members
Last Login: 3/20/2008 9:04:32 AM
Posts: 8, Visits: 33 |
| | If we make an installation from scratch, we get the option to choose postgress or SQLServer database. If we have a 5.04 version installed, there is no option and postgress database is choosen automatically (but we should have SQLServer). Will this be changed for the official version? Thanks and Regards Frank |
| |
| | | Supreme Being
Group: Administrators
Last Login: 2 days ago @ 9:30:13 AM
Posts: 117, Visits: 185 |
| | Hello Frank, Excellent question. For new installs, it's pretty straightforward - you configure SQL during the installation. Upgrades are a little more involved, though we believe simpler. This may not be ideal for all users, but we really wanted to simplify the upgrade process. With 6 being a very major upgrade from the 5 series, the main goal was to successfully complete the "default" upgrade to the 6 series, getting everything running smoothly, before allowing options for changing things like the default database or the web server. To accomplish this, we broke the upgrade into 2 steps.
1) Upgrade from 5.04 to 6.1 by installing 6.1 and accepting the default PostgreSQL.
2) Run the dbconfig utility that ships with WS_FTP Server 6.1 with SSH which allows you to "swap out" db's and use SQL instead of PostgreSQL. This is the same utility used to configure high availability (clustering, load balancing, failover). SUMMARY: The ability to select SQL during an install exists for new 6.1 installs and anyone upgrading (from 5.04 or 6.0) must upgrade to 6.1 first (using the default PostgreSQL) and then run the dbconfig utility to convert to SQL Server. Hope that helps.
Kevin R Gillis
Ipswitch, Inc. |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 3/20/2008 9:04:32 AM
Posts: 8, Visits: 33 |
| | Hi Kevin When upgrading from 5.04 to 6.0 or 6.1 using postgres db, all user data is migrated either. If I "swap out" postgres with sqlserver, I guess all user data is lost. I can backup and restore a postgres db wih the scripts. But as I know it's not possible to restore it on a sqlserver db. The big problem is that I will loose my 400 user accounts, stored in the registry and in a sqldb (via odbc) on our 5.04 installation. Restore a postgress db backup into an sqlserver db would solve the problem. Is that possible, ... with converting the backup-file somehow? Thanks and Regards Frank |
| |
| | | Supreme Being
Group: Administrators
Last Login: 2 days ago @ 9:30:13 AM
Posts: 117, Visits: 185 |
| | Hello FrankG, if you upgrade to PostgreSQL and then run the dbconfig utility to convert to SQL, you will not lose any of your 400 accounts. It's good to do this sequentially. Backup your 5.04 data before upgrading to 6.1. Confirm the upgrade from 5.04 to 6.1 works to your liking. Then run dbconfig to "swap" out PostgreSQL and replace with SQL. All of the data will be moved from PostgreSQL to SQL - and the appropriate db schema and tables will automatically be created in SQL. Hope this helps.
Kevin R Gillis
Ipswitch, Inc. |
| |
|
|