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   231 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.

,CONVERT(XML,DECOMPRESS([Data])) as DeCompressedDataValue
FROM dbo.FileRevision



United States
7900 Westpark Drive
Suite A200
Virginia, 22102
[email protected]

United Kingdom
Scott House
The Concourse
Waterloo Station
London, SE1 7LY
020 3103 0306
[email protected]

20 Harcourt Street
Suite 10
D02 H364
3531 400 7506

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