473,326 Members | 2,104 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

move relationships from dev to production db

I have a split db that on the dev versions w/ test data in the tables i
have edited the relationships.

Is there a way to move the relationships I have created in the dev db
to the production db?

thx

chris

Dec 29 '05 #1
2 1369
don't think so. You might check MichKa's website. Trigeminal.com

Dec 29 '05 #2
fastfish wrote:
I have a split db that on the dev versions w/ test data in the tables i
have edited the relationships.

Is there a way to move the relationships I have created in the dev db
to the production db?


Yes it can be done. You'll need DAO to iterate through the existing relationships and save
them somewhere (perhaps a Collection or array). Then in the production database remove all
realtionships using the DAO Relations collection. Then add the ones in the Collection from
your test db.

Sounds easy heh? There are some issues to be aware of like deleting relations from the
back of the Relations collection to the first. You'll want to preserve the relationship
type (Cascade, enforce referential integrity, etc.) and handle the probable error where
the production database can't implement the relationship (.CreateRelation()) or the field
isn't indexed, etc.

Do lots of testing....

Good luck.

--
'---------------
'John Mishefske
'---------------
Dec 30 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Hi5 | last post by:
Hi, I have designed a databasewhich is now able to store all data from my client's Excel sheet.Now I am looking for a good way to move their data into this Db. If I want to do this myself will...
2
by: AP | last post by:
When developing, I have a production version that is being used by users, and as I develop, I periodically import the key data tables into my development version. There are about 4 tables and I...
1
by: Charles MacLean | last post by:
I need to move our production database to a brand new machine on our LAN. Both machines are running SQL2K. I'd like to place the production database in a directory on the destination machine with...
5
by: Kosmos | last post by:
Hey :) hopefully someone can help me with this...I decided to take on the task of programming an access database for my legal co-op/internship...I'm studying law and music production on the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.