If I create a database on 64bit version of SQL 2005 and then copy it to a
32bit version SQL 2005 will that database still work? and/or will
adminstrators have to make setting changes?All Editions of SQL within a major version maintain user database on-disk
compatibility across all architectures. That is a very complex way of
saying that any database created on any version/edition/processor
combination of SQL 2005 can be restored or copied to a SQL instance on any
other version/edition/processor combination. The sole exception is that SQL
Express will not accept a database over its 4GB size limit.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:C85E4CF8-BA5D-4300-898F-49650A72627C@.microsoft.com...
> If I create a database on 64bit version of SQL 2005 and then copy it to a
> 32bit version SQL 2005 will that database still work? and/or will
> adminstrators have to make setting changes?|||This is a multi-part message in MIME format.
--080803020901070905080703
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
In other words "yes it will work, all other things being equal".
;)
--
*mike hodgson*
http://sqlnerd.blogspot.com
Geoff N. Hiten wrote:
>All Editions of SQL within a major version maintain user database on-disk
>compatibility across all architectures. That is a very complex way of
>saying that any database created on any version/edition/processor
>combination of SQL 2005 can be restored or copied to a SQL instance on any
>other version/edition/processor combination. The sole exception is that SQL
>Express will not accept a database over its 4GB size limit.
>
>
--080803020901070905080703
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>In other words "yes it will work, all other things being equal".<br>
<br>
;)<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Geoff N. Hiten wrote:
<blockquote cite="midOflGC5GoGHA.4172@.TK2MSFTNGP03.phx.gbl" type="cite">
<pre wrap="">All Editions of SQL within a major version maintain user database on-disk
compatibility across all architectures. That is a very complex way of
saying that any database created on any version/edition/processor
combination of SQL 2005 can be restored or copied to a SQL instance on any
other version/edition/processor combination. The sole exception is that SQL
Express will not accept a database over its 4GB size limit.
</pre>
</blockquote>
</body>
</html>
--080803020901070905080703--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment