Then why not create that table in the second database on the production box and then back fill it (you can use SSIS or DTS to quickly do this). Since the CF and ASP websites will be using two different tables (same data structure), will the ASP site be deactivated? I ask because the next step will depend on if both sites are actively "writing" to both tables and if you want the data to be consistent between them or not.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peyton Todd Sent: Monday, April 21, 2008 6:17 PM To: [email protected] Subject: RE: [ACFUG Discuss] Clone a SQL Server Database? Solved! Hi Greg - responses below in all CAPS. -----Original Message----- >From: "McTure, Greg" <[EMAIL PROTECTED]> >Sent: Apr 21, 2008 5:34 PM >To: [email protected] >Subject: RE: [ACFUG Discuss] Clone a SQL Server Database? Solved! > >Hi Peyton: > >I think you may have trade one problem for another here in solving this. > >Let me make sure that I understand your situation. You have a table on >an MSSQL 2000 instance that is being shared by a CF app and a ASP app >and you want the CF app to access the same data but in a different table >(preferably on a MSSQL 2005 instance). Is that correct? NO, NOT EXACTLY. MY OWN PC HAS MSSQL 2005. THE PRODUCTION SITE IS ENTIRELY MSSQL 2000, AND BOTH DATABASES WILL BE ON THAT INSTANCE. >First, with the restore you have solved the problem of getting the data >loaded into a table that is now separate but how will any new data >written to the old table get to the new table with this solution. > >Don't you want the data to be consistent between the two tables? You >may need to consider the use of triggers (if the new restored table is >on the same server as the old table) or replication (if different >servers). SEE MY RESPONSE TO STEVEN FOR A LOT MORE DETAIL ON THE SITUATION. I WILL BE QUIZZING THE CLIENT MORE ABOUT THE EXACT NATURE OF THE OTHER TWO SITES, BUT AT THIS POINT THE POSSIBLITY EXISTS THAT THE TABLE REALLY ISN'T USED IN THE OTHER SITES AT ALL. AND EVEN IF IT IS, THERE'S THE PRACTICAL FACT THAT - PAINFUL THOUGH IT MAY BE TO OUR PROGRAMMERS'S SENSE OF ASETHETICS - THE DATA COULD SIMPLY BE ENTERED SEPARATELY (IT'S A TOTAL OF 17 COURT REPORTERS AT PRESENT, AND NOT A RAPID TURNOVER). IF THE REPORTERS' INFORMATION IS BEING USED AT ALL IN THE OTHER TWO SITES, MY GUESS IS (KNOWING THE BOSS AS I DO, SINCE IT WAS I, OVER A PERIOD OF 20 YEARS, WHO WROTE ALL THE FOXPRO CODE FOR RUNNING MOST OF HIS BUSINESS), HE WILL OPT FOR SIMPLY MAKING THOSE UPDATES RIGHT IN MSSQL 2000 ITSELF. (THE OFFICE MANAGER IS SOMEWHAT COMPUTER-LITERATE). BUT I'LL GET BACK TO YOU IF THE SITUATION CHANGES! >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peyton Todd >Sent: Monday, April 21, 2008 4:51 PM >To: [email protected] >Subject: Re: [ACFUG Discuss] Clone a SQL Server Database? Solved! > >Something I read on a Microsoft User Forum cued me to the correct >answer: Instead of establishing the new DB first, all you have to do is >just say you want to 'restore' to it, even when it doesn't exist yet. >Key in the name you wish to assign to it into the 'To database' text >field of the wizard, and then select the existing DB in the 'From >database' drop-down list and click Okay. Evidently this so-called >'restore' does not even get its info from a backup, but gets it from the >live DB. > >-----Original Message----- >>From: Peyton Todd <[EMAIL PROTECTED]> >>Sent: Apr 21, 2008 4:30 PM >>To: [email protected] >>Subject: [ACFUG Discuss] How Clone a SQL Server Database? >> >>Are there any SQL Server Wizards in the crowd (the human kind, I mean)? >I have discovered that the site I'm building accesses a SQL Server table >also accessed by an ASP site on the same server, and I want to separate >them. So I want to make a clone of that SQL Server database for the >exclusive use of my site - one which will reside in the same SQL Server >installation. >> >>Part of the problem is that I have a SQL Server 2005 installation but >my only manual is for SQL Server 2000. The client's site has SQL Server >2000, but I'd like to: (a) know what to do before I arrive again at the >client's physical location, and (b) fully test my site with the cloned >DB before I install it on his server. >> >>So far, in trying to accomplish this with my own SQL Server 2005, I >have established the new DB but it's still empty. To populate it with >data from the existing DB, I've tried to backup and restore, but every >time I get a message objecting that the backup copy is of a DB with a >different name. That happens even if go to a different PC which has the >old DB on it, and RENAME it to the name of my new DB before making the >backup. When I take that backup to the main PC I'm working on and try to >restore from that backup to the new DB, it STILL complains that the name >is different, even though it was backed up from a DB which (now) has the >new name, and even though its filename is the same as the name of the >new DB. >> >>My SQL Server 2000 manual describes a Copy Database Wizard, but I can't >find it in the SQL Server 2005 Management Studio Express set of dialogs >(analog of what was Enterprise Manager in SQL Server 2000). >> >>Any suggestions? >> >>Thanks, >> >>Peyton >> >> >> >> >>------------------------------------------------------------- >>Annual Sponsor FigLeaf Software - http://www.figleaf.com >> >>To unsubscribe from this list, manage your profile @ >>http://www.acfug.org?fa=login.edituserform >> >>For more info, see http://www.acfug.org/mailinglists >>Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >>List hosted by http://www.fusionlink.com >>------------------------------------------------------------- >> >> >> > > > >------------------------------------------------------------- >Annual Sponsor FigLeaf Software - http://www.figleaf.com > >To unsubscribe from this list, manage your profile @ >http://www.acfug.org?fa=login.edituserform > >For more info, see http://www.acfug.org/mailinglists >Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >List hosted by http://www.fusionlink.com >------------------------------------------------------------- > > > > > >------------------------------------------------------------- >Annual Sponsor FigLeaf Software - http://www.figleaf.com > >To unsubscribe from this list, manage your profile @ >http://www.acfug.org?fa=login.edituserform > >For more info, see http://www.acfug.org/mailinglists >Archive @ http://www.mail-archive.com/discussion%40acfug.org/ >List hosted by http://www.fusionlink.com >------------------------------------------------------------- > > > ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
