THE INFORMATION IN THIS ARTICLE APPLIES TO:
- Secure FTP Server v3.x
- EFT v6 and later
- EFT v7 and later
Refer to https://kb.globalscape.com/KnowledgebaseArticle10666.aspx for details of migrating a Secure FTP Server 3.3.10 configuration to
a new server running EFT v6, which includes all Event Rules, user
accounts, keys, and so on.
DISCUSSION
To update a Secure FTP Server 3 ODBC user database to work with EFT Server 6 and 7, you will need to add the SETTINGSLEVEL field to the FTPSERVER_USERS table, as described below.
- In the EFT administration interface, on the Site's General tab, locate the ODBC user database name.
- Open SQL Server Management Studio (or Oracle equivalent).
- Log into the SQL Server Management Studio using an account that is at least a DB Owner for the ODBC user account database (for Oracle, use schema owner).
- Do one of the following:
- For a SQL, in SQL Server Management Studio, execute the following commands upgrade the database:
USE [ODBC database name]
GO
ALTER TABLE FTPSERVER_USERS
ADD SETTINGSLEVEL VARCHAR(200) NULL
GO
- For Oracle, execute the following commands in the Oracle database console against the ODBC user database:
ALTER TABLE FTPSERVER_USERS
ADD SETTINGSLEVEL VARCHAR2(200);