Wow, sounds fun! ; ) On Mon, Apr 21, 2008 at 6:06 PM, Peyton Todd <[EMAIL PROTECTED]> wrote:
> It's a long story, Steven, but here goes... > > The CF site I'm writing is an extension of ASP site, which was written by > a programmer who's no longer available. I tried to write the extension of > his site in ASP at first, but I was never able to establish a development > environment to work in because of the special way he wrote his site: all the > data access takes place through COM objects he wrote in Visual Basic, and I > could never get them running (nor re-create them) on any of my PCs at home - > even after consulting with the original programmer by e-mail and long > distance phone conversation, and many hours of gnashing my teeth and tearing > my hair. So I persuaded the company president (it's a small company) to let > me write the extension in CF, in which I had a couple of years experience > (though that was in the days of CF version 5). > > It was my firm impression based on what I was told about the existing site > that the DB in question (which belonged to the first programmer's start on > this additional functionality, which I was told to trash and start over) was > my own to do as I pleased with, and at one point I deleted a column I saw I > would have no use for. Later on, I learned that a particular function on a > second(!) ASP site written by the first programmer (that I had not been told > about) had stopped working, and by far the most likely cause is the absence > of the column I had deleted. It's not a huge problem so far - most of the > second site, and the evidently all of the first (far larger) site still > works, So I was assigned the task of simply adding that functionality to my > new site. > > The functionality in question is a list of court reporters and their > passwords - evidently not used in the first two sites as far as I can tell > at present, and logically part of my new site, which enables court reporters > to report back on the results of their court reporting job once they get > home. Needless to say, I put back the deleted column, but I had made no > record of its datatype and width - and chances are that's built into the COM > object in such a way that it grinds to a halt if I don't get those things > exactly as they were before. And I don't dare try to rebuild the COM object! > (There may be backups of the original table somewhere - I'm looking, but it > may not be worth it.) > > Unlike most of the rest of my app, which is a lot more complicated, this > particular task lent itself to easy solution via a CFGRID, which I wrote > over the week-end. However, in the process, I had to make some other changes > to the structure of the reporters table - one requested by the boss, and > another required to make the CFGRID work - namely the removal of a > sequential field which had been defined as its key. It may have been an > auto-increment (a.k.a. 'identity') column at one point, but it is no > longer. Even when I include it as an invisible column in the CFGRID, it does > not automatically update. So, instead of including it as a visible, > updateable column requiring the user to come up with the next number > himself, I decided to get rid of it and go with a new key (the reporter's > login ID). So now the structure of the table will be VERY different. > > No big deal? Not if it's really true that this table is independent of > everything else in the two ASP sites except for the piece that no longer > works. But I don't dare take that chance! Various of its columns are > mentioned several times in the classes from which the COM objects used by > the two ASP sites were built (both of them use objects in the same gigantic > DLL to reference their data). > > I hope the above was interesting! > > Peyton > > P.S. In general, there seems to be a problem in our two sites referencing > the same data. For example (get ready for mention of Rip Van Winkle's rusty > flintlock rifle:) both sites need to access data in FoxPro for DOS, which > turns out to be impossible if we're aiming at the same FoxPro DB. My site > does not need to be up-to-the minute, though, so we''ll be getting along > with nightly copies of the relevant FoxPro tables. Even if I were to get the > original reporters' table back exactly as it was, I'm not convinced we > wouldn't still be step on each other's toes. I can see from the other > programmer's Visual Basic code that he's opening it read-only, but that > doesn't mean he drops the connection, and I myself know of no ASP equivalent > of the CF Administrator to specify that that be done. For all I know, it > would not be necessary anyway with (multi-threaded?) SQL Server. But this > way seems safer. And more practical given the limitations on time and > resources. > > -----Original Message----- > From: Steven Ross > Sent: Apr 21, 2008 4:55 PM > To: [email protected] > Subject: Re: [ACFUG Discuss] How Clone a SQL Server Database? > > Just out of curiosity why would you want two apps hitting different copies > of the same database? don't you want the people using the asp app and the CF > app to see the same data? or is it some sort of migration away from ASP to > CF? > sorry... maybe there is some business reason... couldn't hold back from > asking... > > On Mon, Apr 21, 2008 at 4:30 PM, Peyton Todd <[EMAIL PROTECTED]> > wrote: > > > 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 > > ------------------------------------------------------------- > > > > > > > > > > > -- > Steven Ross > web application & interface developer > http://blog.stevensross.com > [mobile] 404-488-4364 [fax] (404) 592-6885 > [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] > > ------------------------------------------------------------- > 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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- > > ------------------------------------------------------------- > Annual Sponsor FigLeaf Software - http://www.figleaf.com > > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?falogin.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 > ------------------------------------------------------------- > -- Steven Ross web application & interface developer http://blog.stevensross.com [mobile] 404-488-4364 [fax] (404) 592-6885 [ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ] ------------------------------------------------------------- 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 -------------------------------------------------------------
