Wednesday, March 7, 2012

ms-sql to sapdb

hi there,

we have a ms-sql server 7.0 and want to migrate to sapdb on unix.
are there any tools to convert a ms-sql to sapdb, including
stored procedures, keys and views?

tia

stefanHi

I have never heard of sapdb, but you should ask your supplier. Microsoft
provides many tools to port to SQL Server, and there are alot of other third
party tools that will also help, but they are obviously not going to provide
you with assistance if you wish to move to a rival vendor.

John

"stefan" <stefanluedecke@.gmx.de> wrote in message
news:ea0e4b2e.0308022043.73010886@.posting.google.c om...
> hi there,
> we have a ms-sql server 7.0 and want to migrate to sapdb on unix.
> are there any tools to convert a ms-sql to sapdb, including
> stored procedures, keys and views?
> tia
> stefan|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<3f2cc1e9$0$15038$ed9e5944@.reading.news.pipex.net>...
> Hi
> I have never heard of sapdb, but you should ask your supplier. Microsoft
> provides many tools to port to SQL Server, and there are alot of other third
> party tools that will also help, but they are obviously not going to provide
> you with assistance if you wish to move to a rival vendor.
hi john,

sapdb (http://www.sapdb.org) is an open source db from sap.

with the export tool from ms-sql we are able to export the pure
data, but none of the things arround the db, such as stored procedures,
trigger etc.

with access (the db-frontend from microsoft) we could also transfer
data.

microsoft provide really a lot of tools to migrate to sql-server, but not the
other way ;-))

thank you

stefan|||Ray Higdon <rayhigdon@.higdonconsulting.com> wrote in message news:<3f2d13c1$0$195$75868355@.news.frii.net>...
> Are you talking about transferring data to an SAP database? If so, hehe,
> no simple answer exists. SAP uses business and function calls for all
> data entry, you input data by calling their functions, not going to the
> underlying data. One tool I have seen out there to help with this
> process is the Business Connector (read more here
> http://www.plurb.com/ebXML/Scalable...operability.pdf) it uses XML
> in and out and you can call it by a web service and run it as a Windows
> service. I have a buddy that wrote a paper on the BC, if this is what
> you are talking about I'll see if it is published yet and get you a copy
> if you want.
hi ray,

thank you for your help, but we can transfer data. the problem is
to transfer stored procedures, keys and trigger. and it would be a
few weeks work to do it manually.

stefan|||Hi

It is highly unlikely that your database will support T-SQL, and if it does
it is probably violating copyright. Therefore about all you can do is to
script them and maybe write a few macros to globally convert the syntax,
then it will be a manual task to finish it off.

John

"stefan" <stefanluedecke@.gmx.de> wrote in message
news:ea0e4b2e.0308031042.552d0eb0@.posting.google.c om...
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:<3f2cc1e9$0$15038$ed9e5944@.reading.news.pipex.net>...
> > Hi
> > I have never heard of sapdb, but you should ask your supplier. Microsoft
> > provides many tools to port to SQL Server, and there are alot of other
third
> > party tools that will also help, but they are obviously not going to
provide
> > you with assistance if you wish to move to a rival vendor.
> hi john,
> sapdb (http://www.sapdb.org) is an open source db from sap.
> with the export tool from ms-sql we are able to export the pure
> data, but none of the things arround the db, such as stored procedures,
> trigger etc.
> with access (the db-frontend from microsoft) we could also transfer
> data.
> microsoft provide really a lot of tools to migrate to sql-server, but not
the
> other way ;-))
> thank you
> stefan

No comments:

Post a Comment