Restore a veritas online backup SQL 2000 IA64 db to a SQL 2005 x64 64 bits DB

Question

Restore a veritas online backup SQL 2000 IA64 db to a SQL 2005 x64 64 bits DB

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281344 More actions · Answer 1

You could develop an SSIS package to move the data from prod to QA on a daily basis. It would be quite an undertaking but your options are limited.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

juana.gomez SSC Enthusiast Points: 132 More actions · Answer 2

I am aware that is a ETL tool - but i am not very familir with it....any advice?

Thanks so much for your help you ahve been a great support!

SQLRNNR SSC Guru Points: 281344 More actions · Answer 3

Are you familiar with dts?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

juana.gomez SSC Enthusiast Points: 132 More actions · Answer 4

if you can give me some information i can look someone who is familiar to it!

SQLRNNR SSC Guru Points: 281344 More actions · Answer 5

I would start by Googling for SSIS and DTS. DTS is SQL 2000 and SSIS is new in SQL 2005.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events