Re: [GENERAL] How to compare the schemas ?

2005-06-23 Thread DBTools Software 
Hi,

- Original Message - 
From: "Milorad Poluga" <[EMAIL PROTECTED]>
To: 
Sent: Wednesday, June 22, 2005 1:36 PM
Subject: [GENERAL] How to compare the schemas ?


>Hi everyone,
>
>I am looking for the best way to compare the schemas of two databases with
the very similar structure.
>One (certainly not the best options) is to do something like this:
>
>pg_dump ... DB1  > PG_SCHEMA1
>pg_dump ... DB2  > PG_SCHEMA2
>diff  PG_SCHEMA1  PG_SCHEMA2  > differences.txt

One way is using DBTools Manager (Windows application) to compare the
database. There is a wizard for this purpose which you can use to compare
the entire database and generate the SQL/DDL statements to update the target
database. After the wizard finishes it generates a tree of the changes which
can show you all the objects that will be updated.

PS: Although there is a free version of DBTools Manager, the Compare Wizard
is only available in the commercial edition.

Crercio


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

Re: [GENERAL] convert mdb files to pg?

2005-01-27 Thread DBTools Software 



Hi,
 
- Original Message - 

  From: 
  Rick 
  Schumeyer 
  To: 'PgSql General' 
  Sent: Thursday, January 27, 2005 4:14 
  PM
  Subject: [GENERAL] convert mdb files to 
  pg?
  
  
  Is there a way to import mdb files 
  from Access into pg?
  I found a web page for mdbtools 
  but I can’t get it to compile.
   
You can use DBTools Manager (http://www.dbtools.com.br). Besides the 
fact it can manage PostgreSQL, MySQL, SQLite, Interbase, Firebird and Xbase 
Tables it can also import and export data to and from MSAccess, MSExcel, Text 
Files, ODBC, Paradox, Clipper, Dbase and FoxPro.
It's for Windows but it doesn't 
matter were the database server is located.
 
Best Regards,
 
Crercio O. 
Silva

[GENERAL] [ANN] DBManager Professional 3.0.2 Released

2005-01-13 Thread Support (DBTools Software) 
We are pleased to announce the release of the DBManager Professional 3.0.2.
This version is a major bug fix with a small number of new features:

Fixes
  a.. Fixed Load Dump which affected most of the engines supported
  b.. Closing Workspace with other Views opened will close all views
  c.. Fixed COUNT(*) for Interbase/Firebird (Option UNCHECKED in
Preferences)
  d.. Fix Set FIELD NULL doesn't show SQL/DDL to Output
  e.. Fixed CTRL-C, CTRL-V in the Datasheet View
  f.. Fixed Remove Server Message (Relationships not part of the catalog
data)
  g.. Fixed Table Form (when field is hidden removes also the Label)  (*)
  h.. Fixed DBCC Messages when it is too long (MSSQL/Sybase) generates
exception  (*)
  i.. ALTER TABLE ADD COLUMN (Now field is quoted to allow reserved
words/SQLITE)
  j.. Added Conversion Table for MSAccess => MySQL. Many changes were made
in the Conversion Table
  k.. Fixed Import Text Wizard (NULL values not reset for each record)
  l.. Fix Server Connect with a default database (SQLite)
  m.. Create/Alter/Drop Procedure referenced by Database.Procedure (MySQL)
  n.. Fixed Dump Wizard Exports Only Data Correctly (SQL/DDL)
  o.. Fixed Number Format for MySQL WebService (Datasheet StatusBar)
  p.. Dump Tables now Dumps triggers of the selected table correctly
(SQLITE)
  q.. When Dumping only one table do not dump objects that are not table
children
New Features

  a.. Servers Sorted By Name
  b.. Added Role Support for Interbase/Firebird (Server Properties)
  c.. Added Collation Connection for MySQL (Server Properties)
  d.. Add Support for Table Collation (Datasheet View)
  e.. Add support for other character separators in Text Import Wizard
  f.. Added support for Sybase (*)
(*) Enterprise Edition Only

You can download the Freeware Edition directly from our website at
http://www.dbtools.com.br/EN/downloads.php.

What is DBManager Professional

DBManager Professional is windows application to manage MySQL, PostgreSQL,
SQLite, Interbase, Firebird, Xbase Tables, MSAccess (*), MSSQL Server (*),
Sybase (*) and Oracle (*) (avaible soon) database servers. Here is some of
its features:

- Manage all objects in the database: tables, indexes, stored procedures,
functions, user types, users, groups, etc
- Create and Execute Queries in Query Designer and Query Builder
- Import and Export data from/to MSAccess, ODBC, MSExcel, Paradox, Clipper,
Dbase, FoxPro, Text Files, XML
- Diagram Designer to build your database structure visually (*)
- Form Builder (*)
- Database Compare Wizard to keep two or more database syncronized (*)
- Task Builder to automate data processing (*)
- Database Documenter
- Report Builder creates reports in HTML format (*)
- Server, Database and Table Monitoring (*)
- Web Script Generator creates scripts in PHP and ASP
- True MDI Tab Views compatible with .NET
- and much more

(*) Enterprise Edition Only

For the full list of features please check
http://www.dbtools.com.br/EN/dbmanagerpro/

Best Regards,

DBTools Software
http://www.dbtools.com.br


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings