September 3, 2010 at 8:05 am
Hi,
I have some doubts on the 32-bit/64-bit compatibility between SQL Server, SAP and the underlying OS. Can somebody explain me in a general manner how does this all work?
Q1: can i have a SQL 2000 32-bit running on a 64-bit OS?
Q2: my SQL Server 2000 (32-bit) is connected through the NSX SAP connector to SAP R/3 v6. Does a migration of my SQL 2000 32-bit to a 64-bits version have any impact on the connection to SAP (R/3 v6)? Shall I migrate also SAP to a 64-bit version to avoid inconsistencies?
Q3: what are the best connectors to connect SQL to SAP?
Q4: what’s the high-level impact of a migration from SQL 2000 to SQL 2005/2008? Rebuilding all DTS packages?
Q5: any compatibility issue between SQL Server 2000/2005/2008 32 / 64-bit with Windows Server 2008/Windows Vista/Windows7?
Thanks for your help!
If it's not the right forum please address me to the correct one...
F
September 3, 2010 at 8:39 am
francesco_uk (9/3/2010)
Hi,I have some doubts on the 32-bit/64-bit compatibility between SQL Server, SAP and the underlying OS. Can somebody explain me in a general manner how does this all work?
Q1: can i have a SQL 2000 32-bit running on a 64-bit OS?
Q2: my SQL Server 2000 (32-bit) is connected through the NSX SAP connector to SAP R/3 v6. Does a migration of my SQL 2000 32-bit to a 64-bits version have any impact on the connection to SAP (R/3 v6)? Shall I migrate also SAP to a 64-bit version to avoid inconsistencies?
Q3: what are the best connectors to connect SQL to SAP?
Q4: what’s the high-level impact of a migration from SQL 2000 to SQL 2005/2008? Rebuilding all DTS packages?
Q5: any compatibility issue between SQL Server 2000/2005/2008 32 / 64-bit with Windows Server 2008/Windows Vista/Windows7?
Thanks for your help!
If it's not the right forum please address me to the correct one...
F
1. Yes.
4. DTS packages, as well as depreciated features.
5. I'm running 2005 & 2008 64-bit on my vista laptop. Have 2008 64-bit on a windows server 2008 64-bit. No issues with sql running.
Regarding your DTS packages - they will probably need to be updated to use the SQL Native Client driver.
Regarding 64-bit SQL - check for existence of necessary drivers in 64-bit (this probably includes your SAP connectivity). If you are exporting anything that utilizes the JET Database Engine driver (Access, Excel, etc.) then you are going to have a big problem - there isn't (and won't be) a 64-bit version of the JET driver. However, MS has recently made available the Access Database Engine 2010 Drivers, in 32-bit and 64-bit, and these include Access and Excel drivers at http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en. I have not had an opportunity to test these yet to see how they work, especially with compatibility with the 2003/2007 versions of these files.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply