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@discuss
ions.microsoft.com> wrote in message
news:32CF3D1B-B261-48AD-A8A4- 7CBF2CEEB24F@microso
ft.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@solidqualitylea
rning.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@discuss
ions.microsoft.com> wrote in message
> news:32CF3D1B-B261-48AD-A8A4- 7CBF2CEEB24F@microso
ft.com... 
>
>