(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › How to copy a database?
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic How to copy a database? (Read 1452 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
How to copy a database?
Nov 12th, 2004 at 12:28am
Print Post Print Post  
Is there an easy way to make a copy of a database and forms?

I see the option to copy a 'layout' or 'form', but it keeps the form in the existing database. I want the copy to be a NEW database with identical forms?

The only solution I can think of is this:

Copy all the forms within their existing database using "copy layout".

save as "temporary" application.

Re-design temporary application and delete unwanted forms and rename database.

reconcile to temporary application

open original app and 'trim database' from temp app.

Whew. I'll give it a try in the morning unless someone has a better suggestion.


Thanks,
Steve
  
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: How to copy a database?
Reply #1 - Nov 12th, 2004 at 12:58am
Print Post Print Post  
If you are talking about another copy of a database within the same application, Merge may be the answer for you.  Try this:

The following steps are listed from memory.  May want to double check the steps before proceeding.  At least make a  backup copy of the original (old) application.

1.  Go the folder where the application files are located.

2.  Use Windows Explore to copy the Application.db and Application.dat files to new names.

3.  Open the new application in Designer.
4.  Delete all the stuff you DO NOT WANT.
5.  Rename the name of the desired databases/forms to be different from original name.
6.  Close the new application.

7.  Open the old application in Database Manager.
8.  Merge the new application into the old application.
9.  Close old application.

10.  Open old application in Designer.
11.  Rename merged database/forms as desired.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: How to copy a database?
Reply #2 - Nov 12th, 2004 at 5:33am
Print Post Print Post  
It worked! Smiley

Your technique was cleaner and quicker than mine, but either method will get the job done.

Thanks for your help!

Steve
  
Back to top
WWW WWW  
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: How to copy a database?
Reply #3 - Nov 12th, 2004 at 10:15pm
Print Post Print Post  
Reminder that if you have programming statements that reference the form name, you will have to replace old form names with new form names. 

This will be common in most @XLU types of functions.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge