Is there a way to get a listing of all tables and the number of records in each table?. I want to make sure I reloaded all table records by comparing the olddb to the newdb after reload
See attached dbanalysis from olddb and the newdb. All record count matches except table _User. Do I need to export user table separate and import it ? (there is difference in blocks, size, %utilized - can I safely ignore that?
Also, can i now delete the tssr08.? in e:\solution and replace it with the newly created database.
bkuptssr.bi rename to tssr08.bi
bkuptssr.db rename to tssr08.db
bkuptssr.df rename to tssr08.df
bkuptssr.lg rename to tssr08.lg
Yes, you can safely ignore the differences in utilization etc. Those are an expected result of dumping and reloading.
Unfortunately you cannot binary dump _user. You should be able to do a dictionary dump of it though.
I wouldn’t delete the old db until I have thoroughly tested the application with the new one. And even then I would just do something like rename the directory and keep it around for a while - just in case something comes up…
Tom,
I have finished the dump and reload. Will let you know if there are any issues tomorrow once the office staff works on it
Thank You very much for your help!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.