SQL Server 2012 or SQL Server 2008

[former_member505219]

Our implementation team says that they need SQL Server 2008 for SBO whereas the software vendor says that SQL Server 2008 is not now available for sale now. Now only SQL Server 2012 is available and we will have to downgrade it to 2008. What is your opinion and how we should proceed?

[former_member186095 · Accepted solution]

Hi Muhammad Aftab,

If your database have been created using SQL2012, you can't downgrade to SQL 2008 or 2008 R2.

You must wait the SAP official announcement about the use of SQL 2012 for SAP B1.

Currently, SAP B1 do not yet support SQL 2012. You only have one option i.e. to use SQL 2008 R2.

You can ask your implementation team to check this link:

https://websmp202.sap-ag.de/smb/sbo/platforms

The team can see the SAP B1 platform like server platform, database platform, client platform etc.

Rgds,

JM

[former_member505219 · Accepted solution]

Hi Jimmy Michael

We have old databases created in 2008R2. Can we attach them in SQL 2012 that is downgraded to 2008R2? or we will have to create new database in downgrade version and insert data again?

Regards

MA

[former_member186095 · Accepted solution]

Hi M. Aftab,

You can attach to SQL 2012 that downgraded to SQL 2008 R2

Rgds,

JM

[Former Member]

HI Muhammad Aftab,

     You downgrade sql server 2012 to sql server 2008 before attach database.

Regards,

Venki .A

[Former Member]

HI Muhammad......

You should go for SQL Server 2012 Version........

Regards,

Rahul

[KennedyT21]

HI Rahul,

Does they Support for 2012, can you share

Regards

Kennedy

[former_member505219]

Dear Rahul

We have lot of old data also. When we will downgrade, we will have to re-insert all those millions of records by scripts.Do you have any recommended way to downgrade and re-insert data again for other applications databases?

Will BCP etc work for us?

[Former Member]

Hi Kennedy...........

Logically if you think, All the old version data would be supported by new version products else upgradation is never being possible.........

So every SQl 200 DB supported by SQL 2005 and SQL 2000 and 2005 supported by SQL 2008 and higher version DB don't support by lower version product.......

Regards,

Rahul

[muhammad_kanwalshehzad]

For data insertion/migration SQL Import utility will be enough. While downgrading the problem will become when there are some new data types in higher version which are not supported/available in the lower version. But as for as our case is concerned currently we have our data in SQL Server 2008 so migrating to some other instance of 2008 or even to 2012, there should be no issue.

[KennedyT21]

HI Muhammad Aftab ,

In SAP Still Process is going for SQL 2012 not yet released full support for it,

Get SQL 2012 and down grade to 2008 and start implementation why there is note from sap you can upgrade to 2012.

Regards

Kennedy