Database Modelling in UML

The Methods & Tools newsletter has released in its archive section the
article "Database Modelling in UML". This article offers a step by step
approach to transform a UML object-oriented class model in a purely
relational database.

http://www.methodsandtools.com/archive/archive.php?id=9Franco Martinig via SQLMonster.com wrote:

> The Methods & Tools newsletter has released in its archive section the
> article "Database Modelling in UML". This article offers a step by step
> approach to transform a UML object-oriented class model in a purely
> relational database.
> http://www.methodsandtools.com/archive/archive.php?id=9

The article is rather difficult to believe after lines like this:

"The relational model only offers a public data access model. All data is
equally exposed and open to any process to update, query or manipulate it.
Information hiding is unknown."

This statement is true in the same sense that it is true that you have to
turn a crank on the front of a car to get it started. It depends on
whether or not you are Rip Van Winkle.

I kept reading looking for a qualifier, but the mistake is repeated later
on, "The relational model exposes all data equally, with limited support
for associating behaviour with data elements through triggers, indexes and
constraints."

--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@.(Sec)ure(Dat)a(.com)|||Perhaps for another perspective, read:
http://www.dbdebunk.com/page/page/622916.htm
http://www.dbdebunk.com/page/page/622867.htm

--
Anith

Database migration

Hello,
Is it generally easier to migrate data from SQL Server to other
databases? I tried to find migration tools that would help move data
from SQL Server to other databases, and there were many. However,
trying to find tools that would migrate data from DB2, Oracle or any
other database to SQL Server was not really common. Is it harder to
migrate data to a SQL Server database? thank you.Moving data from Oracle, DB2 (and many other products) to SQL Server is
quite easy.
To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"contact1981" <contact1981@.gmail.com> wrote in message
news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
> Hello,
> Is it generally easier to migrate data from SQL Server to other
> databases? I tried to find migration tools that would help move data
> from SQL Server to other databases, and there were many. However,
> trying to find tools that would migrate data from DB2, Oracle or any
> other database to SQL Server was not really common. Is it harder to
> migrate data to a SQL Server database? thank you.
>|||Hi,
Migration to SQL is easy, just get the migration toolkit from microsoft sit
e.
'SQL Server Migration Assistant' this tool will automate most of the phases
of the migration process. or u can use DTS .
Amol Lembhe
"Arnie Rowland" wrote:

> Moving data from Oracle, DB2 (and many other products) to SQL Server is
> quite easy.
> To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "contact1981" <contact1981@.gmail.com> wrote in message
> news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
>
>|||I think the shortage of third-party migration tools for converting to
SQL Server is because, as others have noted, Microsoft already had the
tools you need "in the box" or free to download.
Roy
On 7 Aug 2006 08:59:11 -0700, "contact1981" <contact1981@.gmail.com>
wrote:

>Hello,
>Is it generally easier to migrate data from SQL Server to other
>databases? I tried to find migration tools that would help move data
>from SQL Server to other databases, and there were many. However,
>trying to find tools that would migrate data from DB2, Oracle or any
>other database to SQL Server was not really common. Is it harder to
>migrate data to a SQL Server database? thank you.

Database migration

Hello,
Is it generally easier to migrate data from SQL Server to other
databases? I tried to find migration tools that would help move data
from SQL Server to other databases, and there were many. However,
trying to find tools that would migrate data from DB2, Oracle or any
other database to SQL Server was not really common. Is it harder to
migrate data to a SQL Server database? thank you.Moving data from Oracle, DB2 (and many other products) to SQL Server is
quite easy.
To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"contact1981" <contact1981@.gmail.com> wrote in message
news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
> Hello,
> Is it generally easier to migrate data from SQL Server to other
> databases? I tried to find migration tools that would help move data
> from SQL Server to other databases, and there were many. However,
> trying to find tools that would migrate data from DB2, Oracle or any
> other database to SQL Server was not really common. Is it harder to
> migrate data to a SQL Server database? thank you.
>|||Hi,
Migration to SQL is easy, just get the migration toolkit from microsoft site.
'SQL Server Migration Assistant' this tool will automate most of the phases
of the migration process. or u can use DTS .
Amol Lembhe
"Arnie Rowland" wrote:
> Moving data from Oracle, DB2 (and many other products) to SQL Server is
> quite easy.
> To set up ETL operations use DTS (SQL 2000) or SSIS (SQL 2005).
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "contact1981" <contact1981@.gmail.com> wrote in message
> news:1154966351.399554.13710@.b28g2000cwb.googlegroups.com...
> > Hello,
> >
> > Is it generally easier to migrate data from SQL Server to other
> > databases? I tried to find migration tools that would help move data
> > from SQL Server to other databases, and there were many. However,
> > trying to find tools that would migrate data from DB2, Oracle or any
> > other database to SQL Server was not really common. Is it harder to
> > migrate data to a SQL Server database? thank you.
> >
>
>|||I think the shortage of third-party migration tools for converting to
SQL Server is because, as others have noted, Microsoft already had the
tools you need "in the box" or free to download.
Roy
On 7 Aug 2006 08:59:11 -0700, "contact1981" <contact1981@.gmail.com>
wrote:
>Hello,
>Is it generally easier to migrate data from SQL Server to other
>databases? I tried to find migration tools that would help move data
>from SQL Server to other databases, and there were many. However,
>trying to find tools that would migrate data from DB2, Oracle or any
>other database to SQL Server was not really common. Is it harder to
>migrate data to a SQL Server database? thank you.

Database Maintenance Planner option disabled

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on. Google searches
have turned up nothing. Help!
Is SQL Server Agent enabled and running?
<unimatter@.gmail.com> wrote in message
news:1167501594.458835.85780@.s34g2000cwa.googlegro ups.com...
>I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
|||Hi
"unimatter@.gmail.com" wrote:

> I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
I am not sure why it is greyed out, but why not write your own call to
xp_sqlmaint or use sqlmaint.exe from the command prompt?
John
|||Hi
Just to add, the "database maintenance plan" option is normally available
when you are on the server node, datebase node etc.
John

Database Maintenance Planner option disabled

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on. Google searches
have turned up nothing. Help!Is SQL Server Agent enabled and running?
<unimatter@.gmail.com> wrote in message
news:1167501594.458835.85780@.s34g2000cwa.googlegroups.com...
>I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>|||Hi
"unimatter@.gmail.com" wrote:

> I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
I am not sure why it is greyed out, but why not write your own call to
xp_sqlmaint or use sqlmaint.exe from the command prompt?
John|||Hi
Just to add, the "database maintenance plan" option is normally available
when you are on the server node, datebase node etc.
John

Database Maintenance Planner option disabled

I am using SQL Server 2000 and need to run the maintenance plan wizard,
but the "Database Maintenance Planner" option in the Tools menu is
disabled (greyed out) no matter which node I click on. Google searches
have turned up nothing. Help!Is SQL Server Agent enabled and running?
<unimatter@.gmail.com> wrote in message
news:1167501594.458835.85780@.s34g2000cwa.googlegroups.com...
>I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>|||Hi
"unimatter@.gmail.com" wrote:
> I am using SQL Server 2000 and need to run the maintenance plan wizard,
> but the "Database Maintenance Planner" option in the Tools menu is
> disabled (greyed out) no matter which node I click on. Google searches
> have turned up nothing. Help!
>
I am not sure why it is greyed out, but why not write your own call to
xp_sqlmaint or use sqlmaint.exe from the command prompt?
John|||Hi
Just to add, the "database maintenance plan" option is normally available
when you are on the server node, datebase node etc.
John