SQL DB Tools
Can anyone recommend any tools or bundles that are out there for MSSQL databases used for comparing and syncronizing stucture, data, stored procs, etc.
I'd like to hear about any and all.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Backup Strategy - SQL2005 Tools Versus 3rd Party Tools
I am running SQL Server 2005 x64 Enterprise under Windows 2003 x64 Enterprise. My current backup strategy uses T-SQL jobs run by SQL Agent (writes out *.bak files) and then I have an Integration Services job that copies the *.bak files to our NAS device. I have performed a restore without issue. The jobs are all automated every four hours via SQL Agent. Is this a sound strategy or are there additional benefits to using 3rd party tools? If so, what are the advantages and which tool provides them?
View Replies !
View Related
Design Tools / Sql Server Mgt Tools Cause Login Fail
Login failed for user 'TOSHIBA-USERASPNET' I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer, not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do. last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
View Replies !
View Related
Tools
I don't know if I can ask this here but I'm gonna go for it. I'm in the process of investigating 3rd party performance and monitoring tools and to say the least it pretty overwhelming. There are so many products out there it's easy to make a bad choice. My main concerns as I said is identifying processes that are creating bottlenecks and being able to resolve them quickly. Are there specific vendors that people are using more then others? Is there someplace I can get a concise functionality comparison? I see the Idera and Quest products advertised heavily in the trade mags. I'd appreciate any help or direction I can get.
View Replies !
View Related
Tools
Is anyone aware of a tool, utility or Stored Procedure that would allow you to compare stored procedures on diferent servers and to copy stored procedures from one server to another (eg. test to prod). Thanks, Ken Nicholson
View Replies !
View Related
SQL Tools
I am trying to find a report writing tool (like BRIO), that also allows users to update lookup tables. Is there any products that allow this? Thanks Joe
View Replies !
View Related
SQL Tools
Hi guys, for one of our forthcoming sql project. I need your inputs/recommedations on the tools and techniques widely used in SQL SERVER based on the following parameters Design efficient schemas optimizing queries, stored procedures fine - tuning indexes Performing efficient transactions analyze and understand execution plans Scalability pitfalls Test and monitor data access performance Generate historical and reporting data Processor,memory and performance related bottlenecks DISK I/O related bottlenecks. SQL IN Minds
View Replies !
View Related
MSDE, SQL Tools
I planning some web app that I would like to use MSDE to power. I admit I am intimidated by the thought of creating databases with no GUI. So my question is can I use SQL server 2000 tools with MSDE or can I create databases with SQL server 2000 then deploy them to a machine running MSDE? Thanks
View Replies !
View Related
Comparing Log Tools
I've only ever used built in SQL Server tools but have been looking atlog tools. I looked at Log Explorer 4.02 from lumigent.com and was veryimpressed with what I saw. The prices tag per instance was a bit heftyI felt though. I've been over to LogPI.com and am reading some of the"features" I've yet to d/l the evaluation demo. The price is over halfthat of Log Explorer (I'm converting to local currency on the flyhere).Questions.... logPI any good? Log Explorer worth the extra $?Anyone using either and have any opinions to share?Are 3rd party tools worthwhile?Unrelated but for my info.... does/will Yukon come with a similar builtin tool? I haven't had a chance to look at Yukon yet.CheersJay
View Replies !
View Related
Monitoring Tools.
All, I seek your knowldege. I am looking for a monitoring tool thathas the abilility to page and email me should something go wrong withSQL server. I know of two such tools: 1.) BMC Patrol, and 2.) Quest'sFoglight. I was hoping that some of you have had some experience withother such tools. Let me know please.Louis
View Replies !
View Related
MS SQL Monitoring Tools
I am looking for a versy simple tool to simple monitor our ms sql dbs : I mean by simple monitor : - checking if db is up. - checking that there are no errors in : jobs, log... - checking space, file extentions... Anyone know a tool doing this. I tried SQLCentric but I am not really satistied ... Thanks
View Replies !
View Related
Tools Used For SQL Development?
wondering what software tools people in the industry use for development of SQL projects. I use SQL Enterprise Manager to manage the server then a mixture of SQL Query Analyser and MS Access to develop queries for our ASP/WEB projects (using access as an instant graphical front-end to the data). Used to use a third-party tool to develop the sql code but not anymore as it was just a pain to get done, was called RapidSQL. look forward to people's replies on this one, any input much appreciated,
View Replies !
View Related
OLAP Tools?
So I am starting to look at an OLAP problem having been an OLTP DB wonk for several years. All very nice. Am bending my head aorund cubes and the dimensions trciks and learing to choose them more carefully. Have wokred through the various chapters of various SQL books (OLTP books with a couple of chapters of OLAP I admit) and am starting to feel if not comfortable with it at leats not compleetly terrified. Now the Analysis manager in SQL is all well and good but I'm not about to hand it to the accounting monkeys that work here. Does anyone have any suggetsions of some good OLAP specific books and any Cube viewing tools/suites/utilities that I can give to the computer-illiterate bean counters I work for? many thanks Steve
View Replies !
View Related
Monitoring Tools
Hi all, I'm looking into the possibility of buying (as I doubt there's any good free options) a SQL Server Monitoring tool. Has anyone got any particular recommendations - good or bad? I know a little about Spotlight, but not much else. Thanks in advance. --------------- zinedunc
View Replies !
View Related
Monitoring Tools
Hi, We are evaluating proactive monitoring tools for our heterogeneous database environment, currently comprising of Sybase and MS SQL Server. Our current options are Bradmark Surveillance, Quest Foglight/Spotlight, MOM (SQL Server only) & Embarcadero Performance Center. Are there any recommended tools from your experience? Or any tools with with you have had bad experience? Tia.
View Replies !
View Related
Schema Tools
Are there any free tools for comparing database schema's i.e. the same database against different versions on different servers? Or is there a tool in Management Studio which will highlight any differences between the databases?
View Replies !
View Related
Tools For Y2k Compliance
Hello, I am looking for a method or tool to search for Y2k compliance on triggers and views. Does anyone know of any. I have found a tool to check stored procedures and SQl server data but does not check triggers and views. Thanks Steve Bajada
View Replies !
View Related
Tools For Y2k Compliance
Hello, I am looking for a method or tool to search for Y2k compliance on triggers and views. Does anyone know of any. I have found a tool to check stored procedures and SQl server data but does not check triggers and views. Thanks Steve Bajada
View Replies !
View Related
Admin Tools
Hi Guys I have just been trying to install the Admin tools from the SQL 6.5 setup CD on a Win NT Workstation 4 SP6 system. Everything seems to go fine until the icons are addded into the program group, these come up as system default icons and don't link to any programs. If I go into the installed directory and execute the programs then I get the following message: The SQLOLE OLE object could not be registered. Class not registered (80040154) After clicking OK the program terminates. I have tried diferent install directories, even diferent partitions. I have also deleted the directory and removed the Registry entries manual - this is because it cannot be uninstalled. Still no luck. Any ideas? Many thanks Stuza
View Replies !
View Related
2k Client Tools
Can you install SQL 2k Enterprise Client tools only on a Win2k professional box? Is Win2k professional a Enterprise or Standard operation system? When I start to do a SQL 2k enterprise client tools install I get like part ways throught the install, and than nothing. It just stops. Any help
View Replies !
View Related
Sql Optimizing Tools
We are evaluating a tool by Lechotech that can optimize sql statements. It is a pretty good tool, but we would like to compare it against some others. Has anyone seen any other such tools?
View Replies !
View Related
SQL Client Tools
I need to be able to administer SQL 6.5 and 7.0 servers from a single pc. I have been told that I can't have SQL 6.5 and 7.0 tools installed on the same pc. Is this correct? I can't find anything in BOL or Technet on the subject. Regards, Kevin Napier
View Replies !
View Related
Case Tools
Hi Can anyone suggest me a good case tools that works fine with SQL Server. We have old version of ERwin and we like to upgrade. The decision is whether to upgrade ERwin or go for any other tools better than ERWin. Thanks in Advance. Jaya
View Replies !
View Related
Tools For Normalization...
What's my question is ? Whether there are any tools available for normalization produced by Database vendors or any third party. If yes, Can u kindly give me clear documentation. Thanks, venkat. venkat_26178@yahoo.com
View Replies !
View Related
MS-SQL 200 Replication Tools
I have two sites connected over VPN. In one site I'm running an ERP solution that uses MS-SQL 2000. The second site uses CITRIX to access the first site app client. What I want to do is to replicate the DB in the second site so that in case of a disaster or if the link is down I can have a plan B option. I'm new to replication, so I'm looking for info (easy steps) to get this accomplished. Is the MS-SQL 2000 replication strong enough/reliable for this sort of deployment? Are there third party tools that you recommend? Thank you in advance, Zuno
View Replies !
View Related
Help With Installing VS Tools
Hi, I have a problem with the installation of SSCE31VSTools-ENU.exe into VS2005. The installation ended after a few seconds although in the event log there is information that the product is successfuly installed. However, when I run Visual studio there is no project under Smart Device regarding SQL Compact database or something similar (there are only templates for: device application, class library, control library, console application, empty project and nothing more) VS2005 is in this version 8.0.50727.762 (SP.050727-7600) In application event log there is: Product: Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 [ENU] -- Configuration completed successfully.'" Has anyone some idea if there is a problem or how to create SQL Compact database? Thank you Jarda
View Replies !
View Related
Where Are My Tools? SQLEXPR.EXE
Hi, I've installed ms visual studio 2005. On the list of installed components, there was SQL server 2005. As far as I'm concerned it automatically installs SQL Express. I have VStudio ready for work, in start -> All Programs -> MS SQL Server 2005 I have only "configuration tools". Where can I find tools for createing database schema, some sql editors, tools for creating new users.. etc???
View Replies !
View Related
Indexing Help Tools
Dear All, in my current databases, indexing is very poor. same columns are having clustered index and non clustered indexes. is there any tool to help me out? i'm thinking in this way...please correct me if i'm thinking wrong... 1) i'm planning to drop all the indexes first. 2) i'm planning to create clustered index on ID column. 3) i'm planning to create non clustered index on some columns which are using where conditions.(many procedures and functions, as well as report queries). 4)planning to run the index rebuild script everday at non-peak time 5)planning to run the index defragmentation script every week at non-peak time 6) planning to run shrink database command every week. please correct me and add flavour with your great experience. thank you very much Arnav Even you learn 1%, Learn it with 100% confidence.
View Replies !
View Related
Tools For MSQL
Hi, 1. I am wondering if exist a tool to let me easily document my databases, unde MSQL. e.g.I want to create a doc file or better a html file with all my databases objects, descriptions, DDLs etc... 2. Another tool to create code patterns; I need a something that generate custom code patterns, but in VBScript or C#. p.s. Sorry if i created this topic on another forum. Thanks, <u><b>Jack Bower</b></u> software developer IATAR Studio http://iatar.port5.com
View Replies !
View Related
|
TRACKER
