Upgrade SQL server 2005 to 2008 with BODS 4.0

[Former Member]

Hi,

I want to upgrade database from SQL Server 2005 to SQL server 2008 with BODS 4.0.

I want to know the recommandations for do it and for dataflows that works well.

- How to use SQL Server 2008 with Bods?
- What are the performece on SQL server 2008?
- What are the things to evaluate?
- Is it necessary migrate with BackUp restore mode ?
- What are the step of migration?
- Can we merge the disabled in BODS?

Thanks.

[Former Member · Accepted solution]

Are you talking about local repository or Central repository?

There isn't any difference that "we" noticed.

for a new Central Repository

Create new repository in 2008

then open designer connected to old repository

bottom pane select all projects

right click 'export'

wait....

in the opened right hand window

right click "export to repository'

Select the new repository

wait...

it will finish...

exit restart designer connect to new repository

IMHO don't use backup and restore feature of MSSQL for this

YMMV,

Jim

[Former Member · Accepted solution]

Thanks for this answer,

And for the Target DataStore,

What is the method to migrate all connection of the target Datastore in BODS to my new DB MSSQL 2008?

And are there any change in differente DataFlow?

Is there Any non regression test to do?

Hicham.

[Former Member · Accepted solution]

Hicham,

?

if you export the projects with all of the dependents then everything moves over to the new repository.

There will be no differences.

The database is just a Container for the xml, the xml is the representation of the projects, jobs, workflows, datasources etc.

The Container doesn't matter.

No real testing should be necessary.

Just do it!