How to check SQLite exporting model errors?

Asked By evelyndnell 10 points N/A Posted on - 02/27/2013

I am automating the export process. But I see cases where the export is successful, but not complete.

I have seen sqlite exporting model error message to check the log file.  

Can we check for the errors after exporting model?

Thanks in advance for your response.

• Status: Open
• Question Views: 721
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Nathan H Underwood 60 points N/A #140401

How to check SQLite exporting model errors?

Hello Evelyndell,

I read about your problem, and think can help you.

Please fill the steps:

1. Start an MS-DOS Command 

2. Open your main data directory, and start SQLite:

 

sqlite3 dspiceworks_prod.db

 

3. Check the integrity of database: 

 

pragma integrity_check;

 

If it's everything OK, your database is good.

 

4. To exit SQlite: .quit; If you have error you can go to Next Step

 

Regards!

 

Nathan H Underwood

About Nathan H Underwood

Questions
18

Answers
33

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 03/22/2013
• Question Category: Misc Databases