(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
