dbTalk Databases Forums  

SQL 2008 failover cluster and DTS

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL 2008 failover cluster and DTS in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Piotr
 
Posts: n/a

Default SQL 2008 failover cluster and DTS - 12-20-2008 , 06:03 AM






Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system from
stand alone SQL Server 2000. I had no big issues migrating databases but now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.


Reply With Quote
  #2  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM






Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #3  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #4  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #5  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #6  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #7  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #8  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #9  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
  #10  
Old   
Uri Dimant
 
Posts: n/a

Default Re: SQL 2008 failover cluster and DTS - 12-20-2008 , 06:32 AM



Piotr
You will have to save a DTS as a structure file and import it in SS2008.


"Piotr" <Piotr (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi

Could you help me fix following problem please?

I have new SQL Server 2008 fail over cluster and need to migrate system
from
stand alone SQL Server 2000. I had no big issues migrating databases but
now
found a problem. I need to move DTSs from old server to SQL 2008 fail over
cluster.

Please advise me what is correct way to do this. As far as I know it is
impossible to use them as cluster resource.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.