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? 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). -----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 -------------------------------------------------------------
