Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Delphinus

611 posts

Ultimate Geek


#272861 21-Jul-2020 10:23
Send private message

We have a client who had some local MS SQL hosted, desktop based software (health records) (Vendor1) and then moved to a online terminalservices hosted version (provided by Vendor1 as well) during lockdown, and then have moved again to a proper browser based cloud application (Vendor2).

 

When moving from local to hosted version of software (Vendor1) they provided a backup of their SQL db which was then moved to the hosted server.

 

They want to get an export of their data, ie the full Microsoft SQL database from the online hosted version to restore back to their local SQL server as a backup. This would allow them to run their desktop software connecting to their own SQL server again incase they need to check any historical records.

 

Vendor1 has said they are not licensed to the structure of the SQL database, so are refusing to provide an SQL backup. Obviously the data is theirs, and they are licensed to run SQL Express, but Vendor1 is still saying they can't have it.

 

Vendor1 has provided an export via CSV, which contains 100+ CSV files (export of the tables from SQL) and 10,000+ image files. Clearly manual cross referencing is impossible.

 

Is there any validity to this claim? Can you license the structure of your SQL DB?

 

It would make sense if the hosted database was multi-tenanted, but I don't think that is the case.


View this topic in a long page with up to 500 replies per page Create new topic
 1 | 2
freitasm
BDFL - Memuneh
79309 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #2526430 21-Jul-2020 11:12
Send private message

They could claim the database structure is integral part of their IP - only the data belongs to the client... 





Please support Geekzone by subscribing, or using one of our referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSync 




networkn
Networkn
32358 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #2526431 21-Jul-2020 11:15
Send private message

In theory, yes. It would depend on the EULA or contract signed.

 

It wouldn't be a MS limitation, rather the vendor who built the schema (structure) for the database, as it would be proprietary information. Not unreasonable in my view.


freitasm
BDFL - Memuneh
79309 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #2526436 21-Jul-2020 11:17
Send private message

Again, IANAL - if you decide to go down the legal route, contact a technology-focused law firm.





Please support Geekzone by subscribing, or using one of our referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSync 




Beccara
1469 posts

Uber Geek

ID Verified

  #2526437 21-Jul-2020 11:18
Send private message

It's a thing, IIRC the DB Schema is IP and covered under copyright at the very least and terms of the license. Not sure I've ever seen/heard it proven in court tho





Most problems are the result of previous solutions...

All comment's I make are my own personal opinion and do not in any way, shape or form reflect the views of current or former employers unless specifically stated 

Behodar
10513 posts

Uber Geek

Trusted
Lifetime subscriber

  #2526450 21-Jul-2020 11:33
Send private message

Looking at this as an outsider, it seems wrong. If I'm understanding correctly, the customer supplied the company with a backup of the existing data, for use in a hosted version of the same product. It's therefore reasonable to assume that the schema would remain the same (or at least very similar). The customer is now requesting what is essentially an updated 'version' of the same thing it originally supplied, and is being told no.

 

While there is most likely something in the small print about it, I can certainly see why this has come as a surprise.


Delphinus

611 posts

Ultimate Geek


  #2526494 21-Jul-2020 12:37
Send private message

Behodar:

 

Looking at this as an outsider, it seems wrong. If I'm understanding correctly, the customer supplied the company with a backup of the existing data, for use in a hosted version of the same product. It's therefore reasonable to assume that the schema would remain the same (or at least very similar). The customer is now requesting what is essentially an updated 'version' of the same thing it originally supplied, and is being told no.

 

While there is most likely something in the small print about it, I can certainly see why this has come as a surprise.

 

 

Yes this exactly. They want to roll back to running the desktop version (which they purchased many years ago) as an archive using their most current data set.

 

They still have a copy of the database on their own SQL server, it's just 4 months out of date with missing new patient data.


Dynamic
3869 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #2526498 21-Jul-2020 12:41
Send private message

Yes they may be a bit brassed off about only hosting for a short time, but if there was no term contract then that's on them.

 

If you don't have any luck through normal means, consider pulling out the big guns:

 

- Disputes Tribunal
- Contacting one of the Board members and asking for their help to resolve the problem.





“Don't believe anything you read on the net. Except this. Well, including this, I suppose.” Douglas Adams

 

Referral links to services I use, really like, and may be rewarded if you sign up:
PocketSmith for budgeting and personal finance management.  A great Kiwi company.


 
 
 

Trade NZ and US shares and funds with Sharesies (affiliate link).
networkn
Networkn
32358 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #2526499 21-Jul-2020 12:43
Send private message

Delphinus:

 

Behodar:

 

Looking at this as an outsider, it seems wrong. If I'm understanding correctly, the customer supplied the company with a backup of the existing data, for use in a hosted version of the same product. It's therefore reasonable to assume that the schema would remain the same (or at least very similar). The customer is now requesting what is essentially an updated 'version' of the same thing it originally supplied, and is being told no.

 

While there is most likely something in the small print about it, I can certainly see why this has come as a surprise.

 

 

Yes this exactly. They want to roll back to running the desktop version (which they purchased many years ago) as an archive using their most current data set.

 

They still have a copy of the database on their own SQL server, it's just 4 months out of date with missing new patient data.

 

 

