473,830 Members | 2,045 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

"Data Dictionary" for database updates

What is the best way to handle updates in databases with each release
of a software package? I used to work on an accounting package in
FoxPro that had a "Data Dictionary" and as your code required changes
to the database per release, you'd update the Data Dictionary.

When you wanted to create a new database, it would create it
completely from the data dictionary. If you already had a functional
database and the new release required adjustments to fields, indexes,
tables, etc...the Data Dictionary would make the updates.

It took a lot of code to carry out the data dictionary. I'm wondering
if there are programming resources out ther (articles, software
samples or components) that carry out something like this function.

Thanks.

-Joe

Mar 4 '07 #1
2 2115

I should also add that I am looking at using either Microsoft SQL
Server 2005 Express or Firebird SQL. Not sure yet.

-Joe
Mar 4 '07 #2

<jo*********@gm ail.comwrote in message
news:11******** **************@ p10g2000cwp.goo glegroups.com.. .
What is the best way to handle updates in databases with each release
of a software package? I used to work on an accounting package in
FoxPro that had a "Data Dictionary" and as your code required changes
to the database per release, you'd update the Data Dictionary.

When you wanted to create a new database, it would create it
completely from the data dictionary. If you already had a functional
database and the new release required adjustments to fields, indexes,
tables, etc...the Data Dictionary would make the updates.

It took a lot of code to carry out the data dictionary. I'm wondering
if there are programming resources out ther (articles, software
samples or components) that carry out something like this function.

Thanks.

-Joe
Generally speaking, you can write a program to update the structure of a
SQLServer database. I would think the same would apply for keys and
indeces, although I haven't done that.

Robin S.
Mar 4 '07 #3

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

Similar topics

3
4702
by: 21novembre | last post by:
Hi all, I made a question several days before to describe my strange trouble of mysqldump. But I still can't figour it out. Well, I just want to ask another question whether I could just backup my databases by copying the data folder to some place? Then if I meet some disaster, could I just copy the backup folder back to recover my databases? Thank you. Zh.y
2
7869
by: microsoft | last post by:
When I create a instance of web services proxy in winform, I get the exception. Stack Trace: System.ArgumentException: Item has already been added. Key in dictionary:"winbootdir" Key being added: "winbootdir" at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value)
3
2867
by: Phil Sherman | last post by:
What is the relationship between the snapshot elements: Log pages written Number write log IOs Number partial page log IOs There doesn't appear to be any information in my PDF System monitor guide or the online information center. When a COMMIT is issued; a log page containing updates must be written to disk before control is returned to the application program. This
2
2881
by: Kenneth D Buelow | last post by:
Is there a way to generate a listing of some/all of the "field descriptors" for an ACCESS table? I am a SAS user and am looking for something like SAS's proc CONTENTS which generates a basic "data dictionary" on a SAS dataset. Is there something like this 'built into' MS-ACCESS? Thanks. Ken Buelow
0
2283
by: Tom Wild | last post by:
Hi I am trying to connect to an Access database from a WebPage in VB.Net but when I try to open the connection I get the following error: The Microsoft Jet database engine cannot open the file 'C:\Test03\Test03.mdb'. It is already opened exclusively by another user, or you need permission to view its data My connection string is as follows:
0
4217
by: Ralf Gedrat | last post by:
Hello! I have a Application, this throws after some time following exception: Item has already been added. Key in dictionary: "- 1" key being added: "- 1" I use Application.Run with ApplicationContext. This error message comes from deeper levels must be thrown (mscorlib.dll?!) ?.
1
3139
by: nobrainer | last post by:
Hi, I'm a linguist and have a large self-built bilingual dictionary. I want to turn it into a electronic dictionary, can anyone tell me how to start with it? I've some knowledge in Java programming, but don't know how to write a programme that allows you to search in the large e-file just like a GUI interface e-dictionary. any directions?
3
4129
by: BobRoyAce | last post by:
I am using Visual Studio 2008 w/ VB.NET. For the database, I am using SQL Server 2005, which is running on a dedicated server box. I am creating a WinForms application for a client. It is run on any of several employees' desktop PCs. Now, they want to be able to "push" some of the data from the SQL Server database up to a database on a website (also SQL Server 2005).
2
1452
by: slais-www | last post by:
Before I set out to reinvent the wheel. I want a dictionary-like structure for which most lookups will be on a key that is not in the "dictionary"; in which case I want a key/value returned which is the closest key that is less than the search term. The batch solution of matching the values in two sorted sequences is efficient but a random lookup would be more convenient. A solution based on AVL trees seems possible.
0
9793
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9642
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10774
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10206
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7746
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6951
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4411
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3959
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3076
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.