Thanks for the additional input. I will continue to look into this. Right now I just found out the software won't even run on a 64bit platform so my hopes of doing this this coming weekend are dashed.
James On Wed, May 18, 2011 at 5:28 PM, Richard Stovall <[email protected]> wrote: > (Caveat: I'm not a DBA, and I've never played one on TV.) > > The db may be a simple attach procedure, but DTS packages are apparently > not so transportable when moving to SSIS. I don't know exactly what's > stored in the master db, but anything there would have to be re-created. > Etc... > > On Wed, May 18, 2011 at 4:36 PM, James Kerr <[email protected]> wrote: > >> Thanks for that. I didn't think it was going to be a big deal. >> >> >> On Wed, May 18, 2011 at 4:24 PM, Tigran K <[email protected]> wrote: >> >>> Should be as simple as attach. You can also set the db compatibility >>> back down to 2000 level. >>> >>> --Tigran >>> >>> On Wed, May 18, 2011 at 1:06 PM, James Kerr <[email protected]> >>> wrote: >>> > I need to move a database from a 2003 server running SQL 2000 to a >>> machine >>> > running 2008R2 and SQL 2008R2. Should this be as easy as dismounting >>> the >>> > database and copying over the database files to the new server or will >>> SQL >>> > 2008 require me to do some kind of upgrade to the database first? >>> > >>> > James >>> > >>> > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >>> > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >>> > >>> > --- >>> > To manage subscriptions click here: >>> > http://lyris.sunbelt-software.com/read/my_forums/ >>> > or send an email to [email protected] >>> > with the body: unsubscribe ntsysadmin >>> >>> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >>> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >>> >>> --- >>> To manage subscriptions click here: >>> http://lyris.sunbelt-software.com/read/my_forums/ >>> or send an email to [email protected] >>> with the body: unsubscribe ntsysadmin >>> >>> >> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to [email protected] >> with the body: unsubscribe ntsysadmin >> > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
