I've got a vertical market Dot Net Framework 1.1 C#/WinForms/SQL Server 2000 application. Currently it uses ADO.Net and Microsoft's SQLHelper for CRUD operations. I've successfully converted it to Dot Net Framework 4 C#/WinForms/ SQL Server 2008. What I'd like to do is also offer my customers the OPTION to use SQL Azure as a backen...
Is anybody using SQL Azure with Graffiti CMS. If so how do you add SQL Azure as your DB for Graffiti CMS 1.3? ...
Hi, I am using an SP which will insert data in 2 tables in 2 different DB's. To mainitain the transaction, the SP has been designed like that. Its working fine in SQL Server environment. Like Insert into AdminDB.EmpSiteConfig values(,,,) Insert into MainDB.EmpDetails values(,,,) where AdminDB and MainDB are the database names. ...
I would like to create an Sql Azure user and grant her readonly access on a handful of DBs, what script can I use to achieve this? ...
I'm using log4net appender ADO.NET to log messages of Azure Worker Role to the SQL Azure instance (default diagnostics just does not fit). For some reason, while running the worker in dev fabric, logging works. Yet, when the instance is deployed to the cloud (with exactly the same config) errors do not get logged. Configuration happens ...
Hi guys, We want to create multitenant application with shared database table structure. Currently with standard SQL Server we could achieve that with providing TenantID for each table. Could we achieve the same on Windows Azure, but without TenantIDs? Best regards, Alexey Zakharov ...
Hi, I am trying to use a Database in SQL AZURE. I have installed SQL Server 2008. I can Login SQL Azure and can use master Database. But I can't use other Database and I can't see any things in my object explorer. Its Show Error: "USE statement is not supported to switch between databases. Use a new connection to connect to a different ...
Hi there, I have a dedicated server which hosts a Windows Service which does a lot of very heavy load stuff and populates a number of SQL Server database tables. However, of all the database tables it populates and works with, I want only one to be synchronised with a remote SQL Azure DB table. This is because this table holds what I c...
I do have a BKS file which contains 15GB+ size. How do I extract the data and run queries on this? I was told that this is SQL Server data. Should I try to upload this to SQL Azure? Any ideas. ...
I'm trying to learn the Microsoft data / service stack. I want to build a database in SQL Azure and expose it to a c# client application. I've never worked with any SQL database technology. Looking online, everything just seems so confusing -- too many technologies, hard to tell what's new vs what's old. What's the latest technologi...
I am failing to connect to SQL Azure using Delphi 2010 and dbGo. What is wrong and how to resolve that ? The details: The TADOConnection with the following connection string (the login info is changed): Provider=SQLNCLI10.1;Integrated Security="";Persist Security Info=False;User ID=me@tyasdgerj5;Initial Catalog=Northwind;Data Source=t...
At the MSDN website it says, "Connecting to SQL Azure by using OLE DB is not supported." There are other places on the web where folks report that it works fine for them after tweaking the server name in the connection string, such as here and here. Even SQL Server's Analysis Services uses OLE DB to connect to SQL Azure! I develop a n...
i am trying to view the lengthiest posts on stackoverflow using: http://odata.stackexchange.com/stackoverflow/query/new i am doing: select max(body) from posts; and it returns: You'd be looking to static link (as opposed to dynamically link) I'm not sure how many of the MS redistributables statically link in. anyone know what i...
I am an iPhone developer. For one of my clients I am supposed to access their database stored in SQL Azure. I know that there is an Objective C SDK. I have downloaded it and ran the NetFilx example successfully. But of course my client's account is password protected. Also as of now the Objective C SDK seems to provide only read support...
Hello All: Can anybody help me in understanding how to upload large files in SQL azure using block. I am not able to find any good implementation of Blocks to upload files in SQL azure. Thanks, Ashwani ...
I need to know , can I connect to my Sql Azure database as we connect with our general Sql Server 8/9/10 databases, via Silverlight -WCF or ASP.Net or Winform App. My development environment is WinXP with SP3 / VS 2008 Professional. I am asking so while installing Windows Azure SDK and Toolkit i got Platform incompatibility error that i...
Hi My company is deciding for switching its existing application to azure platform (only Sql Part). So we need to upload our db from local to cloud. For migration i came across various tools like 1. cerebrata 's tools 2. SqlAzure Migration wizard 3. Microsoft Sql Data Sync 4. Conventional Script way via management studio. But all the a...
I've got a local app, consisting of a windows service providing the middle/business tier for a SQL Server database (c#, .net 4, SQL Server 2008 R2) Now I'd like to port this app to Windows Azure Cloud (both service and SQL database). Is somewhere a document stating the differences between a local WCF service and a windows Azure Service,...
Azure SQL Services looks pretty cool, and I'd like to use it as a hosted database. I set myself up with a starter web edition database, and after clicking through a million and five EULAs, I got to a console and created a database. It gave me a connection string for ODBC, and for ADO.NET. I'm using a Mac, with 10.6. What are my options?...
I'm sure there are, I'm wondering what they are and if there is any upgrade/conversion documentation relative to taking a standard SQL server database and moving it to SQL Azure. ...