Post reply

32-bit, 64-bit mixed envirionment?

  • June 6, 2007 at 6:44 am

    #172652

    We are running several 32-bit SQL Server 2005 standard servers, both stand alone and active/passive clusters. We have a project coming that we want to use 64-bit hardware and 64-bit SQL Server 2005 Enterprise (will be clustered).

    1. Can I manage both envirionments with the 32-bit Management studio on my 32-bit Laptop?

    2. Can the developers work on both envirionments from their 32-bit machines?

    3. There will many more questions about the mixed envirionment, are there any books or other resources specific to this situation that I can refer to for answers other than forums?

  • June 6, 2007 at 9:55 am

    #711166

    You will have no problems from the sql server point of view in any direction. dot net code compiled under 32 or 64 bit compilers will be different but the T-sql stuff will be fine - transparent in fact.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • June 6, 2007 at 11:01 am

    #711193

    Any SSIS packages in 64-bit environment that using scripting will need to be precompiled before they are deployed.

  • June 7, 2007 at 6:25 am

    #711386

    You can even restore databases between the two.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply