http://www.ispirer.com/wiki/ 2012-02-05T00:38:33+03:00 http://www.ispirer.com/wiki/ http://www.ispirer.com/wiki/lib/images/favicon.ico text/html 2011-10-18T16:59:33+03:00 leonov http://www.ispirer.com/wiki/sqlways/command-line/sqlways-ini/ddl-section?rev=1318942773&do=diff SQLWays Product Page Free Evaluation This article describes sqlways.ini file [DDL] section and the options it contains. Option name Description GENERATE_DROP_TABLE If Yes is specified, the DROP TABLE statement is generated before each CREATE TABLE statement. The default value is No. Possible values - Yes, No. DROP_TABLE_CASCADE_CONSTRAINTS If Yes is specified, the CASCADE CONSTRAINTS option is generated in the DROP TABLE statement. Currently this option is supported by Oracle only. … text/html 2011-09-20T13:45:05+03:00 ispirer http://www.ispirer.com/wiki/sqlways/sql-server/data-types/datetime2?rev=1316511905&do=diff SQLWays Product Page - Migration to SQL Server Free Evaluation Versions: SQL Server 2008 SQL Server - DATETIME2 Syntax DATETIME2[(p)] Data Date and time data (year, month, day, hours, minutes, seconds and fractional seconds) Parameters p is the number of digits in the fractional part of second, 0 <= p <= 7 Default p is 7 (100 nanoseconds) Range January 01, 0001 00:00:00.0000000 to December 31, 9999 11:59:59.9999999 (100 nanoseconds accuracy) Version Differences DATETIME2 is av… text/html 2011-08-05T13:39:21+03:00 roman http://www.ispirer.com/wiki/sqlways/powerbuilder/extracting-source-from-files?rev=1312537161&do=diff SQLWays Product Page - PowerBuilder Conversion Free Evaluation In order to perform the conversion of the PowerBuilder application first you need to extract the script files of which each PowerBuilder Library (PBL) file consist. These are the files containing the definition of each object used in the application. There is two ways to do this task using tool developed by our team or do ut manually from PowerBuilder. text/html 2011-07-05T17:31:08+03:00 leonov http://www.ispirer.com/wiki/sqlways/troubleshooting-guide/postgresql/export-conversion/no_columns_in_result_set?rev=1309872668&do=diff SQLWays Product Page - Migration to PostgreSQL Free Evaluation Symptoms During the export of tables from PostgreSQL database through the ODBC connection the following message arises: “There are no columns in the result set”. Cause PostgreSQL ODBC DSN is not properly tuned on your PC. text/html 2011-07-05T17:21:40+03:00 leonov http://www.ispirer.com/wiki/sqlways/troubleshooting-guide/postgresql/export-conversion?rev=1309872100&do=diff SQLWays Product Page - Migration to PostgreSQL Free Evaluation * There are no Columns in the Result Set SQLWays Product Page - Migration to PostgreSQL Free Evaluation text/html 2011-07-05T17:20:11+03:00 leonov http://www.ispirer.com/wiki/sqlways/troubleshooting-guide?rev=1309872011&do=diff SQLWays Migration Product Page Free Evaluation Troubleshooting Guide * Oracle * Import * TNS:listener could not find available handler for requested type of server * 'sqlplus' is not Recognized as an Internal or External Command, Operable Program or Batch File text/html 2011-07-05T17:19:41+03:00 leonov http://www.ispirer.com/wiki/sqlways/troubleshooting-guide/postgresql?rev=1309871981&do=diff SQLWays Product Page - Migration to PostgreSQL Free Evaluation * Export and Conversion * There are no Columns in the Result Set * Import * 'psql.exe' is not Recognized as an Internal or External Command, Operable Program or Batch File text/html 2011-07-05T17:19:05+03:00 leonov http://www.ispirer.com/wiki/sqlways?rev=1309871945&do=diff SQLWays Migration Product Page Free Evaluation Database Migration * Oracle * Microsoft SQL Server * IBM DB2 * MySQL * PostgreSQL * Sybase * Informix * Teradata * HP Neoview * Interbase/Firebird Application Conversion * Microsoft .NET * Visual Basic * Progress 4GL and OpenEdge ABL * PowerBuilder * Delphi