Need Recommendation On Tool For SQL Server Development
Sep 12, 2000
Need Recommendation on Tool for SQL Server Development
I have inherited a SQL Server 7 database (actually a SQL Server 6.5 database running on SQL 7 in compatibility mode) with 1000s of objects with triggers and stored procedures with zero documentation; i need to make major changes to this database; are there any tools available that will allow me to quickly search through the database objects and code (like stored procedures, etc) for keywords and other useful criteria? Do you recommend any SQL Server specific tools that will help me learn this database in the shortest amount of time?
Thank you!
--llyal
View 1 Replies
ADVERTISEMENT
Aug 14, 2006
Our shop is expanding use of SQL Server, both 2000 and 2005. We haveLitespeed on some boxes to handle the backup/recovery jobs. Can I askwhat are considered the best tools for monitoring SQL Server, in termsof things like performance monitoring, tuning and auditing if it ispossible to get all of this functionality in one?What do you use and like?Thanks in advance.Gerry
View 2 Replies
View Related
Nov 16, 2006
Is VB.net the most logical choice of a RAD tool to use with MS SQL Server? Is VB.net strictly for web apps or can you use it to create projects that run as executables off the server?
JustStartinOut
View 12 Replies
View Related
Oct 22, 2007
hi,
I am about to begin writing T-SQL procedures,
I was given SQL SERVER MANAGEMENT STUDIO
is this the optimal tool for T-SQL development?
I now that oracle developers use specific tools for procedures developemt (PL/SQL DEVELOPER)
is there a specific tool for T-SQL developent like in ORACLE?
Best Regards,
Noam Manor
View 6 Replies
View Related
Jun 13, 2007
I am about to start developing a web app using MS SQL Server and was wondering whether there is any tool that I can use to test queries towards a remote server?
Something like a command line or an easy way I can write queries and run them straight away through the server and check results? It is my first time developing in SQL so I need something that allows me to play around with queries in the server and check results to quickly get a hang os MS SQL Server syntax, stored procedures and such.
Best Regards
Alethenorio
View 4 Replies
View Related
May 18, 2006
I have a database that is around 2 to 4 GB.If I were to estimate some numbers like 4x growth oreven 10x, the database size could reach 40GB.The new server will be running SQL Server 2005.I am not sure which configuration option to take.I've gathered some information from different places:Configuration #1:OS - Raid1 2x36GBLogs - Raid1 2x36GBData - Raid 5 4x73GBConfiguration #2:OS - Raid1 2x36GBLogs - Raid5 (not sure how many drives)Data - Raid5 (not sure how many drives)Now if I am using a separate RAID array disksfor the database's transaction log, should I also put theTempDB in this RAID also?Here's the configuration I am thinking of right now.Please give me your comments:OS - Raid1 2x36GBLogs & TempDB - Raid5 3x36GB = 2x36GB usable spaceData - Raid5 3x73GB = 2x73GB usable spaceIf you have other configurations you recommend please letme know.Thank you
View 1 Replies
View Related
Jul 20, 2005
Greetings All, I would be much obliged if anyone can point me to agood book on Java/JDBC and SQL Server.Regards, Louis.
View 1 Replies
View Related
Feb 14, 2006
Hello,
I have been working as Sybase DBA for 5+ years, and I would very much like to add MS SQL Server to my resume. Given the common roots of the two RDBMS, it seems that the learning curve would not be as sharp as if I were going to learn Oracle or DB2. Can anyone out there know of any books that are geared toward learning MS SQL Server from a Sybase DBAs perspective?
Thank you,
- Chris Merz
View 3 Replies
View Related
Jun 2, 2005
OK, it isnt the end of the world but i have been moving all SQL databases from one server to another in our development environment and think i have screwed up a bit.
In essence, the users in each database are different to the logins in the security tab. IE, there are users in DB1 that dont appear in the logins list. Is there anyway of getting the security information uptodate? I move the databases by detach|file copy|attach into the nice shiny new server. I am running into all sorts of errors when i try to create users in security as it says the user alrady exists ...
all thoughts welcomed, am steeling myself to start all over again!
View 2 Replies
View Related
Jun 24, 2004
I was if anyone can recommend a book that specifically focuses on SQL statements such as Queries, Stored Procedures, Triggers, Transcations..etc
View 11 Replies
View Related
Apr 8, 2008
Hello,
I will have to create a table that consists of only of two fields. one: them employeeID and two: the SupervisorID,
my question is what should I define as my primary key. Should it be an aditional field, or could it be the EmployeeID field.
The employeeID is an unique filed. The end user for this application will be updating rearly some of this records, and may be adding or deleting some new records exporadically.
Thanks for suggestions.
View 6 Replies
View Related
Dec 21, 2006
Hi:
Here's the scenario I'm working with:
A SQL 2005 server with around 1K~ databases, capacity at about 1TB~. We would like to be able to have a warm standby with transactions replicated to it. In the event of a failure on the principle, we would want the warm standby to come online automatically and begin serving db requests.
I've looked at the SQL 2005 database mirroring option; however, this has a restriction of around 10 databases per SQL server instance which, unfortunately, I exceed. One method I've been looking at is transaction replication in the classic publisher / subscriber model; however, how would I handle automated fail-over to the subscriber if the publisher were to fail?
Does anyone in the community have any thoughts or recommendations?
Thanks.
-matt
View 1 Replies
View Related
Aug 9, 2005
Hi,I am trying to create a development database server (make use of an old machine), with which to learn about sql 2005 and oracle etc. I'm using VS 2005 Beta 2 on my development/workstation machine.My workstation and the prospective server are connected via a router and can 'see' each other.I have installed win 2003 server on two seperate partitions (multiple boot) and installed sql server 2005 on one partition and will install oracle 10g on the other. (I understand these two databases can run on the same machine/OS, but I just wanted to keep things tidy and I won't be using them at the same time, so ...).My question is how do I/should I configure win 2003 server / sql server 2005 on my server machine, in order to be able to connect from my workstation via vs 2005 beta 2 ?Any suggestions or resources on configuration appreciated.
View 2 Replies
View Related
Apr 7, 2008
Hi,
Can anyone suggest good books on exclusively sql server development..Not for the beginners but at intermediate to advanced level.. Books which gives good understanding on Stored Procedures, Triggers, Cursors, Functions...
View 1 Replies
View Related
Mar 23, 2008
Hi all Pros I am transfering from windows2003 server and MS SQL 2000 to Windows Vista and SQL Express ...... Before I allways created a database manually and I could allways use as many databases I needed so in that way I could have several versions of a database for a certain software during development. Can you use separeted databasenames when developing in SQL Express? I am using a dotnetnuke installation file and inside the project there is a file /App_Data/Database.mdf should this file be renamed everytime I make a new testinstallation or setting up a separate dev environment /Johan
[Moderator Edit: unrelated links removed from post body.]
View 2 Replies
View Related
Feb 18, 2015
Production and development servers are on different domains and they do not trust each other. How do I import data from the table t1 from a database db1 in production and load it into table t1 inside database db1 in development?
View 3 Replies
View Related
Mar 2, 2006
is it possible to change the settings on this tool. i want to have it so that it does not time out at all? or is that possible??
View 1 Replies
View Related
Sep 8, 2004
Can anyone recommend me other "REALLY GOOD" msql server forums?
Thanks
View 1 Replies
View Related
Sep 26, 2004
Hi, folks. I've a production SQL machine with more than 20 users making transactions 24 hrs in 6 days a week. I've only Sunday for maintenance. The server has fixed 2 GB RAM allocation for SQL. Is it good to Restart SQL ( or machine) to clear the Buffer-Cache( or is it good to keep the cache) .... :rolleyes:
Howdy!
View 3 Replies
View Related
Jan 15, 2004
Are there any general recommendations concerning filegroups? My personal point of view is to place large tables in their own filegroups and group smaller, more static, tables in a single filegroup. Is it also good practice to group small and large index in two separate filegroups or should each large index have their own filegroup? Are there any useful links out there concerning filegroups and configuration?
View 1 Replies
View Related
Oct 7, 2007
i need a recommendation for a good database creator & manager software, with a simple user interface (not access :-) ).
thx
View 9 Replies
View Related
Jul 20, 2005
I am in need of some advice. I need to build a SQL machine that willbe adequate for my company. Budget is a very big factor but I need themachine to be reliable and as redundant as possible.This box will be 'vanilla' since I will be building it myself. Ilooked at some larger companies websites and the prices are way out ofcontrol.Here's what my configuration is so far (keeping price in mind):Case: rack-mount 4UMotherboard: Intel 865GLCL (800MHz FSB)Processor: Intel Pentium 4 2.4GHzMemory: 1GB DDRAMHard Drive(s): 3-36GB SATA [10,000 RPM] in RAID 5 configurationCD-ROM: standardFloppy: standardRAID Controller: Promise SATANIC: 3ComMy machine does not come under a very heavy load but it is used often.I'm interested in hearing others comments about their SQL servers so Iknow how to gauge building my machine.
View 4 Replies
View Related
Jul 20, 2005
Can someone please recommend a good book for SQL Server 2000 for aprogrammer(Powerbuilder), not a DBA.
View 1 Replies
View Related
Jul 27, 2006
I have begun to try to break out of using Access db's (97!) and have been trying out SQL Server Express 2005 along with the SQL Management Studio Express. I am a little confused with it as I am trying to use the interface inside of VB.NET 2005 as well as the management studio and sometimes I can connect from one without the other.
Anyway this points to the fact that I have a lot to learn and I was looking for a recommendation for a book that could be a tutorial for using VB.NET 2005 with SQL Server Express. I really need something that starts from square one but hopefully builds fast. Right now it appears I need to understand connection strings (when do I put ".sqlexpress" and when do I use the server name followed by the instance for example?).
I have tried some of the books online for example and ran into a dead end with the simple tutorial (http://msdn2.microsoft.com/en-us/library/ms165732.aspx) when the headers didn't sort, I couldn't select any other pages and the edit button didn't work. I don't have a clue what happened as I followed the instructions.
Anyway if someone could recommend something that teaches using SQL Server Express while building an application with VB2005 that would be perfect.
Dana
View 3 Replies
View Related
May 31, 2007
Please give me some advice. In my application I calculate a list of identifiers (Guids) that are primary keys in my table and I have to retrieve those rows from the database. So my first approach is like
Code SnippetSELECT id, c2 FROM t1 WHERE id IN (@id1, @id2, @id3,....)
where @idn are the calculated identifies as parameters. This approach does not scale well since there is a limit of parameters that can be used. So one possibility might be to use several SELECT statements, each with the maximum number of parameters. I can't believe that this is a good solution. A temporary table may be a better solution - I don't know. Are there any better ways to retrieve performantly - any recommandations?
Thanks a lot
Hans-Peter
View 8 Replies
View Related
Dec 20, 2007
Please can anybody help me in transferring existing SSIS Packages saved in a shared folder location from development server 2ED to Live server TWD1.
Both has SQL server 2005 running and has visual studio 2005
Currently about 25 SSIS packages are executed from the development server transferring data on Live server TWD1...these ETL process is called from development server but executed on live server.
Now the problem is when i call these packages from the shared folder from live server it crashes.....i need to changes something to shift the whole package to the live server..and execute on live server itself instead of recreating the whole 25 process from scratch.....also i use optimize for many tables ..and run in a single trancastion....so how can i see the mappings of source and destination tables.
Please let me know the process how i can achieve this.
Thanks
George
View 5 Replies
View Related
Apr 24, 2008
I am running both SQL Server 2000 and SQL Server 2005.
Lets say I have a live database that is version 1 for an application. The database is copied onto a development machine to develop version 2 of the application. I want to be able to take a snapshot of the database and then get a program to write all the changes made after the snapshot into sql code. This is so I can run this sql code on the live database and transform version 1 to version 2.
Is there any program/tool that will allow me to do this?
Jagdip
View 4 Replies
View Related
Dec 22, 2007
Hi,
Can anyone suggest me good books for learning sql server development ie stored procedures etc..
View 1 Replies
View Related
Nov 1, 2007
I have a SSIS package that runs fine when I execute it in visual studio but when I run it on the server as a job it fails. This is nothing to do with protection levels etc as the job is running. It fails part way through with this as the error log
Started: 2:42:48 PM
Progress: 2007-11-01 14:43:04.16 Source: Import Hon File Validating: 0% complete End Progress
Progress: 2007-11-01 14:43:04.16 Source: Import Hon File Validating: 50% complete End Progress
Progress: 2007-11-01 14:43:04.22 Source: Import Hon File Validating: 100% complete End Progress
Progress: 2007-11-01 14:43:04.22 Source: Import Med File Validating: 0% complete End Progress
Progress: 2007-11-01 14:43:04.22 Source: Import Med File Validating: 50% complete End Progress
Progress: 2007-11-01 14:43:04.22 Source: Import Med File Validating: 100% complete End Progress
Progress: 2007-11-01 14:43:04.22 Source: Import MedFac File Validating: 0% complete End Progress
Progress: 2007-11-01 14:43:04.22 Sour... Process Exit Code 1. The step failed.
It is failing on the last file it is trying to import but it works OK on my PC.
Can anyone give me any pointers on what might be causing this.
Thanks
View 5 Replies
View Related
Dec 26, 2007
Hi,
While developing the packages in our developers environment the packages should be stored in file system. Once after the completion of the development, while moving these packages to upstream environments the packages should be deployed to sql server. Is this scenario possible? If possible, can anybody give me some tips for how to do that.
Basically It is like the developers make their changes in the file system packages (internally versions are mainintained by source control). After the completion of the development whenever we do a build and deploy to the upstream systems we should move the packages from file system to sql server database. There is a scheduler in sql server which is responsible for executing these packages.
Can anybody give me some examples?
Another question.
Assume that in the developers environment there is a central sql server database which is storing all the packages in MSDB database. Suppose at a time 2 developers are making modification to a single package. How it behaves? Is parallel developemnt supported in SSIS?
Thanks in advance.
View 6 Replies
View Related
May 7, 2007
Hello
I'm using SQL Server BI Development Studio to create a mining structure to forecast time series analysis.
The process to create a model for time series has these steps:
Create a connection to the Database;
Create a source view. Create relationships between tables using the foreign keys;
Create the model with the mining structure. Define the fields that I won€™t to predict and the algorithm properties aren€™t changed.
Is something wrong in these steps, I missing something?
Other problem is the utilization of the model created earlier. In some tests that I made, the models don€™t do forecasting upper then 20 steps. The problem could be the number of lines? But other data set with a large number of null values doesn€™t have any problem predicting more than 20 steps using the time series algorithm.
Can someone help me?
Thanks in advance.
JoĂŁo Santos
<!--[if !vml]--><!--[endif]-->
View 3 Replies
View Related
Apr 1, 2007
Hi Everybody,
I have made one simple application in asp.net 2.0 using VS 2005. I got following error
Server Error in '/[applicationname]' Application. --------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
- When i got on my local machine i solved it by deleting sqlexpress directory from user's account and it was due to that I have installed VS 2005 on machine and by default it installs sql express with it.
- But I could not solved this error on my Development Server wherein there is no VS 2005. Only .Net framework 2.0 & 1.1 are there. My all other applications are running well.
So if any one have idea regarding the solution for this error then please reply me soon. It is very urgent.
Thanks to all of you.
Regards, Hardik B.
View 1 Replies
View Related
Nov 9, 2006
Hi
Can we use BCP AND/OR BULK INSERT to do development server databse refresh from production server . I have to do this by following the rules below:
- no truncation of source table
- update of changed or new records only.
I know we can use replication, dts and other methods for this but I need information about this one.
Thanks
View 1 Replies
View Related
