May 24, 2007 #1 holdahl IS-IT--Management Apr 4, 2006 213 NO Does anyone know if there are any tools which developers could use to view the databases on a SQL Server (2005)... -holdahl
Does anyone know if there are any tools which developers could use to view the databases on a SQL Server (2005)... -holdahl
May 24, 2007 #2 ptheriault IS-IT--Management Aug 28, 2006 2,699 US How about the tool that comes with SQL Server, SQL Server Management Studio (SSMS). - Paul - If at first you don't succeed, find out if the loser gets anything. Upvote 0 Downvote
How about the tool that comes with SQL Server, SQL Server Management Studio (SSMS). - Paul - If at first you don't succeed, find out if the loser gets anything.
May 24, 2007 #3 avanderlaan Programmer Jul 11, 2002 156 Red-Gate SQL Compare and SQL Data Compare allow structural/ schema/data comparisons and synchronization between databases. Upvote 0 Downvote
Red-Gate SQL Compare and SQL Data Compare allow structural/ schema/data comparisons and synchronization between databases.
May 24, 2007 #4 ptheriault IS-IT--Management Aug 28, 2006 2,699 US As a DBA I would never allow developers access to any of those Red-Gate or Idera tools. Are you looking for a tool to view the schema as diagram? OR a tool for developers to physically see the tables and query them? If you need to create database diagrams use Visio Enterpise version. If they just need a tool to write queries use SSMS. - Paul - If at first you don't succeed, find out if the loser gets anything. Upvote 0 Downvote
As a DBA I would never allow developers access to any of those Red-Gate or Idera tools. Are you looking for a tool to view the schema as diagram? OR a tool for developers to physically see the tables and query them? If you need to create database diagrams use Visio Enterpise version. If they just need a tool to write queries use SSMS. - Paul - If at first you don't succeed, find out if the loser gets anything.