timematters program and database, how to copy from one server to another
Posted on 2006-05-26
I run timematters enterprise version 7. I want to copy the tm 7 app and database to a test server to develop modifications to my system. I am pretty inexperienced with sql (I am running sql 2000). I can detach, copy and reattach the db, but dont see the data. As I start the application, however, it looks like it is loading the full database. The timematters app itself appears to just use one login to the sql server, the login is called tm7user, and then the individual users licensed in the tm 7 applicatoin log into the application. It looks to me lilke the app simply uses sqlserver to hold the data, and the app passes the data to the users. This is a law office (mostly) program, and there is not much help outside of the "official" consultants, who are not really eager to share their knowledge on a list-serve. I can't believe that it should be that hard to do, but its not intuitive either. Is there any expert's exchange guru out there who can help? Since there seems to be a lack of knowledge, I think this is worth the max 500 points.