Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-11-30 : 04:05:55
|
| Hi, I'm asked to transfer data (DB Schemes, data, tables, views, functions, ...) from SQLServer2005 32 bit to SQLserver2005 64 bit. I'd like to know if there's any point, I should consider before doing that to prevent any problem. Besides, what's the best and more safe way to do that? backup/restore or detach/attachAny idea is appreciated |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-11-30 : 04:09:51
|
| Both backup/restore and detach/attach will work fine. The structure of the data and log file are identical for 32 bit and 64 bit SQL 2005.The only place you're likely to have problems is with ODBC/OLEDB drivers if you have linked servers and/or lots of DTS/SSIS going to non-SQL sources/destinations--Gail ShawSQL Server MVP |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-11-30 : 04:39:05
|
| Thanks for the comment GailI'm having linked server! what shall I do then? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-30 : 08:19:42
|
| Yes the problem will be ODBC drivers for 64-bit. You need to download MSDASQL provider from microsoft and 64-bit drivers if you are connecting to non-sql sources and destination from vendors.What other non-sql sources are you using so I can direct with this? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-11-30 : 08:48:31
|
quote:
Originally posted by Peace2007
Thanks for the comment GailI'm having linked server! what shall I do then?
Get the appropriate 64-bit drivers and test very, very carefully. In my experience, 64 bit drivers tend to be buggier and less stable than the 32 bit, so test, test and test some more.What are the linked servers pointing at? If they're other SQL servers, it's not the slightest problem. If it's other databases, it'll be a little more tricky.--Gail ShawSQL Server MVP |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-12-02 : 02:01:49
|
| The 64 bit SQL2005 server should be linked to a few other SQL2005 servers. There are going to run many distributed query on those linked servers as well. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-12-02 : 03:51:15
|
| Then that should be fine. The 64 bit drivers for SQL come with SQL. It's when you have linked servers to Oracle, DB2, etc that things get 'entertaining'--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
Miagration from SQLServer 32 bit to SQLServer 64bi