migration 6.5.1 repository DB SQLServer2000 to SQLServer2005

server administration XI Server Discussion
1

Hello,

We plan to move our old BO 6.5.1 Repository from SQL Server 2000 to SQL Server 2005.

We use ODBC connection on our PCs and Servers to connect to the Repository.

Our migration plan is :

  1. stop all activities and log out users on BO and SQL Server 2000 Database
  2. make a backup of the SQL Server 2000 DB
  3. make a restore of the Database on SQL Server 2005
  4. make all the checks on SQL Server 2005 Side (orphans, …)
  5. change ODBC connections everywhere it used
  6. restart servers

do we omit something or do you think there is something wrong ?

thanks a lot for your answers.

guennal :luxembourg: (BOB member since 2005-08-30)

2

First observation is that BO 6.5.1 does not support SQL server 2005
You will have to first upgrade BO installation (to version 6.5.4) to go ahead with using SQL 2005

.

haider :es: (BOB member since 2005-07-18)

3

Hi haider

i am also facing the same kind of issue. But my bo version is 6.1 and want to create reports on Sql server 2005 database.

Is it possible to have some patches or upgrades from BO?

prasad v (BOB member since 2007-07-15)

4

If you have a valid maintenance (if you have paid for it) then you should have an access to installations of higher BO versions. Ask you BO vendor if you don’t have an access.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

I’m pretty sure I answered this in another thread. Please don’t ask the same question in multiple places.

Do NOT use unsupported databases for your repository. However, You should have no issue querying a SQL2005 database with 6.5.1. BO is just making an ODBC call. BO will think it’s SQL2000, but it will work just fine.

Steve Krandel :us: (BOB member since 2002-06-25)

6

I remember at one of my clients place that querying a SQL 2005 database using SQL2000 drivers had some limitations when it comes to stored procedures, UDFs. The tables may work but it wont be exactly same as querying a SQL 2000 database

I guess you should be able to download the SP4 (6.5.4) from SAP BO website
.

haider :es: (BOB member since 2005-07-18)

7

Thanks haider and steve,

First of all i want to conform that i am using Bo 6.1 Version.
And I tried to create a connection from Designer. but its not showing only Sql server 2000 an 7.x someting.

I have crated dsn using Sql server 2000. My doubt is that how can we connect to Sql serve 2005 using 2000 drivers Could you please give me the complete details.

Once again thanks haider and steve.

prasad v (BOB member since 2007-07-15)

8

Just do it. Use your 2000 ODBC driver and point it to the 2005 database. If it doesn’t work, then you’re done. If it does, then you’re also done.

Steve Krandel :us: (BOB member since 2002-06-25)