Wednesday, March 28, 2012

Migrating back to SQL 7 from 2000. Possible ? Advisable ? using DT

Hello,
I have a weird task. After going to SQL 2000 from SQL 7 on a
weekend...after a few days...incase of problems... I might be asked to
revert back to SQL 7 with those upgrade SQL 2000 databases.
Now, I know this cannot be done, but is there a possibility of using DTS to
do this ?
I have tried DTS from SQL 2000 to SQL 7... out of the 6 databases it worked
for 4. Although it does seem kind of "unclean" way to do it.
With the 5th database, I can move everything but procedures. Some of the
procedures refer to columns in user tables which don't exist.
With the 6th database, it seems max precision is set to 38 on SQL 2000 but
only 28 on SQL 7. Which is why this one isn't working at all.
Any suggestions ? Over should I just mark this "unclean" way of going from
SQL 2000 to SQL 7 as NOT an option ?
Thanks in advance.
-Kunal.DTS-Copy Objects
Do you have an 'old' SQL Server7 backup files? I mean just RESTORE those
backup files to SQL Server 7 and SQL Server2000 out
"kunalap" <kunalap@.discussions.microsoft.com> wrote in message
news:E9CE8FDB-D05C-4E40-9B43-ED433F74B1DA@.microsoft.com...
> Hello,
> I have a weird task. After going to SQL 2000 from SQL 7 on a
> weekend...after a few days...incase of problems... I might be asked to
> revert back to SQL 7 with those upgrade SQL 2000 databases.
> Now, I know this cannot be done, but is there a possibility of using DTS
to
> do this ?
> I have tried DTS from SQL 2000 to SQL 7... out of the 6 databases it
worked
> for 4. Although it does seem kind of "unclean" way to do it.
> With the 5th database, I can move everything but procedures. Some of the
> procedures refer to columns in user tables which don't exist.
> With the 6th database, it seems max precision is set to 38 on SQL 2000 but
> only 28 on SQL 7. Which is why this one isn't working at all.
> Any suggestions ? Over should I just mark this "unclean" way of going from
> SQL 2000 to SQL 7 as NOT an option ?
> Thanks in advance.
> -Kunal.
>|||Thanks for the reply.
No, I cannot restore the backups of 7 taken prior to migrating to SQL 2000
bacause there will be some transaction/activity in the database on SQL 2000
itself.
Example...they might use SQL 2000 for a week or 2 before they tell me now
they wanna go back to SQL 7 so data loss of those 2 weeks is not acceptable.
As for DTS. Im having the problem of precision being 28 on SQL 7 but 38 on
SQL 2000.
Any thoughts/suggestions ?
Thanks.
"Uri Dimant" wrote:
> DTS-Copy Objects
> Do you have an 'old' SQL Server7 backup files? I mean just RESTORE those
> backup files to SQL Server 7 and SQL Server2000 out
> "kunalap" <kunalap@.discussions.microsoft.com> wrote in message
> news:E9CE8FDB-D05C-4E40-9B43-ED433F74B1DA@.microsoft.com...
> > Hello,
> >
> > I have a weird task. After going to SQL 2000 from SQL 7 on a
> > weekend...after a few days...incase of problems... I might be asked to
> > revert back to SQL 7 with those upgrade SQL 2000 databases.
> >
> > Now, I know this cannot be done, but is there a possibility of using DTS
> to
> > do this ?
> > I have tried DTS from SQL 2000 to SQL 7... out of the 6 databases it
> worked
> > for 4. Although it does seem kind of "unclean" way to do it.
> >
> > With the 5th database, I can move everything but procedures. Some of the
> > procedures refer to columns in user tables which don't exist.
> >
> > With the 6th database, it seems max precision is set to 38 on SQL 2000 but
> > only 28 on SQL 7. Which is why this one isn't working at all.
> >
> > Any suggestions ? Over should I just mark this "unclean" way of going from
> > SQL 2000 to SQL 7 as NOT an option ?
> >
> > Thanks in advance.
> >
> > -Kunal.
> >
>
>|||I see, have you tried to change (play around) with a precision?
"kunalap" <kunalap@.discussions.microsoft.com> wrote in message
news:767C75B1-9C9F-44A1-8EE2-09FDE29C16C2@.microsoft.com...
> Thanks for the reply.
> No, I cannot restore the backups of 7 taken prior to migrating to SQL 2000
> bacause there will be some transaction/activity in the database on SQL
2000
> itself.
> Example...they might use SQL 2000 for a week or 2 before they tell me now
> they wanna go back to SQL 7 so data loss of those 2 weeks is not
acceptable.
> As for DTS. Im having the problem of precision being 28 on SQL 7 but 38 on
> SQL 2000.
> Any thoughts/suggestions ?
> Thanks.
> "Uri Dimant" wrote:
> > DTS-Copy Objects
> >
> > Do you have an 'old' SQL Server7 backup files? I mean just RESTORE those
> > backup files to SQL Server 7 and SQL Server2000 out
> >
> > "kunalap" <kunalap@.discussions.microsoft.com> wrote in message
> > news:E9CE8FDB-D05C-4E40-9B43-ED433F74B1DA@.microsoft.com...
> > > Hello,
> > >
> > > I have a weird task. After going to SQL 2000 from SQL 7 on a
> > > weekend...after a few days...incase of problems... I might be asked
to
> > > revert back to SQL 7 with those upgrade SQL 2000 databases.
> > >
> > > Now, I know this cannot be done, but is there a possibility of using
DTS
> > to
> > > do this ?
> > > I have tried DTS from SQL 2000 to SQL 7... out of the 6 databases it
> > worked
> > > for 4. Although it does seem kind of "unclean" way to do it.
> > >
> > > With the 5th database, I can move everything but procedures. Some of
the
> > > procedures refer to columns in user tables which don't exist.
> > >
> > > With the 6th database, it seems max precision is set to 38 on SQL 2000
but
> > > only 28 on SQL 7. Which is why this one isn't working at all.
> > >
> > > Any suggestions ? Over should I just mark this "unclean" way of going
from
> > > SQL 2000 to SQL 7 as NOT an option ?
> > >
> > > Thanks in advance.
> > >
> > > -Kunal.
> > >
> >
> >
> >|||Hi
If the business needs a plan to revert back to an old platform 2 weeks
later, then tell the business now they should do better testing before you go
live.
Once you do the migration, and run initial tests, I would say that is the
point of non-return.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"kunalap" wrote:
> Thanks for the reply.
> No, I cannot restore the backups of 7 taken prior to migrating to SQL 2000
> bacause there will be some transaction/activity in the database on SQL 2000
> itself.
> Example...they might use SQL 2000 for a week or 2 before they tell me now
> they wanna go back to SQL 7 so data loss of those 2 weeks is not acceptable.
> As for DTS. Im having the problem of precision being 28 on SQL 7 but 38 on
> SQL 2000.
> Any thoughts/suggestions ?
> Thanks.
> "Uri Dimant" wrote:
> > DTS-Copy Objects
> >
> > Do you have an 'old' SQL Server7 backup files? I mean just RESTORE those
> > backup files to SQL Server 7 and SQL Server2000 out
> >
> > "kunalap" <kunalap@.discussions.microsoft.com> wrote in message
> > news:E9CE8FDB-D05C-4E40-9B43-ED433F74B1DA@.microsoft.com...
> > > Hello,
> > >
> > > I have a weird task. After going to SQL 2000 from SQL 7 on a
> > > weekend...after a few days...incase of problems... I might be asked to
> > > revert back to SQL 7 with those upgrade SQL 2000 databases.
> > >
> > > Now, I know this cannot be done, but is there a possibility of using DTS
> > to
> > > do this ?
> > > I have tried DTS from SQL 2000 to SQL 7... out of the 6 databases it
> > worked
> > > for 4. Although it does seem kind of "unclean" way to do it.
> > >
> > > With the 5th database, I can move everything but procedures. Some of the
> > > procedures refer to columns in user tables which don't exist.
> > >
> > > With the 6th database, it seems max precision is set to 38 on SQL 2000 but
> > > only 28 on SQL 7. Which is why this one isn't working at all.
> > >
> > > Any suggestions ? Over should I just mark this "unclean" way of going from
> > > SQL 2000 to SQL 7 as NOT an option ?
> > >
> > > Thanks in advance.
> > >
> > > -Kunal.
> > >
> >
> >
> >|||Thats what I have told them.
Just what I wanted to hear.
Thanks.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> If the business needs a plan to revert back to an old platform 2 weeks
> later, then tell the business now they should do better testing before you go
> live.
> Once you do the migration, and run initial tests, I would say that is the
> point of non-return.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "kunalap" wrote:
> > Thanks for the reply.
> >
> > No, I cannot restore the backups of 7 taken prior to migrating to SQL 2000
> > bacause there will be some transaction/activity in the database on SQL 2000
> > itself.
> >
> > Example...they might use SQL 2000 for a week or 2 before they tell me now
> > they wanna go back to SQL 7 so data loss of those 2 weeks is not acceptable.
> >
> > As for DTS. Im having the problem of precision being 28 on SQL 7 but 38 on
> > SQL 2000.
> >
> > Any thoughts/suggestions ?
> >
> > Thanks.
> >
> > "Uri Dimant" wrote:
> >
> > > DTS-Copy Objects
> > >
> > > Do you have an 'old' SQL Server7 backup files? I mean just RESTORE those
> > > backup files to SQL Server 7 and SQL Server2000 out
> > >
> > > "kunalap" <kunalap@.discussions.microsoft.com> wrote in message
> > > news:E9CE8FDB-D05C-4E40-9B43-ED433F74B1DA@.microsoft.com...
> > > > Hello,
> > > >
> > > > I have a weird task. After going to SQL 2000 from SQL 7 on a
> > > > weekend...after a few days...incase of problems... I might be asked to
> > > > revert back to SQL 7 with those upgrade SQL 2000 databases.
> > > >
> > > > Now, I know this cannot be done, but is there a possibility of using DTS
> > > to
> > > > do this ?
> > > > I have tried DTS from SQL 2000 to SQL 7... out of the 6 databases it
> > > worked
> > > > for 4. Although it does seem kind of "unclean" way to do it.
> > > >
> > > > With the 5th database, I can move everything but procedures. Some of the
> > > > procedures refer to columns in user tables which don't exist.
> > > >
> > > > With the 6th database, it seems max precision is set to 38 on SQL 2000 but
> > > > only 28 on SQL 7. Which is why this one isn't working at all.
> > > >
> > > > Any suggestions ? Over should I just mark this "unclean" way of going from
> > > > SQL 2000 to SQL 7 as NOT an option ?
> > > >
> > > > Thanks in advance.
> > > >
> > > > -Kunal.
> > > >
> > >
> > >
> > >

No comments:

Post a Comment