Migrating to SQL Server from Versant

Can anyone point me to someone who could advise on migrating databases. I am
a system consultant (but not a database consultant or expert) and one of my
customers wants to convert their database from Versant to SQL server. The
Database is used to record customer information and includes the following
requirements. All data entered or changed must have a change history
recorded. Pictures will be save and linked to customers and the ability to
annotate the pictures is also required. The system will be used in various
locations worldwide.
Any help would be required.
thanks
George
George Adrian
All possible to do in SQL Server. I have no clue what Versant is, I've
never heard of it.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"George Adrian" <GeorgeAdrian@.discussions.microsoft.com> wrote in message
news:32CF3D1B-B261-48AD-A8A4-7CBF2CEEB24F@.microsoft.com...
> Can anyone point me to someone who could advise on migrating databases. I
> am
> a system consultant (but not a database consultant or expert) and one of
> my
> customers wants to convert their database from Versant to SQL server. The
> Database is used to record customer information and includes the following
> requirements. All data entered or changed must have a change history
> recorded. Pictures will be save and linked to customers and the ability to
> annotate the pictures is also required. The system will be used in various
> locations worldwide.
> Any help would be required.
> thanks
> George
> --
> George Adrian
|||The biggest issue is that since Versant is an Object Oriented database, you
will have to redesign the data model - Identity columns to replace
ObjectID's, Foreign Key columns to replace object references, etc. I would
recommend rethinking the data model completely to produce an efficient
relational model rather than trying to map their OO schema directly to a
relational schema.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:OKjSseSDGHA.2040@.TK2MSFTNGP14.phx.gbl...
> All possible to do in SQL Server. I have no clue what Versant is, I've
> never heard of it.
> --
> Mike
> Mentor
> Solid Quality Learning
> http://www.solidqualitylearning.com
>
> "George Adrian" <GeorgeAdrian@.discussions.microsoft.com> wrote in message
> news:32CF3D1B-B261-48AD-A8A4-7CBF2CEEB24F@.microsoft.com...
>