Xojo Developers, 
on Valentina site exists about year online forum. You are always welcome to discuss any technical questions about Valentina DB, Valentina Reports, Valentina Server, Valentina Studio and even not Valentina DBs, because we working with them via Reports and Studio.
Valentina Reports can produce reports directly from MS SQL.
App with Valentina Report engine can work itself on mac or linux.
If you really think about COPY data from MSSQL into Valentina DB …
then one of simplest ways - SQL dump(s)
Of course depends on how many MS-specific features/types present in that tables.
[quote=249161:@Russ Lunn]By the way, i was trying to create a query using your tool and it has an issue.
when you have two tables linked and try to filter on a field that is in both tables (with the same name) you get an error about MSSQL not knowing which field you mean. its not possible to add the table before it either it seems.[/quote]
Hi Russ,
I think this description is not enough. For example not clear do you talk about Data Editor or SQL Editor?
=========== Mantis Info =====================
It is better to report such issue(s) into Mantis - our bug tracker.
http://valentina-db.com/bt/
Why it is better? Described in these FAQs:
http://www.valentina-db.com/docs/dokuwiki/v5/doku.php?id=valentina:faqs:vbugs
Each separate issue report into separate issue report.
If you have database or project then attach it compressed to the report.
you can put up to 250Kb archives.
Provide in the report as many detailed info as you can: OS, version, locale, .
If possible, please provide exact steps how to reproduce problem.
=========================================
@Ruslan Zasukhin
I will Report it on your bug tracker. I seem to have hijacked this thread.
What is missing most is a description by usage scenario. Do you need a database for yourself and your business, or do you need to distribute an app that includes a database? Multi-user?
For example I need to make an app that comes in both single-user and multi-user versions with an easy upgrade path. So it needs to include a server. Price would be about $99. Users would not buy a separate database.
Looking at the pdf I still can’t figure out if Valentina Server OEM (“deploy any number of copies”) or the
ADK (“Application Developer Kit”) is the right one for this scenario.
[quote=249221:@Markus Winter]For example I need to make an app that comes in both single-user and multi-user versions with an easy upgrade path. So it needs to include a server. Price would be about $99. Users would not buy a separate database.
Looking at the pdf I still can’t figure out if Valentina Server OEM (“deploy any number of copies”) or the
ADK (“Application Developer Kit”) is the right one for this scenario.[/quote]
Hi Markus,
It seems this is question-by-example to me, right?
Okay let’s think together, watching into PDF.
* You say: app must be BOTH single user and multi-user.
This is ENOUGH to say:
you should have VServer OEM = VDN. 599$
from PDF: Deploy to 3 OS using single license file.
You will install Valentina DB ADK, and will use VCLIENT, which is always free.
This is logical, you need some Xojo plugin to be able write code which talks to VServer.
you can note that having VServer license, you can use ANY Valentina ADK around that server for free. So you can develop something in Xojo, and something in .NET and PHP.
* You say: app must be able to work in single user mode also, i.e. without any Valentina Server.
i.e. App must contain Valentina DB engine.
in PDF we read about Valentina DB ADK (VKERNEL.dll)
about Valentina.Init( macSN, winSN, linSN ) method
and prices 199$ for single OS, 399$ for 3 OS
So for your scenario, when APP must be able to work in both modes, you should have
a) license file for VServer OEM
b) 1-2-3 serials for Valentina.Init() for local engine.
You should purchase VDN ($599) and Valentina DB ADK ($199-399)
Let me underline, this is scenario, when you prefer to use Valentina Database engine.
If somebody prefer to use SQLite db engine to develop such app he will need only VDN price,
because SQLite local is inside of Xojo itself.
I come from the the Filemaker world, started with some Xojo, wanted to do db’s. And got scared of all the bound inner/outer stuff…
the coolest thing with Valentina, is that you can write shorter sql calls… I’m lazy, and I love this feature… it is so much easier to write SQL selects in valentina. and you have the direct API as well… no problem having a front-end that writes changes to db when losing focus on text controls… Just dead simple.
I have made both desktop and web apps with it.
I do buy the omega bundle each year, this way I get it almost for free
It took forever to get the PostgreSQL server up and running on a VPS I have at my webhosting company. I installed Ubuntu (LAMP). But instead of installing MySQL I installed PostgreSQL. At first I had to get used to it. I actually hated it.
But now I am getting more and more familiar with this db. And I must say, I am very impressed. What I like is the fact that I can write functions that can return recordsets, and God knows what else. In MySQL that was not possible.
Writing triggers is still kind of tough. But I’m getting there.
I must say that PostgreSQL is becoming the DB of my choice.