|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
 |
|
|
LinkBack | Outils de la discussion |
10/09/2008, 21h54
|
#1 |
Messages: n/a
Hébergeur: |
restoring a database from sql2005 32 bit to sql2005 64 bit
I have a dev server running sql2005 32 bit production is running sql2005 64
bit Can I or will I run into a problem moving or restoring database and ssis package to the Production server ? |
|
|
10/09/2008, 22h46
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: restoring a database from sql2005 32 bit to sql2005 64 bit
cmf,
No problem with moving databases between 32 and 64 bit servers at the same version level, such as SQL2005. The bits on disk are the same. SSIS packages may have a problem if they depend on 32-bit DLLs. If not no problem, but it you run into this, check out the article on 64-bit Considerations for Integration Services. http://msdn.microsoft.com/en-us/library/ms141766.aspx RLF "cmf" <cmf@discussions.microsoft.com> wrote in message news:7EFA1C36-9DB6-4ABE-A5FB-7E21B88BB1B6@microsoft.com... >I have a dev server running sql2005 32 bit production is running sql2005 64 > bit > > Can I or will I run into a problem moving or restoring database and ssis > package to the Production server ? |
|
|
|
11/09/2008, 06h24
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: restoring a database from sql2005 32 bit to sql2005 64 bit
cmf
I agree with Russel about problems you may having with SSIS. We have a cluster 64 bit with SQL Server 2005 65 bit and cannot schedule SSIS Packages due to Client Access for 64 bit as our NetAdimin said me. "cmf" <cmf@discussions.microsoft.com> wrote in message news:7EFA1C36-9DB6-4ABE-A5FB-7E21B88BB1B6@microsoft.com... >I have a dev server running sql2005 32 bit production is running sql2005 64 > bit > > Can I or will I run into a problem moving or restoring database and ssis > package to the Production server ? |
|
|
|
11/09/2008, 12h28
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: restoring a database from sql2005 32 bit to sql2005 64 bit
Sorry ,should be Russell
"Uri Dimant" <urid@iscar.co.il> wrote in message news:uuDsQY8EJHA.3408@TK2MSFTNGP04.phx.gbl... > cmf > I agree with Russel about problems you may having with SSIS. We have a > cluster 64 bit with SQL Server 2005 65 bit and cannot schedule SSIS > Packages due to Client Access for 64 bit as our NetAdimin said me. > > > > > "cmf" <cmf@discussions.microsoft.com> wrote in message > news:7EFA1C36-9DB6-4ABE-A5FB-7E21B88BB1B6@microsoft.com... >>I have a dev server running sql2005 32 bit production is running sql2005 >>64 >> bit >> >> Can I or will I run into a problem moving or restoring database and ssis >> package to the Production server ? > > |
|
|
|
11/09/2008, 14h42
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: restoring a database from sql2005 32 bit to sql2005 64 bit
Uri, No problem.
I have not heard of the problem you mention. (Or maybe I misunderstand.) Does the article on running 32-bit SSIS on a 64-bit server you any? Although we are not heavy SSIS users, since we are still mostly running unconverted DTS jobs, we do have some SQL Agent jobs running on a 64-bit cluster in both 64-bit and 32-bit mode with no apparent problems. RLF "Uri Dimant" <urid@iscar.co.il> wrote in message news:ugigbj$EJHA.5104@TK2MSFTNGP02.phx.gbl... > Sorry ,should be Russell > > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:uuDsQY8EJHA.3408@TK2MSFTNGP04.phx.gbl... >> cmf >> I agree with Russel about problems you may having with SSIS. We have a >> cluster 64 bit with SQL Server 2005 65 bit and cannot schedule SSIS >> Packages due to Client Access for 64 bit as our NetAdimin said me. >> >> >> >> >> "cmf" <cmf@discussions.microsoft.com> wrote in message >> news:7EFA1C36-9DB6-4ABE-A5FB-7E21B88BB1B6@microsoft.com... >>>I have a dev server running sql2005 32 bit production is running sql2005 >>>64 >>> bit >>> >>> Can I or will I run into a problem moving or restoring database and ssis >>> package to the Production server ? >> >> > > |
|
|
|
11/09/2008, 15h26
|
#6 |
|
Messages: n/a
Hébergeur: |
Re: restoring a database from sql2005 32 bit to sql2005 64 bit
Russell
I think the problem occurs only we added SSIS service after establish a cluster and install SQL Server. The problem is Client Access for 64 bit at least I believe and error message points out. >Does the article on running 32-bit SSIS What do you mean? Rinning SSIS service 32 bit on Windows 64 bit (SQL Server 2005 64 bit)? "Russell Fields" <russellfields@nomail.com> wrote in message news:ec2jhvAFJHA.680@TK2MSFTNGP03.phx.gbl... > Uri, No problem. > > I have not heard of the problem you mention. (Or maybe I misunderstand.) > Does the article on running 32-bit SSIS on a 64-bit server you any? > > Although we are not heavy SSIS users, since we are still mostly running > unconverted DTS jobs, we do have some SQL Agent jobs running on a 64-bit > cluster in both 64-bit and 32-bit mode with no apparent problems. > > RLF > > "Uri Dimant" <urid@iscar.co.il> wrote in message > news:ugigbj$EJHA.5104@TK2MSFTNGP02.phx.gbl... >> Sorry ,should be Russell >> >> >> "Uri Dimant" <urid@iscar.co.il> wrote in message >> news:uuDsQY8EJHA.3408@TK2MSFTNGP04.phx.gbl... >>> cmf >>> I agree with Russel about problems you may having with SSIS. We have a >>> cluster 64 bit with SQL Server 2005 65 bit and cannot schedule SSIS >>> Packages due to Client Access for 64 bit as our NetAdimin said me. >>> >>> >>> >>> >>> "cmf" <cmf@discussions.microsoft.com> wrote in message >>> news:7EFA1C36-9DB6-4ABE-A5FB-7E21B88BB1B6@microsoft.com... >>>>I have a dev server running sql2005 32 bit production is running sql2005 >>>>64 >>>> bit >>>> >>>> Can I or will I run into a problem moving or restoring database and >>>> ssis >>>> package to the Production server ? >>> >>> >> >> > > |
|
|
|
19/09/2008, 19h28
|
#7 |
|
Messages: n/a
Hébergeur: |
Re: restoring a database from sql2005 32 bit to sql2005 64 bit
Uri,
Sorry, but I missed your query. Yes, the Books Online describe how to run 32-bit SSIS on a 64-bit server. See: http://msdn.microsoft.com/en-us/libr...6(SQL.90).aspx Also: http://support.microsoft.com/kb/934653/ RLF "Uri Dimant" <urid@iscar.co.il> wrote in message news:ODWJ$GBFJHA.768@TK2MSFTNGP05.phx.gbl... > Russell > > I think the problem occurs only we added SSIS service after establish a > cluster and install SQL Server. The problem is Client Access for 64 bit > at least I believe and error message points out. > >Does the article on running 32-bit SSIS > What do you mean? Rinning SSIS service 32 bit on Windows 64 bit (SQL > Server 2005 64 bit)? > > > > "Russell Fields" <russellfields@nomail.com> wrote in message > news:ec2jhvAFJHA.680@TK2MSFTNGP03.phx.gbl... >> Uri, No problem. >> >> I have not heard of the problem you mention. (Or maybe I misunderstand.) >> Does the article on running 32-bit SSIS on a 64-bit server you any? >> >> Although we are not heavy SSIS users, since we are still mostly running >> unconverted DTS jobs, we do have some SQL Agent jobs running on a 64-bit >> cluster in both 64-bit and 32-bit mode with no apparent problems. >> >> RLF >> >> "Uri Dimant" <urid@iscar.co.il> wrote in message >> news:ugigbj$EJHA.5104@TK2MSFTNGP02.phx.gbl... >>> Sorry ,should be Russell >>> >>> >>> "Uri Dimant" <urid@iscar.co.il> wrote in message >>> news:uuDsQY8EJHA.3408@TK2MSFTNGP04.phx.gbl... >>>> cmf >>>> I agree with Russel about problems you may having with SSIS. We have a >>>> cluster 64 bit with SQL Server 2005 65 bit and cannot schedule SSIS >>>> Packages due to Client Access for 64 bit as our NetAdimin said me. >>>> >>>> >>>> >>>> >>>> "cmf" <cmf@discussions.microsoft.com> wrote in message >>>> news:7EFA1C36-9DB6-4ABE-A5FB-7E21B88BB1B6@microsoft.com... >>>>>I have a dev server running sql2005 32 bit production is running >>>>>sql2005 64 >>>>> bit >>>>> >>>>> Can I or will I run into a problem moving or restoring database and >>>>> ssis >>>>> package to the Production server ? >>>> >>>> >>> >>> >> >> > > |
|
|
|
| Outils de la discussion | |
|
|
