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

SQLBase

SQLBase

(OP)
I am using SQLBase 7 database. I have a PROD database and a DEV database. The data in PROD database is till date.

1.When i try to copy(copy and paste in explorer)the .dbs file from PROD to DEV, i find that DEV database is not updated. Is there anything else i have to do after copying the .dbs file to DEV from PROD??
2. I took backup snapshot of PROD database. When i try to restore the DEV database from the the PROD SNAPSHOT, the system does not let me. However, when i do the restore from DEV SNAPSHOT, the system does it fine. My aim is to update the DEV database with PROD database.

Thanks in advance.....
Indoaryaan.

RE: SQLBase

If this is a manual process, I have found the best way is:
1. deinstall the PROD and DEV databases (if you have a maintenance time window)
2. copy the .DBS file to the \DEV folder
3. replace the DEV.DBS file with the copy
4. install both databases.

*****
If you cannot deinstall PROD:
1. find the time of least usage
2. deinstall DEV database and delete the .DBS file
3. copy the PROD.DBS and all *.LOG files into the \DEV folder
4. in \DEV, rename PROD.DBS to DEV.DBS
5. install DEV
6. connect and run a "check database".  A result of "database checked" is good.  If you get any other answer, a user was updating PROD during your copy and DEV is not corrupt.  GOTO step 1.

RE: SQLBase

Oops!  Toward the end in step 6, if a user updated PROD during the copy, then DEV is "now" corrupt!

RE: SQLBase

Databases that are still on engine are "in use" and attempting to move or overwrite could cause corruption.

If you are unable to shutdown the SQLBase engine to free up the dbs or you are unable deinstall PROD and you don't want to keep a copy of DEV...  SQLTalk commands in bold

Option 1

1.  Create a directory called c:\db

2.  Set the Server

3.  drop database DEV;  
once you issue this command, there is no going back to the DEV db

4.  BACKUP DATABASE from PROD to c:\db on server;
this will backup a stable copy of the database to that directory you created in Step 1.  Once the backup is complete, proceed to the next step

5.  RESTORE DATABASE from c:\db on server to DEV;

6.  connect to the database

7.  CHECK DATABASE;

8.  UPDATE STATISTICS ON DATABASE;
Barring a corrupted index or rowpage, you should be in business.

9. DISCONNECT ALL;
**************************

Option 2

1.  create a directory c:\db
2.  connect to PROD
3.  UNLOAD DATABASE C:\DB\PROD.SQL
depending on how big your database is, this could take a littke while.  Once this unload is complete, proceed to the next step

4.  Disconnect from PROD

5.  DROP DATABASE DEV;
6.  CREATE DATABASE DEV;
7.  CONNECT DEV;
8.  LOAD SQL C:\DB\PROD.SQL;
again, depending on how big the database it, this part could take even longer!

9.  CHECK DATABASE;
10.  UPDATE STATISTICS ON DATABASE;
After this, you should be in the business.  

11. DISCONNECT ALL;

Hope that helps!

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