Questions tagged [sqldb]
39 questions
13
votes
3 answers
How to check/view data in SQL DB in Microsoft Azure
I have a web app in azure which let user to input some data. I want to save them in sql db which I created in azure. Is there a way to check/view the entered data . I am referring to something like "mysql workbench for mysql"
Madhavi
- 157
- 1
- 1
- 8
2
votes
1 answer
How to migrate off SQLDB service on IBM Bluemix?
IBM is pulling the SQLDB service on Bluemix. Does anybody know how I can move my stored data, what are my options in terms of service?
Dan Pohlman
- 25
- 3
2
votes
2 answers
How can I change the Bluemix documentation?
I found that the Bluemix documentation is wrong in an example of the SQLDB service and I ran into an issue. I was able to fix it myself. How can I change the Bluemix documentation? How do I submit feedback and get the docs fixed?
data_henrik
- 16,724
- 2
- 28
- 49
1
vote
1 answer
what is the easiest way to build forms to import to db
I need to convert an excel sheet that is shared between couple of users and they do insert/update on it to a more DB/web-based application. What would be the easiest route to do that?
Lisa
- 3,121
- 15
- 53
- 85
1
vote
1 answer
Move Azure SQLDB using SQL Data Sync to new resource group
The Googles are failing for my specific concern. Has anyone moved a database (DBaaS) and the associated parent resource which is part of a SQL Data Sync Group to a new resource group within Azure? I've found that moving the database is supposed to…
IsThisThingOn
- 21
- 7
1
vote
0 answers
Async db call - slower than sync
The program is written in C#. It gets data one by one sequentially from event hub and makes an entry to sql db.
To improve is performance, I made the sql insert async.
In my local machine 8 GB ram and 4 core, Async version of code performs faster…
venkatesh k
- 49
- 1
- 9
1
vote
2 answers
C# cannot remove object from DbContext
Hi everyone I am trying to update my local sqldb without success.
I created a DbContext:
public class DbContextWeather1 : DbContext
{
public DbSet Weathers { get; set; }
}
Where WeatherRoot is:
public class Coord
{
…
Elizabeth
- 282
- 1
- 6
- 16
1
vote
1 answer
How to debug an issue in a proprietary SQL database
Our application from a vendor is using SQL Server 2008 R2 as its database on the backend. Although rarely, but sometimes an issue comes up that we think is related to their database (for example a performance issue etc.). We cannot modify their…
nam
- 21,967
- 37
- 158
- 332
1
vote
0 answers
Columns missing when viewing db table in the field explorer
I am connecting a SQL database to a crystal report. There is a specific column from a table that I need to pull data from. When I go to the field explorer, the column does not appear. I checked to make sure it didn't have any funky properties and…
Jen S
- 11
- 1
1
vote
1 answer
ASP.NET MVC5 add 2 Sync Times to the Application
I Added the 2 Sync Times to my DB as 2 new columns and inserted values as below:
USE [DB]
ALTER TABLE [dbo].[TableName]
ADD ColumnName2 time, ColumnName3 time
This was for adding the columns.
For inserting the row values I did:
USE DB
INSERT…
Zamen
- 11
- 4
1
vote
1 answer
Azure Resource Manager SQL db templates
I am trying to create an ARM templates for Azure SQL DB deployment. I started by exporting template for an existing Azure sql database which was created and configured from portal. However I see quite a few fields which look a bit unfamiliar to me…
shaswata pal
- 389
- 3
- 15
1
vote
1 answer
Bluemix SQL Database service and triggers
I'm not able to create triggers on the SQL Database Service on Bluemix. I always get the error message "queryExecFailure - Unupported SQL statement or command." Which is clear enough.
Does someone got the same feedback ? Any option to activate…
renaudb
- 11
- 1
1
vote
1 answer
SQLDB Java Sample code doesn't work
Hi I'm new in Bluemix and I just tried some of sample code of SQLDB in Bluemix.
I tried example from this site.
I follow the step from readme.md file. But after I deployed my application, error happens.
Executing: CREATE SCHEMA SQLDBSAMPLE
Error…
Kim
- 1,081
- 2
- 12
- 17
1
vote
2 answers
I need to restore SQL Server 2000 backup to SQL Server 2012
I have SQL Server 2000 database backups with me. And I need to restore them to SQL Server 2012.
Can you tell me the best approach to do it?
Champ
- 690
- 1
- 7
- 13
1
vote
2 answers
Bluemix Liberty SQLDB
I have created an "enterprise template" Liberty server with an EAR file application requiring a few SQLDB connections. This is working and I am able to cf push this server to the Bluemix environment.
My question is how do I go about packaging the…
O Wong
- 31
- 3