hexagon logo
Register Sign in
  • Replies 11 replies
  • Subscribers 9 subscribers
  • Views 202 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
  • The database is stored where ever you create it. Wink

    I don't know about the import/export/cleaning question you have, but I do know hat what we are using right now, with DP+ 5.2 and SQL Server 2008 R2, our database has a max of 4g, and after nearly 4 years, I've made it to 1.5g. So, I'm not sure how worried you need to be about the limit.

    Also, are you using DataPageStats.exe which creates an XML file and DataImporter to push it to the database, or connecting directly to it? We use the former method, with a remotely located database for multiple computers to import data, and with tho9se XML files, you always have a backup to your created database backup. (And a backup backup, and daily datapage computer backup, and a backup database from when we upgraded... :squareSlight smile
Reply
  • The database is stored where ever you create it. Wink

    I don't know about the import/export/cleaning question you have, but I do know hat what we are using right now, with DP+ 5.2 and SQL Server 2008 R2, our database has a max of 4g, and after nearly 4 years, I've made it to 1.5g. So, I'm not sure how worried you need to be about the limit.

    Also, are you using DataPageStats.exe which creates an XML file and DataImporter to push it to the database, or connecting directly to it? We use the former method, with a remotely located database for multiple computers to import data, and with tho9se XML files, you always have a backup to your created database backup. (And a backup backup, and daily datapage computer backup, and a backup database from when we upgraded... :squareSlight smile
Children
  • in reply to VinniUSMC
    It took a lot of trial and error till I finally succeeded sending from pcdmis to dp+, all is working as far as data coming thru....it's connecting directly to it thru ODBC data source & SQL express. When the database is created there are only 2 files that show up in the location I set up, one with a .mdf (main database file) & one with .ldf (log database file) extensions. These files do not change size at all, even though I have many parts and transactions in datapage...this can't be where actual data is stored?
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement