Hello,
I'm relatively new to the database world so please forgive me in
advance for my ignorance. I have recently been tasked at my job with
finding a tool that will perform the following tasks: 1) extract
schemas from a db, 2) produce a difference report between schemas from
two databases, and 3) synchronize two schemas. The purpose is for
product upgrades during which an existing database schema will need to
be synchronized with a baseline schema.
The tool must support the following database vendors (versions given
in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS
2000, and IBM DB2 (7/8).
I have spent the last several days downloading and researching a
variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer,
DBDiff, and AdeptSQL. I thought it would be a good idea to post a
message to a few database newsgroups and ask for any recommendations
database developers may have.
So if anyone has any recommendations on such a tool or software
package, I would greatly appreciate any information.
Thanks!
Chad Smith 9 2767
In article <75************ **************@ posting.google. com>, Chad
Smith (it*****@comcas t.net) says... I have spent the last several days downloading and researching a variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, DBDiff, and AdeptSQL. I thought it would be a good idea to post a message to a few database newsgroups and ask for any recommendations database developers may have.
Add Sybase Powerdesigner to the list. Ive done that with the
DataArchitect version but it might also work with PhysicalArchite ct.
The last one is much cheaper.
Chad Smith wrote: Hello,
I'm relatively new to the database world so please forgive me in advance for my ignorance. I have recently been tasked at my job with finding a tool that will perform the following tasks: 1) extract schemas from a db, 2) produce a difference report between schemas from two databases, and 3) synchronize two schemas. The purpose is for product upgrades during which an existing database schema will need to be synchronized with a baseline schema.
The tool must support the following database vendors (versions given in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS 2000, and IBM DB2 (7/8).
I have spent the last several days downloading and researching a variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, DBDiff, and AdeptSQL. I thought it would be a good idea to post a message to a few database newsgroups and ask for any recommendations database developers may have.
So if anyone has any recommendations on such a tool or software package, I would greatly appreciate any information.
Thanks! Chad Smith
Add Computer Associates All Fusion ERwin to the list.
--
Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)
Daniel Morgan wrote: Chad Smith wrote:
Hello,
I'm relatively new to the database world so please forgive me in advance for my ignorance. I have recently been tasked at my job with finding a tool that will perform the following tasks: 1) extract schemas from a db, 2) produce a difference report between schemas from two databases, and 3) synchronize two schemas. The purpose is for product upgrades during which an existing database schema will need to be synchronized with a baseline schema.
The tool must support the following database vendors (versions given in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS 2000, and IBM DB2 (7/8).
I have spent the last several days downloading and researching a variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, DBDiff, and AdeptSQL. I thought it would be a good idea to post a message to a few database newsgroups and ask for any recommendations database developers may have.
So if anyone has any recommendations on such a tool or software package, I would greatly appreciate any information.
Thanks! Chad Smith
Add Computer Associates All Fusion ERwin to the list.
NO!!!!! Am finding erwin is crashing often, is not working well!!! Is
rubbish!!
--
--
Enor
Enor Mouspenis wrote: Add Computer Associates All Fusion ERwin to the list.
NO!!!!! Am finding erwin is crashing often, is not working well!!! Is rubbish!!
And you think that that is ERwin problem? Why?
I've used the product for years ... and not once have I experienced
a stability issue with the product.
It is the standard tool at numerous Fortune 500 and government
organizations. Not once have I heard your complaint.
So if you've got a problem ... YOU'VE got a problem: Fix it!
Don't blame the product.
--
Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)
Daniel Morgan <da******@x.was hington.edu> wrote in message news:<108459473 6.618407@yasure >... And you think that that is ERwin problem? Why?
I've used the product for years ... and not once have I experienced a stability issue with the product.
It is the standard tool at numerous Fortune 500 and government organizations. Not once have I heard your complaint.
I've bought the product several times over the last eight years -from
LogicWorks, then Platinum, and now CA. I've used it very successfully
on a number of projects - in which the reverse-engineering,
synchronization , and schema alteration code generation really helped
us move quickly. The fact that I was able to move easily between
informix, sql server, postgesql, oracle, and db2 is another fabulous
point. But I won't be buying it again - support from CA is *so* bad I
don't know where to begin.
First off, licensing & registration changed about a year ago or so -
and it didn't work as described in any of the documentation (spanning
a variety of separately-sent packages, readmes, electonic guides,
etc). In order to get the product started I ended up on a call with
their customer support. Which was *unbelievably* incompetent and
disinterested in helping. The entire process has completely turned me
off on the product.
I noticed at a recent DCI that the Embarcadaro team was quite happy
about CA's purchase of this product. Never liked Sybase's Power
Designer much, I guess next time I go to buy something like this I'll
be talking to the folks at Embarcadaro first and CA never.
buck
I agree, Erwin is not very stable and offers a poor gui.
PowerDesigner, as to me, is a good choice. I use it in a production
environnement in banking.
"Enor Mouspenis" <en***********@ hotmail.com> a écrit dans le message de
news:2g******** ****@uni-berlin.de... Daniel Morgan wrote:
Chad Smith wrote:
Hello,
I'm relatively new to the database world so please forgive me in advance for my ignorance. I have recently been tasked at my job with finding a tool that will perform the following tasks: 1) extract schemas from a db, 2) produce a difference report between schemas from two databases, and 3) synchronize two schemas. The purpose is for product upgrades during which an existing database schema will need to be synchronized with a baseline schema.
The tool must support the following database vendors (versions given in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS 2000, and IBM DB2 (7/8).
I have spent the last several days downloading and researching a variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, DBDiff, and AdeptSQL. I thought it would be a good idea to post a message to a few database newsgroups and ask for any recommendations database developers may have.
So if anyone has any recommendations on such a tool or software package, I would greatly appreciate any information.
Thanks! Chad Smith
Add Computer Associates All Fusion ERwin to the list.
NO!!!!! Am finding erwin is crashing often, is not working well!!! Is rubbish!! -- -- Enor
Hi,
Try dbMaestro. It's a product that allows comparison, migration and
archiving of MSS database schema and data.
You can find it here: http://www.extreme.co.il
"Vince" <vt*******@neri m.net> wrote in message news:<c8******* ***@biggoron.ne rim.net>... I agree, Erwin is not very stable and offers a poor gui. PowerDesigner, as to me, is a good choice. I use it in a production environnement in banking.
"Enor Mouspenis" <en***********@ hotmail.com> a écrit dans le message de news:2g******** ****@uni-berlin.de... Daniel Morgan wrote:
Chad Smith wrote:
> Hello, > > I'm relatively new to the database world so please forgive me in > advance for my ignorance. I have recently been tasked at my job with > finding a tool that will perform the following tasks: 1) extract > schemas from a db, 2) produce a difference report between schemas from > two databases, and 3) synchronize two schemas. The purpose is for > product upgrades during which an existing database schema will need to > be synchronized with a baseline schema. > > The tool must support the following database vendors (versions given > in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS > 2000, and IBM DB2 (7/8). > > I have spent the last several days downloading and researching a > variety of tools such as Aqua Data Studio, DbVisualizer, DBExplorer, > DBDiff, and AdeptSQL. I thought it would be a good idea to post a > message to a few database newsgroups and ask for any recommendations > database developers may have. > > So if anyone has any recommendations on such a tool or software > package, I would greatly appreciate any information. > > Thanks! > Chad Smith
Add Computer Associates All Fusion ERwin to the list.
NO!!!!! Am finding erwin is crashing often, is not working well!!! Is rubbish!! -- -- Enor
I also use Sybase PowerDesigner. I only use to translate schema from one
database to another. I don't use it to do differences, or to write
migration scripts. I write my own migration scripts.
Even for translating one database to another, you have to be smart about
picking your starting point. For instance, I write my overall physical
model using the Oracle physical model. I do that not because Oracle is a
good database. I do that because Oracle is the lowest common
denominator--the worst database. Oracle has the least amount of basic
design features and requires physical parameters that only Oracle needs
(because of Oracle's lack of doing things right in the first place.) When
I use PowerDesigner to translate the model to Sybase, MS SQL Server or
Postgres, it drops all the dross required by Oracle. If I started with
the Sybase model, there is no room for the dross required by Oracle.
PowerDesigner cannot add dross; but it can drop dross.
I also had to change PowerDesigner's XML datatype definition files for
Oracle--so that PowerDesigner will translate Oracle's number(10) to int,
number(5) to smallint, number(2) to tinyint.. Otherwise, you get
numeric(10), numeric(5), and number(2) You don't want numeric as a rule
because it is not the native IEEE integer datatype of the computer. IEEE
good. Oracle only supports the "number" datatype for numbers. "number" is
not IEEE. This is bad, a birth defect akin to a club foot. A big
performance hit. And in Oracle, there is no remedy for it. You have to
live with it.
Also remember, tools like PowerDesigner only translate table, index and view
definitions. They don't handle translating stored procedures. As far as
I know, nothing can do that. And I do not see how a product could possibly
do that.
Brian Ceccarelli
Talus Software http://www.talussoftware.com
"Daniel Morgan" <da******@x.was hington.edu> wrote in message
news:1084503930 .7535@yasure... Chad Smith wrote:
Hello,
I'm relatively new to the database world so please forgive me in advance for my ignorance. I have recently been tasked at my job with finding a tool that will perform the following tasks: 1) extract schemas from a db, 2) produce a difference report between schemas from two databases, and 3) synchronize two schemas. The purpose is for product upgrades during which an existing database schema will need to be synchronized with a baseline schema.
The tool must support the following database vendors (versions given in parenthesis): Oracle (8i/9i), Sybase (12.x), Informix (9.x), MSS 2000, and IBM DB2 (7/8).
"Buck Nuggets" <bu*********@ya hoo.com> wrote in message news:66******** *************** ***@posting.goo gle.com... Never liked Sybase's PowerDesigner much, I guess next time I go to buy something like this I'll be talking to the folks at Embarcadaro first and CA never.
Have you seen it lately?? The 9.5.x release is pretty sweet, and 10.0 is right around the corner. They're working on
making it an Eclipse plugin as well, which should be interesting...
--
Paul Horan
Buffalo, NY This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Martin MOKREJ© |
last post by:
Hi,
I'm looking for some easy way to do something like include in c or PHP.
Imagine I would like to have:
cat somefile.py
a = 222
b = 111
c = 9
|
by: Frank Einstein |
last post by:
Looking for a tool that can edit an XML file in a browser. The basic
requirement is that the XML file is rendered as an HTML form with
editable fields (including add/delete, preferably in accordance with
with the document's XSD/DTD or other schema definition). I don't mind
the actual form of this tool - could be implemented as a JSP/Servlet,
ASP component, or browser plug-in for local or remote XML file access.
Alternatively, it doesn't...
|
by: Pieter |
last post by:
I've read a lot of posts on "why relax ng is so very good" and on "why
w3c xml schema should be the only schema language". I'm, however,
still not clear on why I should prefer one over the other.
I've made a small list of some good and bad points of both. These
points don't really go into the grammar aspects of these languages,
but are more about secondary aspects. The grammar aspects are
different, but both are suitable for validating...
|
by: John |
last post by:
I realize this may be too Oracle specific for this forum-- but I've
seen a fair amount of postings related to ORacle 9i's XML capabilites
so I thought I'd give it a shot.
So, I've read in Oracle's documentatino for 9iR2 that if you want to
store schema based XML documents in Oracle, you first have to register
the schema. The problem is that if you want to modify the schema, and
then subsequently re-register it Oracle will force you to...
|
by: Davide Bedin |
last post by:
I have a "library" schema with the simple and complex types I commonly use
in other schemas and then several other schemas, maybe created by other
developers, that import/include the library schema. And then other schemas
can extend it.....
The classes created by XSD really help to make the development faster and
easier. I really would like to use XSD.exe tool as much as possible and to
avoid editing the classes defined by the tool.
...
| |
by: PeterW |
last post by:
I have an xml file from which I want to generate an xsd schema and at a later
stage a cs class.
The xml file has a mix of defined namespaces and also an empty namespace.
These are defined as follows:
<silcn:silcn xmlns:silcn='http://silcn.org/200309'
xmlns='http://xmlprobe.com/200312'>
it contains an element <report> off the root and also a separate
<Silcn:report> again off the root.
|
by: Chad Smith |
last post by:
Hello,
I'm relatively new to the database world so please forgive me in
advance for my ignorance. I have recently been tasked at my job with
finding a tool that will perform the following tasks: 1) extract
schemas from a db, 2) produce a difference report between schemas from
two databases, and 3) synchronize two schemas. The purpose is for
product upgrades during which an existing database schema will need to
be synchronized with a...
|
by: Rachel |
last post by:
Hi,
I currently have several sections pointing to various custom providers
inside my Web.conf file.
I get multiple messages about not being able to find schema information.
("Could not find schema information for the element
'http://schemas.microsoft.com/.NetConfiguration/v2.0:configSections'")
Currently my configuration tag is as follow:
|
by: send.me.all.email |
last post by:
Hi experts,
which approaches would you suggest for:
- Reading a database schema (tables, fields, relationships) from SQL
Server 2005?
- Visualizing the DB schema?
For developing a DB tool the schema should be read from the server and
then be visualized, e.g. like the SQL Server BI Development Studio
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |