I've posted this question on a few InterBase/Firebird newsgroups but with no
response.
About 7 years ago, I created an InterBase application for a client using
InterBase 4.x. I haven't worked with InterBase since. They now want to
convert this to SQL Server. Actually, all we want to do is to convert the
tables and the data in the tables to SQL Server 2000. The other schema
objects won't get converted. I downloaded the latest version of InterBase
from Borland (V6.x or V7.0, don't recall which). When I attempted to open
the InterBase database, I get an error saying the on-disk structure is
unsupported. Could anyone offer a suggestion on what I can do?
Thanks very much.Hi
Looks like they changed the format between these versions! If you don't have
a working system, then I guess that you may have to resort to somewhere like
ebay to get one! If you do have a working system, then you might be able to
connect from SQL Server via ODBC and use DTS to get the tables/data.
John
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:HYudnYvUxYfBgUXd4p2dnA@.buckeye-express.com...
> I've posted this question on a few InterBase/Firebird newsgroups but with
no
> response.
> About 7 years ago, I created an InterBase application for a client using
> InterBase 4.x. I haven't worked with InterBase since. They now want to
> convert this to SQL Server. Actually, all we want to do is to convert the
> tables and the data in the tables to SQL Server 2000. The other schema
> objects won't get converted. I downloaded the latest version of InterBase
> from Borland (V6.x or V7.0, don't recall which). When I attempted to open
> the InterBase database, I get an error saying the on-disk structure is
> unsupported. Could anyone offer a suggestion on what I can do?
> Thanks very much.
>|||Amos,
I have had to do exactly this for a client. It's not too hard, but it is a
bit fiddly.
The on-disk formats are different, for 4.x and 7.x, so you can't just open
the files. What you have to do is to backup the Interbase 4.x database using
the utility in the 4.x installation, then restore it using the same utility
in the 7.x installation. The backed up file contains all the metadata so 7.x
can re-create it. The utility is called something like gbak, and all the
details are in the Interbase documentation.
Once you've got the data into Interbase you need a 3rd party ODBC driver to
get the data out. I used one of the free ones, forget which. I had to
REMOVE all the triggers from the tables before I could connect with the ODBC
driver though, whch was a pain as there were a lot of them. I eventually
figured out how to automate it, but it is OK to do manually.
If you want to contact me directly take the 'nospam' out of my e-mail
address.
Regards,
Richard
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:HYudnYvUxYfBgUXd4p2dnA@.buckeye-express.com...
> I've posted this question on a few InterBase/Firebird newsgroups but with
no
> response.
> About 7 years ago, I created an InterBase application for a client using
> InterBase 4.x. I haven't worked with InterBase since. They now want to
> convert this to SQL Server. Actually, all we want to do is to convert the
> tables and the data in the tables to SQL Server 2000. The other schema
> objects won't get converted. I downloaded the latest version of InterBase
> from Borland (V6.x or V7.0, don't recall which). When I attempted to open
> the InterBase database, I get an error saying the on-disk structure is
> unsupported. Could anyone offer a suggestion on what I can do?
> Thanks very much.
>
Showing posts with label response. Show all posts
Showing posts with label response. Show all posts
Monday, March 19, 2012
Wednesday, March 7, 2012
Integrity Checks Fail
I'm not sure what my response to this error should be.
JOB RUN:'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
Plan2'' was run on 11/26/2006 at 00:00:03
DURATION:0 hours, 1 minutes, 14 seconds
STATUS: Failed
MESSAGES:The job failed. The Job was invoked by Schedule 190 (Schedule 1).
The last step to run was step 1 (Step 1).
CheckDB reported
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ATOMS'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
However CheckCatalog reports:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 231723928 (object '231723928') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
(many more)
And
Table error: Object ID 423724612 (object '423724612') does not match between
'SYSINDEXES' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Help appreciated.
Regards,
Jamie
You might want to have a look at these:
http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx
Andrew J. Kelly SQL MVP
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
> I'm not sure what my response to this error should be.
> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
> Plan2'' was run on 11/26/2006 at 00:00:03
> DURATION: 0 hours, 1 minutes, 14 seconds
> STATUS: Failed
> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule
> 1).
> The last step to run was step 1 (Step 1).
> CheckDB reported
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'ATOMS'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> However CheckCatalog reports:
> Server: Msg 2513, Level 16, State 2, Line 1
> Table error: Object ID 231723928 (object '231723928') does not match
> between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> (many more)
> And
> Table error: Object ID 423724612 (object '423724612') does not match
> between
> 'SYSINDEXES' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 1
> Help appreciated.
> --
> Regards,
> Jamie
JOB RUN:'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
Plan2'' was run on 11/26/2006 at 00:00:03
DURATION:0 hours, 1 minutes, 14 seconds
STATUS: Failed
MESSAGES:The job failed. The Job was invoked by Schedule 190 (Schedule 1).
The last step to run was step 1 (Step 1).
CheckDB reported
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ATOMS'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
However CheckCatalog reports:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 231723928 (object '231723928') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
(many more)
And
Table error: Object ID 423724612 (object '423724612') does not match between
'SYSINDEXES' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Help appreciated.
Regards,
Jamie
You might want to have a look at these:
http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx
Andrew J. Kelly SQL MVP
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
> I'm not sure what my response to this error should be.
> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
> Plan2'' was run on 11/26/2006 at 00:00:03
> DURATION: 0 hours, 1 minutes, 14 seconds
> STATUS: Failed
> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule
> 1).
> The last step to run was step 1 (Step 1).
> CheckDB reported
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'ATOMS'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> However CheckCatalog reports:
> Server: Msg 2513, Level 16, State 2, Line 1
> Table error: Object ID 231723928 (object '231723928') does not match
> between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> (many more)
> And
> Table error: Object ID 423724612 (object '423724612') does not match
> between
> 'SYSINDEXES' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 1
> Help appreciated.
> --
> Regards,
> Jamie
Integrity Checks Fail
I'm not sure what my response to this error should be.
JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
Plan2'' was run on 11/26/2006 at 00:00:03
DURATION: 0 hours, 1 minutes, 14 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule 1).
The last step to run was step 1 (Step 1).
CheckDB reported
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ATOMS'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
However CheckCatalog reports:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 231723928 (object '231723928') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
(many more)
And
Table error: Object ID 423724612 (object '423724612') does not match between
'SYSINDEXES' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Help appreciated.
--
Regards,
JamieYou might want to have a look at these:
http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx
Andrew J. Kelly SQL MVP
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
> I'm not sure what my response to this error should be.
> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
> Plan2'' was run on 11/26/2006 at 00:00:03
> DURATION: 0 hours, 1 minutes, 14 seconds
> STATUS: Failed
> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule
> 1).
> The last step to run was step 1 (Step 1).
> CheckDB reported
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'ATOMS'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> However CheckCatalog reports:
> Server: Msg 2513, Level 16, State 2, Line 1
> Table error: Object ID 231723928 (object '231723928') does not match
> between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> (many more)
> And
> Table error: Object ID 423724612 (object '423724612') does not match
> between
> 'SYSINDEXES' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 1
> Help appreciated.
> --
> Regards,
> Jamie|||And a very short summary of options and recommendations:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGNhkfkFHHA.1240@.TK2MSFTNGP03.phx.gbl...
> You might want to have a look at these:
> http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx
>
> --
> Andrew J. Kelly SQL MVP
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
>> I'm not sure what my response to this error should be.
>> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
>> Plan2'' was run on 11/26/2006 at 00:00:03
>> DURATION: 0 hours, 1 minutes, 14 seconds
>> STATUS: Failed
>> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule 1).
>> The last step to run was step 1 (Step 1).
>> CheckDB reported
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'ATOMS'.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> However CheckCatalog reports:
>> Server: Msg 2513, Level 16, State 2, Line 1
>> Table error: Object ID 231723928 (object '231723928') does not match between
>> 'SYSCOLUMNS' and 'SYSOBJECTS'.
>> (many more)
>> And
>> Table error: Object ID 423724612 (object '423724612') does not match between
>> 'SYSINDEXES' and 'SYSOBJECTS'.
>> Server: Msg 2513, Level 16, State 1, Line 1
>> Help appreciated.
>> --
>> Regards,
>> Jamie
>
JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
Plan2'' was run on 11/26/2006 at 00:00:03
DURATION: 0 hours, 1 minutes, 14 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule 1).
The last step to run was step 1 (Step 1).
CheckDB reported
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ATOMS'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
However CheckCatalog reports:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 231723928 (object '231723928') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
(many more)
And
Table error: Object ID 423724612 (object '423724612') does not match between
'SYSINDEXES' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Help appreciated.
--
Regards,
JamieYou might want to have a look at these:
http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx
Andrew J. Kelly SQL MVP
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
> I'm not sure what my response to this error should be.
> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
> Plan2'' was run on 11/26/2006 at 00:00:03
> DURATION: 0 hours, 1 minutes, 14 seconds
> STATUS: Failed
> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule
> 1).
> The last step to run was step 1 (Step 1).
> CheckDB reported
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'ATOMS'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> However CheckCatalog reports:
> Server: Msg 2513, Level 16, State 2, Line 1
> Table error: Object ID 231723928 (object '231723928') does not match
> between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> (many more)
> And
> Table error: Object ID 423724612 (object '423724612') does not match
> between
> 'SYSINDEXES' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 1
> Help appreciated.
> --
> Regards,
> Jamie|||And a very short summary of options and recommendations:
http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGNhkfkFHHA.1240@.TK2MSFTNGP03.phx.gbl...
> You might want to have a look at these:
> http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx
>
> --
> Andrew J. Kelly SQL MVP
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
>> I'm not sure what my response to this error should be.
>> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
>> Plan2'' was run on 11/26/2006 at 00:00:03
>> DURATION: 0 hours, 1 minutes, 14 seconds
>> STATUS: Failed
>> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule 1).
>> The last step to run was step 1 (Step 1).
>> CheckDB reported
>> CHECKDB found 0 allocation errors and 0 consistency errors in database
>> 'ATOMS'.
>> DBCC execution completed. If DBCC printed error messages, contact your
>> system administrator.
>> However CheckCatalog reports:
>> Server: Msg 2513, Level 16, State 2, Line 1
>> Table error: Object ID 231723928 (object '231723928') does not match between
>> 'SYSCOLUMNS' and 'SYSOBJECTS'.
>> (many more)
>> And
>> Table error: Object ID 423724612 (object '423724612') does not match between
>> 'SYSINDEXES' and 'SYSOBJECTS'.
>> Server: Msg 2513, Level 16, State 1, Line 1
>> Help appreciated.
>> --
>> Regards,
>> Jamie
>
Integrity Checks Fail
I'm not sure what my response to this error should be.
JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
Plan2'' was run on 11/26/2006 at 00:00:03
DURATION: 0 hours, 1 minutes, 14 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule 1).
The last step to run was step 1 (Step 1).
CheckDB reported
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ATOMS'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
However CheckCatalog reports:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 231723928 (object '231723928') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
(many more)
And
Table error: Object ID 423724612 (object '423724612') does not match between
'SYSINDEXES' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Help appreciated.
Regards,
JamieYou might want to have a look at these:
http://blogs.msdn.com/sqlserverstor...CC/default.aspx
Andrew J. Kelly SQL MVP
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
> I'm not sure what my response to this error should be.
> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
> Plan2'' was run on 11/26/2006 at 00:00:03
> DURATION: 0 hours, 1 minutes, 14 seconds
> STATUS: Failed
> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule
> 1).
> The last step to run was step 1 (Step 1).
> CheckDB reported
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'ATOMS'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> However CheckCatalog reports:
> Server: Msg 2513, Level 16, State 2, Line 1
> Table error: Object ID 231723928 (object '231723928') does not match
> between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> (many more)
> And
> Table error: Object ID 423724612 (object '423724612') does not match
> between
> 'SYSINDEXES' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 1
> Help appreciated.
> --
> Regards,
> Jamie|||And a very short summary of options and recommendations:
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGNhkfkFHHA.1240@.TK2MSFTNGP03.phx.gbl...
> You might want to have a look at these:
> [url]http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx[/url
]
>
> --
> Andrew J. Kelly SQL MVP
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
>
JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
Plan2'' was run on 11/26/2006 at 00:00:03
DURATION: 0 hours, 1 minutes, 14 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule 1).
The last step to run was step 1 (Step 1).
CheckDB reported
CHECKDB found 0 allocation errors and 0 consistency errors in database
'ATOMS'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
However CheckCatalog reports:
Server: Msg 2513, Level 16, State 2, Line 1
Table error: Object ID 231723928 (object '231723928') does not match between
'SYSCOLUMNS' and 'SYSOBJECTS'.
(many more)
And
Table error: Object ID 423724612 (object '423724612') does not match between
'SYSINDEXES' and 'SYSOBJECTS'.
Server: Msg 2513, Level 16, State 1, Line 1
Help appreciated.
Regards,
JamieYou might want to have a look at these:
http://blogs.msdn.com/sqlserverstor...CC/default.aspx
Andrew J. Kelly SQL MVP
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
> I'm not sure what my response to this error should be.
> JOB RUN: 'Integrity Checks Job for DB Maintenance Plan 'DB Maintenance
> Plan2'' was run on 11/26/2006 at 00:00:03
> DURATION: 0 hours, 1 minutes, 14 seconds
> STATUS: Failed
> MESSAGES: The job failed. The Job was invoked by Schedule 190 (Schedule
> 1).
> The last step to run was step 1 (Step 1).
> CheckDB reported
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'ATOMS'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> However CheckCatalog reports:
> Server: Msg 2513, Level 16, State 2, Line 1
> Table error: Object ID 231723928 (object '231723928') does not match
> between
> 'SYSCOLUMNS' and 'SYSOBJECTS'.
> (many more)
> And
> Table error: Object ID 423724612 (object '423724612') does not match
> between
> 'SYSINDEXES' and 'SYSOBJECTS'.
> Server: Msg 2513, Level 16, State 1, Line 1
> Help appreciated.
> --
> Regards,
> Jamie|||And a very short summary of options and recommendations:
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OGNhkfkFHHA.1240@.TK2MSFTNGP03.phx.gbl...
> You might want to have a look at these:
> [url]http://blogs.msdn.com/sqlserverstorageengine/archive/tags/DBCC/default.aspx[/url
]
>
> --
> Andrew J. Kelly SQL MVP
> "thejamie" <thejamie@.discussions.microsoft.com> wrote in message
> news:1162D111-8C87-40B9-99FD-91BF48290290@.microsoft.com...
>
Subscribe to:
Posts (Atom)