hexagon logo
Register Sign in
  • Replies 11 replies
  • Subscribers 9 subscribers
  • Views 201 views
  • Users 0 members are here
Options
Related

database management

sdaley
Hello,

Finally going all in with DP+ 5.0 after years with DPRT (had no choice). A couple of questions....in DPRT I would ASCII dump and then clear database to clean, had a directory of one transaction for each part number that I would ASCII load back in for variable text etc. I could also ASCII load any of my previously dumped data by part number if someone needed to see some history. It doesn't appear that DP+ will allow me to import one part at a time after I've exported and cleaned (deleted) all. Do I have to export one part at a time in order to maintain history I could reload if needed without importing all parts?

Another question is where is the database data actually stored? The size of the .mdf & .ldf files never change? I initially setup 3 machines to save data to network thinking I could retrieve and compile data from one machine, except there is nothing to import from these .mdf & .ldf files. Would also like to keep an eye on when I'm getting close to the 2 gig limit.

Thanks for any ideas
Parents
  • RT and + are not the same animal and should not be treated the same. With RT each part has it's on database and with + you only have one database and all parts are stored in that database.
    Unless data is corrupt, you should not be deleting any data from the Datapage+ database.

    The database location is going to be where ever it was created and if you don't know then you need to have someone who has experience with MSSQL investigate it.

    ummmm, no, there is NOT a database for each part in RT, they are all in ONE file, ONE database. You can, however, make as many databases as you want.
Reply
  • RT and + are not the same animal and should not be treated the same. With RT each part has it's on database and with + you only have one database and all parts are stored in that database.
    Unless data is corrupt, you should not be deleting any data from the Datapage+ database.

    The database location is going to be where ever it was created and if you don't know then you need to have someone who has experience with MSSQL investigate it.

    ummmm, no, there is NOT a database for each part in RT, they are all in ONE file, ONE database. You can, however, make as many databases as you want.
Children
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement