August 27, 2009 at 4:42 am
Guy,
I am working in database developement enviornment.
In one of our project as our devlopment going on we are mainting the lookup tables/master tables list & values in excel sheet as per the release we deploy those values into the database. We frequently change this master list as as business requirement.
Currently we are maintaining it in excel & generate the script using the same & while deploying it into the database we do the manual job :angry: (which i dn't like).
Either I can use the SSIS / Import Exoprt but the issue it its frequently changes.Please suggest me how can I maintain the this list & can deploy it into the database into different enviornments.
Abhijit - http://abhijitmore.wordpress.com
August 27, 2009 at 8:40 am
Why not store the data in a table and change it there? Access can do this easily as a front end for business people. Then you can more easily manipulate the data in T-SQL and move changes to your databases.
Alternatively, set up an SSIS package to import the data to a staging table on a schedule. Then have jobs that look for changes to the data.
August 28, 2009 at 12:12 am
You can also think about the third party database designing / data-modeling tool which will make your task easy.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply