INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Migration of database from SQLBASE TO MS SQLSERVER 2000

Migration of database from SQLBASE TO MS SQLSERVER 2000

(OP)
Hi,

I am going to migrate the database present in SQLBASE to MS SQLSERVER 2000.
Please let me know if these two databases are compatible and whether the above migration can be done.

RE: Migration of database from SQLBASE TO MS SQLSERVER 2000

Depends on your definition of compatible.  The migration can be done.  I'm in the process of converting from SQLBase to SQL Server now.

There are a number of issues you will have to address:

SQLBase has Date and Time data types natively.  SQL Server has only DateTime.  (Although you can define your own types.)

SQLBase reserved words SYSDATETIME and USER are replaced by SQL Server reserved words CURRENT_TIMESTAMP and CURRENT_USER.

SQL Server uses "+" for concatenation instead of "||"

Dates are not well parsed when expressed as constants.  Generally best to use bind variables or quoted strings and let the compiler convert to date(time).  Date constants syntax is different:  instead of 2003-05-29-13.30.00.000000 you would need to use something like "5/29/2003 13:30:00.000"

Functions need to be replaced.  E.g. IsNull() replaces @NullValue().  Not all functions have direct counterparts, but in the worst case you can create your own thru what is called extended stored procedures.

Date arithmetic is done with functions in SQL Server, not the simple add and subtract that works so well in SQLBase.

Security is a little more complicated.  There is no counterpart to declaring public synonyms in SQL Server, so unless dbo owns the table the name must be fully qualified to use it.

The optimizer is not as good as SQLBase, but there is provision for you to provide a "hint" as to what index should be used when necessary.

Anyway, that's a start.

RE: Migration of database from SQLBASE TO MS SQLSERVER 2000

Hello! I like to know what is the technique to use SQLBASE database (*.dbs) file on web for data driven websites. I am a webmaster. I have not worked with GUPTA SQLBASE yet, I know some SQL. Kindly give you expert advice since I am really confused how to go about it.

Thanx in advance,

Prince Marc Haden
India

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close