Are the versions the same? Newer versions may have schema changes meaning it's not compatible to restore without an upgrade.


tchart
2380 posts

Uber Geek

ID Verified
Trusted

  #2526502 21-Jul-2020 12:49
Send private message

My reading of this is;

 

1) Originally the solution was thick client on premise connecting to local SQL server - Vendor 1

 

2) They moved to hosted/terminal services (ie thick client via RDP or similar) connecting to SQL server (on the hosted infrastructure) - Vendor 1

 

3) They have now moved to a proper web based client from Vendor 2 - connecting to what database? Is this the same database?

 

Given its a new web client it may not be the same database as its a new vendor. If its the same database then I'd say its fair game as you previously had access to the database (& schema)

 

If vendor 2 has new IP in there to support the web client then you'll need to read the fine print.

 

Ive come across some asset management systems which lock you out of the SQL database becuase they deam this to be proprietary. Make its difficult to integrate with outher systems.

 

 


Delphinus

611 posts

Ultimate Geek


  #2526504 21-Jul-2020 12:56
Send private message

networkn:

 

Are the versions the same? Newer versions may have schema changes meaning it's not compatible to restore without an upgrade.

 

 

Would be minor step releases if anything, and client would be happy to pay for the upgrade if necessary.

 

 

 

tchart:

 

My reading of this is;

 

1) Originally the solution was thick client on premise connecting to local SQL server - Vendor 1

 

2) They moved to hosted/terminal services (ie thick client via RDP or similar) connecting to SQL server (on the hosted infrastructure) - Vendor 1

 

3) They have now moved to a proper web based client from Vendor 2 - connecting to what database? Is this the same database?

 

Given its a new web client it may not be the same database as its a new vendor. If its the same database then I'd say its fair game as you previously had access to the database (& schema)

 

If vendor 2 has new IP in there to support the web client then you'll need to read the fine print.

 

Ive come across some asset management systems which lock you out of the SQL database because they deam this to be proprietary. Make its difficult to integrate with outher systems.

 

 

Correct on 1-3, just the new web based client is using a completely new database. Definitely not the same database. Think of it like moving from Quickbooks to Xero. Different companies, different platform, different structure.

 

Data has been imported into the new web client from the CSV's provided. They just want piece of mind incase something was missed. Ie be able to access the legacy thick client hosted on premise.

 

 

 

At the end of the day, they already have the database schema that is being debated, hosted on their own server. It's just 4 months out of date.


freitasm
BDFL - Memuneh
79309 posts

Uber Geek

Administrator
ID Verified
Trusted
Geekzone
Lifetime subscriber

  #2526506 21-Jul-2020 12:57
Send private message

If there are no difference in the schema (hard to prove with hosting in different platforms and versions), I would say the provided is angling for a "migration service" fee here...





Please support Geekzone by subscribing, or using one of our referral links: Quic Broadband (free setup code: R587125ERQ6VE) | Samsung | AliExpress | Wise | Sharesies | Hatch | GoodSync 


Delphinus

611 posts

Ultimate Geek


  #2526507 21-Jul-2020 12:59
Send private message

freitasm:

 

If there are no difference in the schema (hard to prove with hosting in different platforms and versions), I would say the provided is angling for a "migration service" fee here...

 

 

Definitely this. They have been dragging their feet for weeks. Missing files in the export etc etc.


djtOtago
1153 posts

Uber Geek


  #2526510 21-Jul-2020 13:10
Send private message

Does Vendor2 cloud based service even use a MSSQL server database?
You may have given them a MSSQL backup, but they may have imported this into some other type of database that better suits their cloud based application.


Delphinus

611 posts

Ultimate Geek


  #2526512 21-Jul-2020 13:12
Send private message

djtOtago:

 

Does Vendor2 cloud based service even use a MSSQL server database?
You may have given them a MSSQL backup, but they may have imported this into some other type of database that better suits their cloud based application.

 

 

Vendor2 doesn't use MSSQL. Data was imported into Vendor2 from the CSV's provided by vendor1.

 

Only reason we want the MSSQL export is to continue running the legacy purchased software as it was being run up until March.


Lias
5589 posts

Uber Geek

ID Verified
Trusted
Lifetime subscriber

  #2526513 21-Jul-2020 13:14
Send private message

I have no idea where it stands legally, but it's certainly not unheard of, nor is it necessarily about angling for extra fees. One of my former employers had the same policy, unlike the situation here however the databases were cloud hosted and the end users didn't/couldn't access them directly. If you stopped being a customer and wanted your data exported, you got pretty much what OP describes, a whole bunch of CSV's and associated asset files. At least part of the reason for that was the way the product stored things internally was.. esoteric.. and having exported CSV's and asset files was actually much more useful to the customers. (the CSV's and files were not straight dumps, they were very much generated).





I'm a geek, a gamer, a dad, a Quic user, and an IT Professional. I have a full rack home lab, size 15 feet, an epic beard and Asperger's. I'm a bit of a Cypherpunk, who believes information wants to be free and the Net interprets censorship as damage and routes around it. If you use my Quic signup you can also use the code R570394EKGIZ8 for free setup.


 1 | 2
View this topic in a long page with up to 500 replies per page Create new topic





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.