November 16, 2012 at 9:19 am
I'm configuring a new PC, which is a 64-bit architecture/OS. I'm doing some development on this box using SQL Server 2008 R2 Express. As I do development I'll generate scripts to create or update SQL objects, because the database I'm working on will be put onto client machines. The concern I have is that more than half of our users are running on 32-bit Windows. I'm assuming that the scripts I generate don't have anything specific, with regards to the architecture in them. i.e.: that it doesn't matter if I install the 64-bit version or the 32-bit version. Am I correct about this?
Kindest Regards, Rod Connect with me on LinkedIn.
November 16, 2012 at 9:43 am
Executable files are 32-bit or 64-bit, that's if. Scripts are not, databases are not, backups are not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 16, 2012 at 10:11 am
Agree with Gail. If you use scripts, there's no issue with x86 v x64
November 16, 2012 at 3:46 pm
Rod at work (11/16/2012)
I'm configuring a new PC, which is a 64-bit architecture/OS. I'm doing some development on this box using SQL Server 2008 R2 Express. As I do development I'll generate scripts to create or update SQL objects, because the database I'm working on will be put onto client machines. The concern I have is that more than half of our users are running on 32-bit Windows. I'm assuming that the scripts I generate don't have anything specific, with regards to the architecture in them. i.e.: that it doesn't matter if I install the 64-bit version or the 32-bit version. Am I correct about this?
I am little confused, I thought you won't be able to install 64 bit SQL into 32 bit OS.
Correct me if I am wrong, what am I missing from this question?
Regards,
SueTons.
Regards,
SQLisAwe5oMe.
November 17, 2012 at 4:37 am
SQLCrazyCertified (11/16/2012)
I am little confused, I thought you won't be able to install 64 bit SQL into 32 bit OS.
Correct, that's not possible.
Correct me if I am wrong, what am I missing from this question?
From the OP
I'm configuring a new PC, which is a 64-bit architecture/OS.
it doesn't matter if I install the 64-bit version or the 32-bit version.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply