(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Copying a database
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Copying a database (Read 1018 times)
wildwood
Full Member
***
Offline


No personal text

Posts: 156
Location: New York
Joined: Apr 2nd, 2004
Copying a database
Apr 29th, 2005 at 3:43pm
Print Post Print Post  
I have a database, "Camper Sports Billing", in one of my applications. It has some extensive programming. I would like to create a new database, "Camper Medical Billing", within the same application but basically an exact copy of the "Camper Sports Billing" database. I would then tweak the "copy" to fit my needs. How do I copy a database within the same application?

Peter
  
Back to top
 
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Copying a database
Reply #1 - Apr 29th, 2005 at 4:25pm
Print Post Print Post  
I have not done this and never have to do this, but the following should logically work. Make backup of your application. Give whatever name you want to give. In the backup application, change the name of database and form or forms so no database or form has the same name as in the original application. Merge these two applications.

PS: Before you attempt anything, make certain you have good backup copy of your original application.  Please let us know if this works.

Bharat
  
Back to top
 
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: Copying a database
Reply #2 - Apr 29th, 2005 at 6:21pm
Print Post Print Post  
Bharat_Naik is correct in his suggestion.  I would just add a few more notes about the process.

In the copy of the application remove all databases, forms, reports that you do no want copied.  Or else, when you merge, you will get duplicates of everything.  Rename the database, forms, etc. in the copied application before you do the Merge. 

Do the Merge by opening the original, and then merging the copy into that one.  And Merge does not happen in the  Designer, it is done in the Database Manager.
  


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