I succeeded in creating a SQL Server 2012 instance on Azure and uploaded two "living"databases that currently run in lan under SQL Server 2012 Express I can connect from VFP to the AZURE SQL Server, read records from a table and add new records to it
However, this does not work:
select c.account,c.company,s.salesman,s.commission from database_1.dbo.customers c join database_2.dbo.salesmen s on c.salesrep = s.code
I get the following error message:
Mens. 40515, Nivel 15, Estado 1, Línea 16 Reference to database and/or server name in 'database_1.dbo.customers' is not supported in this version of SQL Server.
Apparently, the AZURE SQL Server cannot retrieve data from two different databases in the same select statement.
Both databases reside in the same instance of SQL Server. Database_2 contains "confidential" data, such as managers's salaries, salesmen's commissions and the like
Is this so, or I am making some stupid mistake? How can I solve it?
Pamechu Umgobwe