April 10, 2007 at 7:25 am
If you are currently running SQL 2005 (32 bit )with four database and need to upgrade to SQL 2005 (64bit)(both server os are 64 bit), what is the easiest way upgrade with the least amount of down time to the SQL 2005 32 bit server and databases?
April 10, 2007 at 3:59 pm
The easiest way to do this is to backup all four databases and restore it in a 64bits sandbox and play with and clean up any issues you run into then move it from there to the production 64bits. I was a volunteer for the SQL Server 64bits project and I use Oracle 64bits all the time. The main problems may be related to your applications and not specific to the databases. Hope this helps.
Kind regards,
Gift Peddie
April 11, 2007 at 7:25 am
Thanks for the information. I was not sure as to what my option were. I new that we could back up the known database, reload SQL as a 64 bit then restore from backup. What I wasn't sure of is if you can load SQL 2005 64 bit over the top some how to update the 32 bit version of SQL 2005.
The biggest problem is that we had set up two servers to create the principal and the failover, but my IT department set up the principal as a 32 bit and the database are running live. This makes it a little bit harder to convert to 64 bit. Any suggestions?
April 11, 2007 at 1:28 pm
I would think a backup and restore of the latest after you have worked out all the issues will take care of that. In the database there are very few issues I develop 32bits application against Oracle 64bits and I compile the code with any CPU so if you use any CPU for the application I don't see any problems, since 2005 all .NET development I have done is with Oracle 64bits. Hope this helps.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply