| Author | Message | ||
     Driverramudu Hero Username: Driverramudu Post Number: 11570 Registered: 02-2009 Posted From: 166.170.14.15 Rating: N/A |
I did make use of DTS and T-SQL extensively To copy entire objects and data from Sybase DB To MS SQL in 2003 single handed later on tested With ASP I did crated log tables too Even in current job I am doing same but Not making use of SSIS as we r upgrading to latest version So it's cake walk to write cross DB queries  Driving is my PASSION. Ball or Bimmer does not matter. | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 21500 Registered: 01-2012 Posted From: 47.16.90.50 Rating: N/A |
correst... app code anta oka package.. db scripts anta oka package chestaru usual ga.. emo lendi. clients ki budgets etc lekapote anni envi maintain cheyyaru. and data paddakala sync cheyyadaniki dba ni pettukoru.. | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 21499 Registered: 01-2012 Posted From: 47.16.90.50 Rating: N/A |
unkel sensitive data like ssn , home address lantivi mask chestaru prod nunchi dev/uat ki vacheppudu. other than that migita anta prod ki sync lekapote ela? new release ki sambandinchinavi dev lo ye script execute chesaro uat/sit/prod lo kuda ade execute cheyyali kada (except for environment speific variables)? lets say meeroka product dev lo ivala add chesaru. prod oka three months tarvata aite appudu dev nunchi export chestappudu ivala timestamp unte wrong kada? meeku audit chese process undada? | ||
| Emc2 Legend Username: Emc2 Post Number: 36617 Registered: 03-2008 Posted From: 108.48.4.211 Rating: N/A |
than create sql script and update as batch. if table structure changes you need that script too, rest easy | ||
| Saint Legend Username: Saint Post Number: 41959 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
yes it wil be the same data..but change ina data mathrame touch cheyyali..migathadi touch cheyyakudadu! | ||
| Saint Legend Username: Saint Post Number: 41958 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
I would like to know more abt process!! process pakkaga fix ithe implementation adhe vastahdi! | ||
| Saint Legend Username: Saint Post Number: 41957 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
You are right! peda companies lo..ikakda aa problem ledu..oka person motham handle cehstharu!! | ||
| Emc2 Legend Username: Emc2 Post Number: 36616 Registered: 03-2008 Posted From: 108.48.4.211 Rating: N/A |
create db dump file, since you are saying across the data bases it is the same data and tables it is easy to run that dump file.it includes ddl and data easy | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 14906 Registered: 02-2007 Posted From: 99.59.193.29 Rating: N/A |
from what understand from below its for lookup/master data so you can use redgate data compare tool and move them to staging/hotfix/prod sites but dev data is good for promotion aa annadi naa question...if so just use that tool and move if not developer/TL's should provide respective scripts with data that needs to be moved... http://gallery.greatandhra.com/upload/8563/images/_211398452008.jpg | ||
| Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 28716 Registered: 02-2009 Rating: N/A |
Anna Think about it If your metadata copy misfires or goes before app to qa app will break They have to bundled as one rel App code Db scripts | ||
| Saint Legend Username: Saint Post Number: 41955 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
I can run the scripts from unix DB server! adhe sql developer ithe, triggers, stored procedures, packages etc ki use chestha!! | ||
| Saint Legend Username: Saint Post Number: 41954 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
yes..for HTML! its developer duty to let the CM team know what files are modified! I am not sure how they do it! but prog languages ki we use svn! | ||
| Rajin Side Hero Username: Rajin Post Number: 5997 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
for Oracle , SQL developer( default ) dintlo scripting chance vuntaadi for sure ( guessing based on SQL SERVER) and TOAD ... | ||
| Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 28715 Registered: 02-2009 Rating: N/A |
Saint All I can say that it is not a good practice Does someone other than Dev parse and compare html files between diff env and promote deploy as needed | ||
| Saint Legend Username: Saint Post Number: 41953 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
BTW, ikakda kotha tools kone luxury ledu! pure SQLs/shell or perl scripts tho achieve cheyyali!! | ||
| Vjawarrior Hero Username: Vjawarrior Post Number: 10890 Registered: 02-2014 Posted From: 153.2.247.32 Rating: N/A |
configurations are transportable...not master data...so we transport all the configs, set up number ranbges for for master data in each environment and load master data in each envi | ||
| Rajin Side Hero Username: Rajin Post Number: 5996 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
ante apps develop chesthu koththa fields emunna as sync in column/fields in database ? right example photo ki photo date, photo name next dev photo summary add ayithe diverect gaa push avvali... | ||
| Saint Legend Username: Saint Post Number: 41952 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
ee data veru! suppose neeku BOA website vundi anukoo! nuvvu login kagane neeku bank account/creditcard/stocks /etc links ela choopisthundi neeku evi vutne avi? ee feature dev ina prod ina same kadaaa? adhe budugu ane kurrodi personal data like bank balance/address/transactions etc, test env lo vundochu..prod lo vundaka povachu... | ||
| Botsa_fan Side Hero Username: Botsa_fan Post Number: 5696 Registered: 07-2013 Posted From: 158.48.6.139 Rating: N/A |
data pump/AQ use cheyydi to track the changes. Sharabha Sharabha..0/18 rest Prathipadu bi-ections and agadu hype. | ||
| Saint Legend Username: Saint Post Number: 41951 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
then how do u configure ur application in upper envs? how does it work, if its not transportable? | ||
| Saint Legend Username: Saint Post Number: 41950 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
Its a change management task to promote to upper envs! they dont create scripts..they manually update / insert data...we need to triggers/packages tthat shud automatically track this info!! BTW, maa kaada front end HTML ..recent ga JAVA ki koddi koddiga move avuthunnam!! | ||
| Vjawarrior Hero Username: Vjawarrior Post Number: 10889 Registered: 02-2014 Posted From: 153.2.247.32 Rating: N/A |
saint....we load in each environment..Master .data isnt transportable | ||
| Saint Legend Username: Saint Post Number: 41949 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
i.e. customer data or test data..not applicaiton meta data!! | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 21498 Registered: 01-2012 Posted From: 47.16.90.50 Rating: N/A |
Ok.. Nenu work chesina projects different.. always dev will be refreshed with prod data before start of every release.. uat start ki mundu it will be refreshed with prod data.. this way you will not find new issues when you do proud release | ||
| Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 28714 Registered: 02-2009 Rating: N/A |
Buddu Meta data to make apps work in Dev will be in sync else Code breaks Actual app data need not be | ||
| Saint Legend Username: Saint Post Number: 41948 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
no!! lets say, u have 5 dev cycles! 1st cycle is in prod 2nd UAT 3rd test 4th SIT 5th dev 5th lo vunna features 4th lo vundavu..4th lo vunna features 3rd lo vundavu and same is true up to 1st! so nuvvu 1st di techi UAT lo laod chesthe, u r losing feature 2 data | ||
| Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 28713 Registered: 02-2009 Rating: N/A |
If they don't give provide meta Data scripts their apps don't work Dba responsible for apps ? | ||
| Saint Legend Username: Saint Post Number: 41947 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
u must be kidding!!! development happens in dev not in prod!! it will never be in sync with prod, if u r doing continuous dev! u keep on changing/adding columns/tables in dev... | ||
| Rajin Side Hero Username: Rajin Post Number: 5993 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
edi ruled out, trigger data upload avuthadani kuda naaku teliyadu these are enforce data integrity anduke use chesaa.. Oracle ayithe TOAD best mightavi tools emunnayooo experts cheppali... | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 21497 Registered: 01-2012 Posted From: 47.16.90.50 Rating: N/A |
of course.. but uat ki promote chese mundu clean prod data meeda kada chesedi? | ||
| Saint Legend Username: Saint Post Number: 41946 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
thats ryt! you just dont dump entire DB and promote!! u shud promote whats needed!! | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 21496 Registered: 01-2012 Posted From: 47.16.90.50 Rating: N/A |
adenti anta maata anesaru? then how are you going to ensure the sanity of the data in prod if your dev/uat is not in sync with prod? | ||
| Saint Legend Username: Saint Post Number: 41945 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
its done manually in dev by diff developers while developing their app!! | ||
| Guru Side Hero Username: Guru Post Number: 8068 Registered: 05-2009 Posted From: 192.193.216.148 Rating: N/A |
dev, sit, uat, produu..daavudaa | ||
| Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 28712 Registered: 02-2009 Rating: N/A |
You send metadata insert scripts in most cases Full table dump from Dev nen sudaledhu unless meta data is fresh and huge Dev Data integrity accuracy is a joke we all live with | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 21495 Registered: 01-2012 Posted From: 47.16.90.50 Rating: N/A |
how does it matter? dev lo ye scripts execute chesaro prod lonu ade execute chestaru. why should prod be any different from your dev or uat environment? | ||
| Saint Legend Username: Saint Post Number: 41943 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
Oracle DB... initially planning to write triggers for each table to insert a row in audit table with modified data & columns and with all other details. next write a sql loader job to dump data into flat files. next env lo flat files lo data parse chesi, already data vunte move to archive and insert audit record and tehn insert actual data!! ila vundhi plannnig..inka best mechanisms emanna vunnayemo ani! | ||
| Acf Side Hero Username: Acf Post Number: 2922 Registered: 01-2008 Posted From: 38.109.75.245 Rating: N/A |
if the database is SQL Server, use SSIS jobs | ||
| Saint Legend Username: Saint Post Number: 41942 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
direct dev kaadu..madhyalo multiple stages vuntayi! but data is same! its metadata for different products & new implementations! | ||
| Saint Legend Username: Saint Post Number: 41941 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
pardhoo product vunte, product kotha features add chesthe metadata dev nunvhi promote cheyyaka ela chstharu? | ||
| Rajin Side Hero Username: Rajin Post Number: 5991 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
annai entha ee BI , SQLServer, Oracle ,SAP?... SQL Server ayithe SSIS upload packages rastharu it will take everything adi schedule kuda cheyyochhcu.... jamana kritam ayithe DTS ane oka kalkand vundedi SQLserver 6 or 7 version appudu appudu package ee kaani mightavi explict cheyyalsi vachhedi... | ||
| Humpty_dumpty Moderator Username: Humpty_dumpty Post Number: 28711 Registered: 02-2009 Rating: N/A |
Curious | ||
| Saint Legend Username: Saint Post Number: 41940 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
eee company lo ina customer data marochu env-env, product metadata maradu kada? | ||
| Emc2 Legend Username: Emc2 Post Number: 36615 Registered: 03-2008 Posted From: 128.229.4.22 Rating: N/A |
nee enkamma nee requirement enti cheppu, dev data prod loki direct ga ela ekkisthavu, unless theya re same if they are same just take data dump and install it in prod, if not take updated data and using scripts update it | ||
| Buduguuu Megastar Username: Buduguuu Post Number: 21494 Registered: 01-2012 Posted From: 47.16.90.50 Rating: N/A |
requirement ni batti dev lo script dev chesukuni unit testing compltee chesukuni uat lo official testing ki promote chestaru. idem variety dev nunchi prod ki export? prod lo execute chesindi uat/dev lo malli techukuntam kada? | ||
| Abcdefghij Hero Username: Abcdefghij Post Number: 14905 Registered: 02-2007 Posted From: 99.59.193.29 Rating: N/A |
redgate lanti tool leda? when you say data lookup data right not test data....correct? http://gallery.greatandhra.com/upload/8563/images/_211398452008.jpg | ||
| Saint Legend Username: Saint Post Number: 41939 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
idi one time task kaadu..continuous process kadaa? developers multiple times updates/deletes/inserts chestha vuntaru on multiple table...on a given day, CM team shud promote all this stuff to next env!! one thing is sure..we need to maintain audit table to keep track of whats changed! | ||
| Saint Legend Username: Saint Post Number: 41938 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
Uhaul or budget? | ||
| Saint Legend Username: Saint Post Number: 41937 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
yes baaga!! maa DBA gaadu gaggolu peduthunnadu!! i am egspert naaku ivvakunda ivvakunda neeku itcharu ani!! nenu ade anna...aak paak telvadi..mari mgr confidence emitoo ani! | ||
| Saint Legend Username: Saint Post Number: 41936 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
guys also I want to automate the whole process!! lets say 100 tables vunnayi anukundam mana DB lo!! prathi table dump teesukuni next env ki promote chesthara? or audit ni batti, only changed data teesukuni dump chesthara? anyways next env lo no updates ani decide ayyam...insert & delete (modify ayyunte) | ||
| Maverick Legend Username: Maverick Post Number: 54505 Registered: 01-2008 Posted From: 108.171.130.188 Rating: N/A |
dev lo table ni truck lo ekkinchi prod lo pedatam Happy Vizag | ||
| Santhi_swaroop Junior Artist Username: Santhi_swaroop Post Number: 104 Registered: 10-2014 Posted From: 198.203.181.181 Rating: N/A |
Ninnu mee office loo Dhookudu loo Siva Reddy ni vadinattu vaduthunnaru anukuntaa  ee Santhi_Swaroop flash back loo Paga_Babai_Paga | ||
| Emc2 Legend Username: Emc2 Post Number: 36614 Registered: 03-2008 Posted From: 128.229.4.22 Rating: N/A |
create sql scripts along with data, give to to test/pro guys all they need to do is just run those scripts thats it | ||
| Kaisersooze Moderator Username: Kaisersooze Post Number: 11762 Registered: 04-2009 Rating: N/A |
export to flatfile and dump it using..sqlloade(assuming oracle db) | ||
| Saint Legend Username: Saint Post Number: 41932 Registered: 01-2011 Posted From: 12.22.163.132 Rating: N/A |
ela chestharu mee companies lo? suppose dev lo data insert/update chesam...and we need to promote it to test and prod...how do u do it? database links vunte, u can do exists and find out if the row is already existing and tehn update/insert.... if u dont have database links, how do u achieve this? |
