|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Moving SQL Server 2000 to SQL Server 2005 - Need suggestions on syncronization of data between theOur current production database server is SQL Server 2000 and it is running on Windows 2000 server. Now as part of the upgrade we bouht a new machine and installed Windows 2003 Server and SQL Server 2005 on it. Now our idea is to move the databases from the current production to the new SQL Server 2005. 1).How do we do that? Is it just do a restore of the most recent back up of a particular database on the new new SQL Server 2005? 2).Also we are thinking to syncronize the data between the current production server and the new SQL Server 2005. So that at one point it thins are ok then we could point the web app to the new SQL Server 2005 which is currently pointing to the current production SQL Server . In other words how do make transition from the current SQL Server 2000 to our new SQL Server 2005? Can any body suggest me a starting point on this on how do we do this? Your help is hihly appreciated. Thanks, -L Please don't post independently in separate newsgroups. You can add
multiple newsgroups to the header and then all the answers appear as one. See my reply in the other newsgroup. -- Show quoteAndrew J. Kelly SQL MVP Solid Quality Mentors "Learner" <pra***@gmail.com> wrote in message news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@o6g2000hsd.googlegroups.com... > Hi, > > Our current production database server is SQL Server 2000 and it is > running on Windows 2000 server. > > > Now as part of the upgrade we bouht a new machine and installed > Windows 2003 Server and SQL Server 2005 on it. > > > Now our idea is to move the databases from the current production to > the new SQL Server 2005. 1).How do we do that? Is it just do a > restore > of the most recent back up of a particular database on the new new > SQL > Server 2005? > > > 2).Also we are thinking to syncronize the data between the current > production server and the new SQL Server 2005. So that at one point > it > thins are ok then we could point the web app to the new SQL Server > 2005 which is currently pointing to the current production SQL > Server . > > > In other words how do make transition from the current SQL Server > 2000 > to our new SQL Server 2005? > > > Can any body suggest me a starting point on this on how do we do > this? > Your help is hihly appreciated. > > > Thanks, > > > -L > >
Show quote
On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> Hi,wrote: > Please don't post independently in separate newsgroups. You can add > multiple newsgroups to the header and then all the answers appear as one. > See my reply in the other newsgroup. > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > "Learner" <pra***@gmail.com> wrote in message > > news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@o6g2000hsd.googlegroups.com... > > > > > Hi, > > > Our current production database server is SQL Server 2000 and it is > > running on Windows 2000 server. > > > Now as part of the upgrade we bouht a new machine and installed > > Windows 2003 Server and SQL Server 2005 on it. > > > Now our idea is to move the databases from the current production to > > the new SQL Server 2005. 1).How do we do that? Is it just do a > > restore > > of the most recent back up of a particular database on the new new > > SQL > > Server 2005? > > > 2).Also we are thinking to syncronize the data between the current > > production server and the new SQL Server 2005. So that at one point > > it > > thins are ok then we could point the web app to the new SQL Server > > 2005 which is currently pointing to the current production SQL > > Server . > > > In other words how do make transition from the current SQL Server > > 2000 > > to our new SQL Server 2005? > > > Can any body suggest me a starting point on this on how do we do > > this? > > Your help is hihly appreciated. > > > Thanks, > > > -L- Hide quoted text - > > - Show quoted text - Thank you for the high level suggestions and all the links that you uys have provided. I will to go through one after the other I guess I shold be fine with these links. Kelly - I just wanted a quick start on this issue so I posted in two different locations of SQL Server. I am sorry for any inconvenience. By the way I din't know that we could post in one location and have it appeared in multiple related groups. How do we do that? Ben - The link you provided should help me with a proper planing to implement the upgrade process. Thank You, -L >By the way I din't know that we could post in one location and have it Yup a lot of people don't realize it so that is why I posted the message. If >appeared in multiple related groups. How do we do that? you are using OE just click on the NewsGroups Icon at the top of the message and you can choose additional groups. Then replies go to all at once. -- Show quoteAndrew J. Kelly SQL MVP Solid Quality Mentors "Learner" <pra***@gmail.com> wrote in message news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@i29g2000prf.googlegroups.com... > On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> > wrote: >> Please don't post independently in separate newsgroups. You can add >> multiple newsgroups to the header and then all the answers appear as one. >> See my reply in the other newsgroup. >> >> -- >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >> "Learner" <pra***@gmail.com> wrote in message >> >> news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@o6g2000hsd.googlegroups.com... >> >> >> >> > Hi, >> >> > Our current production database server is SQL Server 2000 and it is >> > running on Windows 2000 server. >> >> > Now as part of the upgrade we bouht a new machine and installed >> > Windows 2003 Server and SQL Server 2005 on it. >> >> > Now our idea is to move the databases from the current production to >> > the new SQL Server 2005. 1).How do we do that? Is it just do a >> > restore >> > of the most recent back up of a particular database on the new new >> > SQL >> > Server 2005? >> >> > 2).Also we are thinking to syncronize the data between the current >> > production server and the new SQL Server 2005. So that at one point >> > it >> > thins are ok then we could point the web app to the new SQL Server >> > 2005 which is currently pointing to the current production SQL >> > Server . >> >> > In other words how do make transition from the current SQL Server >> > 2000 >> > to our new SQL Server 2005? >> >> > Can any body suggest me a starting point on this on how do we do >> > this? >> > Your help is hihly appreciated. >> >> > Thanks, >> >> > -L- Hide quoted text - >> >> - Show quoted text - > > Hi, > > Thank you for the high level suggestions and all the links that you > uys have provided. I will to go through one after the other I guess I > shold be fine with these links. > > Kelly - I just wanted a quick start on this issue so I posted in two > different locations of SQL Server. I am sorry for any inconvenience. > By the way I din't know that we could post in one location and have it > appeared in multiple related groups. How do we do that? > > Ben - The link you provided should help me with a proper planing to > implement the upgrade process. > > Thank You, > -L
Show quote
On Nov 28, 2:53 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> HI Kelly,wrote: > >By the way I din't know that we could post in one location and have it > >appeared in multiple related groups. How do we do that? > > Yup a lot of people don't realize it so that is why I posted the message. If > you are using OE just click on the NewsGroups Icon at the top of the message > and you can choose additional groups. Then replies go to all at once. > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > "Learner" <pra***@gmail.com> wrote in message > > news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@i29g2000prf.googlegroups.com... > > > > > On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> > > wrote: > >> Please don't post independently in separate newsgroups. You can add > >> multiple newsgroups to the header and then all the answers appear as one. > >> See my reply in the other newsgroup. > > >> -- > >> Andrew J. Kelly SQL MVP > >> Solid Quality Mentors > > >> "Learner" <pra***@gmail.com> wrote in message > > >>news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@o6g2000hsd.googlegroups.com... > > >> > Hi, > > >> > Our current production database server is SQL Server 2000 and it is > >> > running on Windows 2000 server. > > >> > Now as part of the upgrade we bouht a new machine and installed > >> > Windows 2003 Server and SQL Server 2005 on it. > > >> > Now our idea is to move the databases from the current production to > >> > the new SQL Server 2005. 1).How do we do that? Is it just do a > >> > restore > >> > of the most recent back up of a particular database on the new new > >> > SQL > >> > Server 2005? > > >> > 2).Also we are thinking to syncronize the data between the current > >> > production server and the new SQL Server 2005. So that at one point > >> > it > >> > thins are ok then we could point the web app to the new SQL Server > >> > 2005 which is currently pointing to the current production SQL > >> > Server . > > >> > In other words how do make transition from the current SQL Server > >> > 2000 > >> > to our new SQL Server 2005? > > >> > Can any body suggest me a starting point on this on how do we do > >> > this? > >> > Your help is hihly appreciated. > > >> > Thanks, > > >> > -L- Hide quoted text - > > >> - Show quoted text - > > > Hi, > > > Thank you for the high level suggestions and all the links that you > > uys have provided. I will to go through one after the other I guess I > > shold be fine with these links. > > > Kelly - I just wanted a quick start on this issue so I posted in two > > different locations of SQL Server. I am sorry for any inconvenience. > > By the way I din't know that we could post in one location and have it > > appeared in multiple related groups. How do we do that? > > > Ben - The link you provided should help me with a proper planing to > > implement the upgrade process. > > > Thank You, > > -L- Hide quoted text - > > - Show quoted text - Thanks for taking time to help me out here but I can't find NewsGroups icon at the top of the any of our messages or on the top of the message. What are you reffering to when you said if I am using OE? Thanks, -L OE stands for Outlook Express. If you are using another newsreader or the
web I don't know what it looks like. In OE the top of the page looks similar to this: News Server: [SQL Server News ] (icon) Newsgroups: [ ] (icon) Cc: [ ] Subject: [ ] But the bottom line is that you can add more or different newsgroups to the Newsgroups section seperated by a comma to post to all of them at once. (icon) Newsgroups: [ microsoft.public.sqlserver.server, microsoft.public.sqlserver.programming ] Hope that helps, -- Show quoteAndrew J. Kelly SQL MVP Solid Quality Mentors "Learner" <pra***@gmail.com> wrote in message news:9ee61f2f-7576-4338-a056-d6f628c0e593@v4g2000hsf.googlegroups.com... > On Nov 28, 2:53 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> > wrote: >> >By the way I din't know that we could post in one location and have it >> >appeared in multiple related groups. How do we do that? >> >> Yup a lot of people don't realize it so that is why I posted the message. >> If >> you are using OE just click on the NewsGroups Icon at the top of the >> message >> and you can choose additional groups. Then replies go to all at once. >> >> -- >> Andrew J. Kelly SQL MVP >> Solid Quality Mentors >> >> "Learner" <pra***@gmail.com> wrote in message >> >> news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@i29g2000prf.googlegroups.com... >> >> >> >> > On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> >> > wrote: >> >> Please don't post independently in separate newsgroups. You can add >> >> multiple newsgroups to the header and then all the answers appear as >> >> one. >> >> See my reply in the other newsgroup. >> >> >> -- >> >> Andrew J. Kelly SQL MVP >> >> Solid Quality Mentors >> >> >> "Learner" <pra***@gmail.com> wrote in message >> >> >>news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@o6g2000hsd.googlegroups.com... >> >> >> > Hi, >> >> >> > Our current production database server is SQL Server 2000 and it is >> >> > running on Windows 2000 server. >> >> >> > Now as part of the upgrade we bouht a new machine and installed >> >> > Windows 2003 Server and SQL Server 2005 on it. >> >> >> > Now our idea is to move the databases from the current production to >> >> > the new SQL Server 2005. 1).How do we do that? Is it just do a >> >> > restore >> >> > of the most recent back up of a particular database on the new new >> >> > SQL >> >> > Server 2005? >> >> >> > 2).Also we are thinking to syncronize the data between the current >> >> > production server and the new SQL Server 2005. So that at one point >> >> > it >> >> > thins are ok then we could point the web app to the new SQL Server >> >> > 2005 which is currently pointing to the current production SQL >> >> > Server . >> >> >> > In other words how do make transition from the current SQL Server >> >> > 2000 >> >> > to our new SQL Server 2005? >> >> >> > Can any body suggest me a starting point on this on how do we do >> >> > this? >> >> > Your help is hihly appreciated. >> >> >> > Thanks, >> >> >> > -L- Hide quoted text - >> >> >> - Show quoted text - >> >> > Hi, >> >> > Thank you for the high level suggestions and all the links that you >> > uys have provided. I will to go through one after the other I guess I >> > shold be fine with these links. >> >> > Kelly - I just wanted a quick start on this issue so I posted in two >> > different locations of SQL Server. I am sorry for any inconvenience. >> > By the way I din't know that we could post in one location and have it >> > appeared in multiple related groups. How do we do that? >> >> > Ben - The link you provided should help me with a proper planing to >> > implement the upgrade process. >> >> > Thank You, >> > -L- Hide quoted text - >> >> - Show quoted text - > > HI Kelly, > > Thanks for taking time to help me out here but I can't find > NewsGroups icon at the top of the any of our messages or on the top of > the message. What are you reffering to when you said if I am using OE? > > Thanks, > > -L
Show quote
On Nov 29, 9:32 am, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> Thanks I got it.wrote: > OE stands for Outlook Express. If you are using another newsreader or the > web I don't know what it looks like. In OE the top of the page looks similar > to this: > > News Server: [SQL Server News > ] > (icon) Newsgroups: [ > ] > (icon) Cc: > [ > ] > > Subject: > [ > ] > > But the bottom line is that you can add more or different newsgroups to the > Newsgroups section seperated by a comma to post to all of them at once. > > (icon) Newsgroups: [ microsoft.public.sqlserver.server, > microsoft.public.sqlserver.programming ] > > Hope that helps, > > -- > Andrew J. Kelly SQL MVP > Solid Quality Mentors > > "Learner" <pra***@gmail.com> wrote in message > > news:9ee61f2f-7576-4338-a056-d6f628c0e593@v4g2000hsf.googlegroups.com... > > > > > On Nov 28, 2:53 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> > > wrote: > >> >By the way I din't know that we could post in one location and have it > >> >appeared in multiple related groups. How do we do that? > > >> Yup a lot of people don't realize it so that is why I posted the message. > >> If > >> you are using OE just click on the NewsGroups Icon at the top of the > >> message > >> and you can choose additional groups. Then replies go to all at once. > > >> -- > >> Andrew J. Kelly SQL MVP > >> Solid Quality Mentors > > >> "Learner" <pra***@gmail.com> wrote in message > > >>news:d71c424b-7a7c-40bb-bddf-dc4c94f279cd@i29g2000prf.googlegroups.com... > > >> > On Nov 28, 1:00 pm, "Andrew J. Kelly" <sqlmvpnooos***@shadhawk.com> > >> > wrote: > >> >> Please don't post independently in separate newsgroups. You can add > >> >> multiple newsgroups to the header and then all the answers appear as > >> >> one. > >> >> See my reply in the other newsgroup. > > >> >> -- > >> >> Andrew J. Kelly SQL MVP > >> >> Solid Quality Mentors > > >> >> "Learner" <pra***@gmail.com> wrote in message > > >> >>news:d505cae9-2eb0-4b27-9e1b-2a3a3fbab7c2@o6g2000hsd.googlegroups.com... > > >> >> > Hi, > > >> >> > Our current production database server is SQL Server 2000 and it is > >> >> > running on Windows 2000 server. > > >> >> > Now as part of the upgrade we bouht a new machine and installed > >> >> > Windows 2003 Server and SQL Server 2005 on it. > > >> >> > Now our idea is to move the databases from the current production to > >> >> > the new SQL Server 2005. 1).How do we do that? Is it just do a > >> >> > restore > >> >> > of the most recent back up of a particular database on the new new > >> >> > SQL > >> >> > Server 2005? > > >> >> > 2).Also we are thinking to syncronize the data between the current > >> >> > production server and the new SQL Server 2005. So that at one point > >> >> > it > >> >> > thins are ok then we could point the web app to the new SQL Server > >> >> > 2005 which is currently pointing to the current production SQL > >> >> > Server . > > >> >> > In other words how do make transition from the current SQL Server > >> >> > 2000 > >> >> > to our new SQL Server 2005? > > >> >> > Can any body suggest me a starting point on this on how do we do > >> >> > this? > >> >> > Your help is hihly appreciated. > > >> >> > Thanks, > > >> >> > -L- Hide quoted text - > > >> >> - Show quoted text - > > >> > Hi, > > >> > Thank you for the high level suggestions and all the links that you > >> > uys have provided. I will to go through one after the other I guess I > >> > shold be fine with these links. > > >> > Kelly - I just wanted a quick start on this issue so I posted in two > >> > different locations of SQL Server. I am sorry for any inconvenience. > >> > By the way I din't know that we could post in one location and have it > >> > appeared in multiple related groups. How do we do that? > > >> > Ben - The link you provided should help me with a proper planing to > >> > implement the upgrade process. > > >> > Thank You, > >> > -L- Hide quoted text - > > >> - Show quoted text - > > > HI Kelly, > > > Thanks for taking time to help me out here but I can't find > > NewsGroups icon at the top of the any of our messages or on the top of > > the message. What are you reffering to when you said if I am using OE? > > > Thanks, > > > -L- Hide quoted text - > > - Show quoted text - Some recommendations to get started:
1) Run SQL Server Upgrade Advisor on your database and follow its recommendations 2) Check the BOL section 'Upgrading to SQL Server 2005' 4) Take a look at this and see which sections apply to your case http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en 3) Restore a copy of your database in SQL Server 2005 and start testing your application Hope this helps, Ben Nevarez Senior Database Administrator AIG SunAmerica Show quote "Learner" wrote: > Hi, > > Our current production database server is SQL Server 2000 and it is > running on Windows 2000 server. > > > Now as part of the upgrade we bouht a new machine and installed > Windows 2003 Server and SQL Server 2005 on it. > > > Now our idea is to move the databases from the current production to > the new SQL Server 2005. 1).How do we do that? Is it just do a > restore > of the most recent back up of a particular database on the new new > SQL > Server 2005? > > > 2).Also we are thinking to syncronize the data between the current > production server and the new SQL Server 2005. So that at one point > it > thins are ok then we could point the web app to the new SQL Server > 2005 which is currently pointing to the current production SQL > Server . > > > In other words how do make transition from the current SQL Server > 2000 > to our new SQL Server 2005? > > > Can any body suggest me a starting point on this on how do we do > this? > Your help is hihly appreciated. > > > Thanks, > > > -L > > >  |
|||||||||||||||||||||||
Other interesting topics