QueryCAT Logo
Search 5,000,000+ questions and answers.

Frequently Asked Questions

I have a ODBC data source. Can I migrate from it to InterBase/Firebird?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
ODBC (Open DataBase Connectivity) is an open standard interface to access databases developed by Microsoft. The most database management systems have their own ODBC driver or the one developed by other software producers. To migrate from ODBC data source you need to use Data Pump for InterBase/Firebird tool. You can start Data Pump from STUDIO by choosing Data Manipulation tab and then clicking on Data Pump for InterBase/Firebird.

From which databases can I migrate to InterBase/Firebird with the help of STUDIO?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
With the help of Data Pump for InterBase/Firebird you can migrate from any databases to which you can connect over OLE DB Provider (for example SQL Server, Oracle, MS Access, DB2, etc.) and ODBC Driver (MySQL, PostgreSQL, dbase files, etc.) STUDIO has a powerful instrument for generating test data - Data Generator. The Wizard will help you to set such parameters as the amount of lines to be generated, range value for each field, the quantity of lines with NULL value and others.

Can I synchronize metadata and data between different InterBase/Firebird versions?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
To launch DB Comparer from STUDIO, please, choose Data Analysis tab and click on DB Comparer for InterBase/Firebird, or go to Start->Programs->EMS->SQL Studio for InterBase/Firebird-> DB Comparer for InterBase/Firebird-> DB Comparer for InterBase/Firebird.

Why do recovered files contain less data than the original InterBase/Firebird database?

OfficeRecovery.com - InterbaseRecovery - FAQ
This is normal. The damaged parts of your InterBase/Firebird database will convert to zero size on output. The other common reason of file size decrease is when some of features of the original InterBase/Firebird database are not supported and therefore appropriate data is absent from the resulting files. Demo-recovered files mostly consist of demo placeholders than actual data from the original InterBase/Firebird database.

What is an ODBC data source?

EAO Template
A data source is a source of data and the connection information needed to access that data. Examples of data sources are Microsoft Access, Microsoft SQL Server, Oracle RDBMS, a spreadsheet, and a text file. Examples of connection information include server location, database name, logon ID, password, and various ODBC driver options that describe how to connect to the data source.

What is EMS SQL Manager for InterBase/Firebird?

SQL Manager | EMS SQL Manager for InterBase/Firebird | Produ...
EMS SQL Manager for InterBase/Firebird is a high-performance tool for administering InterBase and Firebird. It provides an easy-to-use graphical interface for maintaining databases and database objects, managing table data, building SQL queries, administering users and their privileges, extracting, printing, and searching metadata, etc.

Why cannot I connect to the local InterBase/Firebird Server?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
There are several reasons why you cannot connect to the local database. If during connection you get the error "Connection failed. Server is stopped or unproper client library is used to establish connection to the server. SQLCode: -904 IB Error Number: 335544375", then you should check if the port or service used for server connection is set correctly and if a local server is running.

Why cannot I connect to a remote InterBase/Firebird server?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
There could be several possible reasons that prevent you from successful connection to remote database. If the error message says "Connection failed. Server is stopped or unproper client library is used to establish connection to the server. SQLCode: -904 IB Error Number: 335544375" then probably you should check the correctness of port and host name you've entered and also if the remote server is run.

What do I need to start working with EMS SQL Manager for InterBase/Firebird?

SQL Manager | EMS SQL Manager for InterBase/Firebird | Produ...
First of all you must have an InterBase/Firebird Client installed on your computer and you must be connected to some local or remote InterBase/Firebird server to work with SQL Manager for InterBase/Firebird. You can download InterBase client and server from MER Systems Inc, http://mers.com (the direct URL is http://mers.com/ib_wi_os_tIB6_0_2_0.exe) or Firebird client and server from http://www.firebirdsql.org (download is free).

What is EMS SQL Management STUDIO for InterBase/Firebird (STUDIO)?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
EMS SQL Management Studio is a complete solution for database administration and development. The STUDIO is an integrated suite of powerful database management tools united in one easy-to-use work environment. Developers will appreciate its ability to create/edit/drop any database objects and will find DB comparison, data export/import and test data generation tools extremely helpful. Database migration, BackUp and Restore tools will be of great help to DBAs.

Can STUDIO synchronize InterBase/Firebird database with PostgreSQL database?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
This possibility is not supported by our utilities as they allow synchronizing data and metadata only between one server type, that is between InterBase/Firebird and InterBase/Firebird.

Can InterbaseRecovery recover my InterBase/Firebird database(s)?

OfficeRecovery.com - InterbaseRecovery - FAQ
The effective way to find out if a InterBase/Firebird database is recoverable is to try the demo version of InterbaseRecovery on it. Visit the Download Demo page to get a free copy of the demo. Product specifications with lists of items recovered and not recovered is available at the Product Information page. Always backup your original corrupted InterBase/Firebird database before proceeding with any recovery activity!

How do I migrate my source code from Visual SourceSafe to Team Foundation Server?

Jim Lamb : Team Foundation Server FAQ
The Team Foundation Visual SourceSafe converter tool transfers files, folders, version history, and user information from a Visual SourceSafe database to Team Foundation source control. Read more.

How do I migrate my source code from CVS or Subversion to Team Foundation Server?

Jim Lamb : Team Foundation Server FAQ
While there is no converter available from Microsoft that will migrate source code from CVS or Subversion, ComponentSoftware (not affiliated with Microsoft) is offering CS-Converter for evaluation. From their press release: CS-Converter is a powerful and reliable conversion tool, used to migrate from various legacy version control systems (such as RCS, CVS, Subversion and Visual SourceSafe) to Microsoft Team Foundation Version Control (TFVC) system.

How can QEI use ODBC with P3E running InterBase?

PCF Ltd - Frequently Asked Questions
Borland do not ship an ODBC driver with Interbase, and end users have to purchase their own copies from the company contracted by Borland to develop it. We have looked into licensing it ourselves, but the driver vendor's OEM licensing terms currently make it uneconomic to bundle it with our products. An evaluation copy of the driver can be downloaded from Easysoft's website.

I work behind a firewall (router). Can I use Studio to manage a remote InterBase/Firebird server?

SQL Manager | EMS SQL Management Studio for InterBase/Firebi...
If due to the security policy accepted in your corporate network or by your host provider you cannot connect to your InterBase/Firebird server directly through TCP/IP (for example a firewall prevents this), you can use SSH tunneling feature of SQL Manager to fulfill your task.

What is the source of the data?

CLEI | FAQ
The population data are from the U.S. Census Bureau 2000 Census. Indiana census data can be down loaded from the Census Bureau website located at http://www2.census.gov/census_2000/datasets/Summary_File_1/ The mortality data are from the Indiana State Department of Health. The Indiana Division of Mental Health and Addiction requested use of these data and received formal approval to use the data on this website.
More Questions >>

© Copyright 2007-2012 QueryCAT
About • Webmasters • Contact