Repository 7.5 vs 8

karthi_gana · Post by **karthi_gana** » Thu Mar 01, 2012 11:27 pm

The main difference between DS 7.5 & 8x is in DS 7.5x the repository was Files and in DS 8x the repository is DataBase

All,

I have read this somewhere in the internet. is it true?

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 02, 2012 4:45 am

This is not completely true. All the versions of datastage prior to 8.0 had only file based repository i.e. UNIVERSE and all the later versions including 8.0 has both Universe as well as Unified metadata repository (xmeta) which uses relational databases DB2, Oracle or Sql Server.

Haven't worked on 8.7 yet but from the documentation I don't see any change as far as the metadata repository location is concerned.

karthi_gana · Post by **karthi_gana** » Fri Mar 02, 2012 5:08 am

file based repository means ?

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 02, 2012 6:14 am

In Universe, data is stored in hashed files and hence I said file based repository.

chulett · Post by **chulett** » Fri Mar 02, 2012 7:14 am

Universe is a database as well and when you get right down to it, all databases store data in 'files' of some kind.

priyadarshikunal · Post by **priyadarshikunal** » Fri Mar 02, 2012 10:04 am

chulett wrote:Universe is a database as well and when you get right down to it, all databases store data in 'files' of some kind.

Yes Sir!! you got me on that!! I know Universe is database and thats how its marketed.

qt_ky · Post by **qt_ky** » Fri Mar 02, 2012 2:16 pm

chulett wrote:all databases store data in 'files' of some kind.

I hope the database inside my head is not stored in a file of some kind...

chulett · Post by **chulett** » Fri Mar 02, 2012 6:46 pm

Wet little squishy organic files.

qt_ky · Post by **qt_ky** » Sat Mar 03, 2012 2:03 pm

Mmmmm. Would you like fries with that?

vmcburney · Post by **vmcburney** » Sun Mar 04, 2012 9:18 pm

Version 7 and earlier could be considered two tiers - client and server. Version 8 is four tiers - client, engine, services, metadata repository (database). The product is larger and it has more functionality. If you go to the Information Server 8.7 Information Center you will see very good guides on the upgrade.