Visual Studio Database Development Tools (Formerly "Database Edition Forum") announcement
-
Link
Microsoft SQL Server Data Tools ...
...provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries.
Get it
Beginner's Guide
Learn more
ForumDevelopers will also appreciate the familiar VS tools we bring to database development, specifically; code navigation, IntelliSense, language support that parallels what is available for C# and VB, platform-specific validation, debugging and declarative editing in the TSQL Editor, as well as a visual Table Designer for both database projects and online database instances.
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0Votes
Database project execute migration script
Hi... I have to execute .sql file before preparing publish script comparing with Database project and existing ...0 Replies | 10 Views | Kaleeswara Murthy - 17 hours 14 minutes ago -
Unanswered0Votes
SQL query tools and diagram panes grayed out in Visual Studio Express 2012
I installed SQLServer Express 2012 and Visual Studio Express 2012. I have made a data connection from VS to the SQL database I created through the Database Explorer in Visual Studio. But ...0 Replies | 14 Views | Jim Conn - Friday, June 28, 2013 3:08 PM -
Unanswered0Votes
mouse double click is not working properly in ui 2012
hi all, Please help. I have a list of tree items and I use mouse double click to select the item but why it always work in 1st time but after another ...0 Replies | 11 Views | AnyHoang - Friday, June 28, 2013 1:46 PM -
Unanswered0Votes
VS2010 Web Report wizard starts to load but quits responding
I am trying to load the report wizard into my VisualStudio2010. The wizard starts to load and then just quits responding. I am running it in an existing project, on a 64 bit windows 7 ...2 Replies | 29 Views | ChickenLegWilly - Wednesday, June 26, 2013 6:10 PM | Last Reply ChickenLegWilly - Friday, June 28, 2013 12:48 PM -
Unanswered0Votes
Visual studio add-In
Do we have any add on which will export the data from the "Team Foundation server" to an Excel sheet? If not how can we achive this by any way? can we ...0 Replies | 12 Views | ShivaPrasadM - Friday, June 28, 2013 11:29 AM -
Unanswered0Votes
SQL Log error
Hi All, I get like 4 entries in the SQL Logs every second for login failed for user sa - 18456 Severity 14 State ...0 Replies | 14 Views | Bdrap - Friday, June 28, 2013 11:14 AM -
Discussion63Votes
HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"
NOTE: i have found hundreds of threads on this error, yet they all seem to suggest using the 'Microsoft access database engine'. however for whatever reason (even though its made for 64-bit office) ...103 Replies | 219695 Views | MaxJordan91 - Saturday, December 10, 2011 12:51 PM | Last Reply Anoop3491 - Tuesday, June 25, 2013 7:00 AM -
Answered0Votes
How to Import / Export Excel file or tab delimited text file into Database using MS Visual Studio 2010 database project?
Tasks->Import/Export. Is it possible in MS Visual Studio 2010 DB Project? If it is possible, Please let me know the way to do that task. Your help, will be ...4 Replies | 782 Views | SathyJay - Friday, April 12, 2013 11:18 AM | Last Reply Scott Matson - Friday, June 21, 2013 6:07 PM -
Unanswered3Votes
When compiling VS2010 Database Project in VS2012 I receive error SQL71566
Hello, When using my old VS2010 Database project in VS2012 after transforming it to VS2012 format on compliing the project I receive forllowing error ...17 Replies | 3972 Views | Nilkanth - Sunday, September 23, 2012 1:51 AM | Last Reply Clint Gray - Thursday, June 20, 2013 8:13 PM -
Answered0Votes
integration of database development features into Visual Studio 2012 compared with Visual Studio 2012 Team Database projects.
Is it possible to get a hint where to find proper documentation about the integration of database development features into Visual Studio 2012 compared with Visual Studio 2012 Team Database ...4 Replies | 187 Views | MrBitAndByte - Wednesday, May 29, 2013 7:51 PM | Last Reply Amanda Zhu - Wednesday, June 05, 2013 10:30 AM -
Answered0Votes
SQL71501: User: [x] has an unresolved reference to Login [x] in visual studio 2012
hi I faced to this error recently i want to build a database project in visual studio 2012, i actually have been faced to such error in vs 2010 and i ...1 Replies | 147 Views | Ali Asghar Alimardani - Sunday, June 02, 2013 10:30 AM | Last Reply Amanda Zhu - Monday, June 03, 2013 6:57 AM -
Answered0Votes
SQL server Database project where i only add objects to existing database
i have a few views and few tables that I want to add to my existing database. they are part of different DB schema. It seems I am not able to do it as i have this in my script: I ...1 Replies | 139 Views | YuliaKlimov - Thursday, May 30, 2013 2:46 PM | Last Reply Jack Zhai - MSFT - Monday, June 03, 2013 3:09 AM -
Answered34Votes
Visual Studio Database Tools Error
Hi, I have a problem when trying to use the database tools in the Server Explorer of VS 2010 SP1. I can add a connection to a database in my local SQL Express ...46 Replies | 21340 Views | Justin Fortmann - Sunday, December 11, 2011 3:22 PM | Last Reply NOUNOU16 - Thursday, May 23, 2013 12:08 PM -
Answered1Votes
Visual studio 2010 Integration Services Project can't deploy to SSISDB
I have Visual studio 2010 Integration Services Project After I build it, I try to deploy it to SQL Server 2012 and the new SSISDB but I get a very strange error message (and yes ...7 Replies | 4298 Views | Peter Skoglund - Wednesday, May 23, 2012 7:02 AM | Last Reply RhettClinton - Thursday, May 23, 2013 10:52 AM -
Answered0Votes
Visual Studio 11 Beta => broken MS Visual Database Tools
I've had MS SQL Server 2008 R2 and VS 2010 Pro running happily for quite a while. I took the plunge and installed VS 2011 Beta - after which I had all kinds of issues, so I uninstalled ...4 Replies | 3660 Views | zenocon - Wednesday, May 09, 2012 2:38 PM | Last Reply Sam Jongenelen - Thursday, May 23, 2013 10:11 AM -
Unanswered0Votes
Microsoft Visual Studio 2012 Data Project - Setting Index Fill Factor?
Hi, all. I'm trying to create a new table in my VS 2012 database project. I am having difficulty specifying filegroups and index fill factors. If I create an index and look at the properties window, I ...1 Replies | 160 Views | SEngelstad - Monday, May 20, 2013 8:11 PM | Last Reply Amanda Zhu - Thursday, May 23, 2013 3:00 AM -
Unanswered0Votes
Database Deployment - Always drops function to external CLR assembly
Every time I deploy a database with references to CLR assemblies, the functions that refer to those assemblies are dropped. I don't mind dropping/creating the functions during each ...7 Replies | 201 Views | Rogge - Wednesday, May 15, 2013 8:28 PM | Last Reply Amanda Zhu - Tuesday, May 21, 2013 1:51 AM -
Answered1Votes
"The target database schema provider could not be determined" With VSDBCMD Only When /ConnectionString is Specified
New Project to create Web Service Projects7 Replies | 295 Views | John Saunders - Wednesday, May 08, 2013 1:30 AM | Last Reply RonggangYu(SQL) - Tuesday, May 14, 2013 6:28 AM -
Proposed0Votes
how to ignore ALTER DATABASE statement in VSDBCMD.exe
I m doing a straight copy of schema from one database to another, where in I want to ignore all ALTER DATABASE stmts as I will be creating target database manually, whats the ...3 Replies | 357 Views | Mahesh Dasari - Tuesday, April 23, 2013 7:56 PM | Last Reply Mahesh Dasari - Friday, May 10, 2013 5:55 PM -
Answered0Votes
How to remove check for SQLCMD enabled from the generated .sql file in visual studio 2012
Hi, I have upgraded my database project from vs2010 to vs2012 and noticed that in vs2012 the following check added by default in the final XXX.sql file, Is there any way to remove ...1 Replies | 425 Views | khaledsobhy83 - Wednesday, May 08, 2013 4:47 PM | Last Reply Amanda Zhu - Friday, May 10, 2013 5:16 AM - Items 1 to 20 of 4781 Next ›