Logi Info Forum Threads    >    Posts


Migrate TeamDeveloper (VistaDB) into GIT

J. Reitter
United States

09 Oct 2019 11:49 AM
   
This thread is open for replies.
12.5   .NET app   66 views   Subscribe  


With the release of Logi Info 12.7, the "Team Developer" option in Logi Studio is no longer available. Has anyone been able to import TeamDeveloper into GIT? 

What about just extracting the Team Developer (VistaDB) data into an Excel spreadsheet? 

We have tried the following after unsuccessfully searching and trying different connectors/C# code to access the data: 

  • Download VistaDB trial. 
  • Update the VDB3 format to VDB5.
  • Script out the objects (File and FileRevision tables) using the VistaDB trial "studio". 
  • Create SQL Server objects (dbo.File and dbo.FileRevision); import the data using the VistaDB trial and the "VistaDB ADO.NET 5 provider". 

We also figured out the FileRevision "Data" field contents... apparently, the data field is a gzip compressed field (the beginning "0x1f8b08" in each data item is a gzip signature). The SQL "DECOMPRESS" function (SQL Server 2016 or greater...) uses GZIP algorithms.

SELECT TOP 10 *
,CONVERT(XML,DECOMPRESS([Data])) as DeCompressedDataValue
FROM dbo.FileRevision

Thanks! 



Corporate Headquarters

7900 Westpark Drive, A200
McLean, Virginia 22102 USA
1-888-564-4965
Email US Sales Team


© Copyright 2007-2019 Logi Analytics, Inc. All Rights Reserved           |          Contact DevNet          |          Site FAQs          |          Terms of Use          |          LogiAnalytics.com