SQL Development Tools
Feb 1, 2008Is there any way to utilize the 05 development tools without remoting into the 05 staging server?
View 4 Replies
ADVERTISEMENT
Tools Used For SQL Development?
Sep 20, 2004wondering 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,
Suggestions On Front End Development Tools
Jul 20, 2005I'm getting ready to start a fairly large application to be hosted onSQL-Server. In the past I have used Access 2002 (as a front end, wasn'thappy with the number of bugs I ran into), PowerBuilder 6.5, Oracle Forms 7years ago (also no happy with the number of bugs). I was curious what thestate of the art was these days and what current recommendations were for4GL type of development tools.Thanks,Doug Broadwell
View 5 Replies View RelatedArticle On Speeding Up Your SQL Server Development With Easy To Use Tools
Feb 23, 2004http://www.aspalliance.com/349
View 1 Replies View RelatedSQL Tools :: How To Disable Customer Improvement Program From Menu For Server MGMT Tools 2012
Mar 25, 2014Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.
View 6 Replies View RelatedSQL Tools :: R2 Management Tools Install Fails - Specified Account Already Exists
Oct 20, 2014The installation SQL 2008 R2 Management Tools on a Windows 7 workstation fails with the error, The specified account already exists.
Final result:Â SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
 Exit code (Decimal):          -2068052700
 Exit facility code:           1212
 Exit error code:              1316
Â
[code]...
Backup Strategy - SQL2005 Tools Versus 3rd Party Tools
Jun 1, 2007I 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?
Design Tools / Sql Server Mgt Tools Cause Login Fail
Sep 20, 2007Login 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??
SQL Tools :: Tools To Determine Version From BAK File
Apr 24, 2014Is there - apart from the notorious RESTORE HEADERONLY - an tool which is able to tell which SQL Server version created a specific BAK file? I'm looking for a tool that can be used w/o an available/running SQL Server installation.
Alternatively, is there any documentation about what is read with RESTORE HEADERONLY so I could write a tool myself?
Where would I find the version "bytes" in a BAK file?
Server Tools Or Client Tools?
Jun 16, 2008Dear All,
how can we know that wether we had server tools or client tools on my machine?
Arnav
Even you learn 1%, Learn it with 100% confidence.
Tools Tools Tools For Performance ???
May 16, 2002Know any good performance monitoring and analysis tools for SQL server.
View 1 Replies View RelatedWhere To Use Software Development Kit ?
Dec 28, 2007Hi,
i installed Microsoft SQL Server 2005 Express Edition Toolkit which contains Connectivity Components, Business Intelligence Development Studio, Management Studio Express, and a Software Development Kit, and Microsoft SQL Server 2005 Express Edition with Advanced Services which contains Reporting Services.
What i get now is Visual Studio 2005 where i effectively can create reports. But where are the rest? I mean, how to use the Software Development Kit and the Connectivity Components?
I have also installed Management Studio express and Visuam Web Developer 2008; but i don't see any difference after having installing the toolkit.
Thanks
T.
Development Database, What To Use?
May 19, 2004The web hotel I am using have MS SQL server installed. I do not have it on my local development PC.
How do I develop and test a website, locally, using MS SQL DB, without having MS SQL sever. Is there any light MS SQL sever I can use with a good user interface, and then just upload the DB to MS SQL server?
Please advise, NewBe2
Its Only A Development Server But ...
Jun 2, 2005OK, 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!
Database Development
Dec 20, 2007Hi,
Can anyone let me know how to deal with the following things:
Is there any links for database coding, test data generation, editing,data cleansing, migration and loading with respect to Database Developing.
Thanks in Advance.
SQL DEVELOPMENT PROJECT
Feb 6, 2008Hi I am new to the SQL sever development environment.....I was given a project to work on and the problem looks like this....
I have a student data table and a HR table that loads student data and Employee data into a Master table.First the Student data and HR data are loaded into SISDATA and HRDATA tables respectively.Then any duplicates in the SIS DATA and HRDATA are filtered into a DUPESID table and DUPEEID table respectively.If there are duplicates between hrdata and sis data tables are loaded into the DUPES table.If there was a student who works as a part time employee and is a student then there is a conflict in the master table with the row missing its student id in the master table........pls help me to resolve this.Do i need to look over the DB design........????pls help me.
Thanks in advance
Raviteja Chilakamarthi
Development Environment Needs?
Jul 20, 2005Trying to figure out what development enviroment we need in order todo the following:- develop a non-native SQL server stored procedure;- call a web service or java program from the stored procedure;- return static values;- call the stored procedure from a view.How do I get a hold of the right tools and what do I need to put thepieces together?Obviously, I've not used SQL server and I'm looking for the basicstarting point.Thanks!
View 5 Replies View RelatedT-SQL Development Tool
Oct 22, 2007hi,
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
Development Procedures
Mar 14, 2006
Hello,
Recently my partner in crime (so to speak) and I have been asked to develop procedures and/or methods for our software development group. Currently we're running SQL Server 8 with several Access apps and Crystal Reports. In a nutshell, I'm looking for resources.
We're supposed to develop a process (we're both DBA's) where our development team can formally submit new stored procedures, views, or whatever they've come up with to solve for buisiness requirements. It'll be our job to take thier scripts and execute them on the production database after ensuring someone has tested the logic and signed-off on it.
Unfortunately, I have been charged with developing this process (ie: development, sign-off, testing, etc..). Currently we have no procedures in place; until now my partner and I have been the primary deveopers (this is about to change). Are there any resources out there that could help me develop a formal process for our soon-comming developers?
Thanks,
Jason
Diagrams On Development Machine
Feb 15, 2008When I start SQL Server Management Studio from my development PC and connect to a remote SQL-server, I do NOT see any Diagrams.
When I use Remote Desktop and connect to the server, and the open SQL, I see the diagrams.
Is there a way to get the diagrams to work on my local machine?
DataBase Development Server
Aug 9, 2005Hi,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 RelatedTransferring Changes From Development To Production
Nov 27, 2000we have a situation where modifications to the stored procs and views keep happening in the development databse environ while there is a live production database also up and running.
periodically we need to ensure that the development and the production are in synch where all changes made to dev are transferred to prod. however the entire prod database obviously cannot be overwritten as it contains production data. therefore what we need to do is to transfer all SPs and Views from the development to prodn. ( we do not prefer incremental transfers as there are many SPs and views and we can never really be sure that all changes have been transferred )
the obvious way is to script out all SPs and views in dev and run the scripts in prodn. but what we encountered was the enterprise manager does not script out the objects in heirarchical sequence - ie parent objects first and then the objects that refer the parent objects. this leads to errors when running the scripts as the objects required for the creation of a SP, say another SP run from within that SP , may not have been generated by then as the "contained" SP is lower in the alphabetical order in which SQL server scripted out the objects.
finally we had to look at each and every error and manually set the process right.
moreover in the way we did things the "sysdepends" table got all screwed up and therefore we can no longer depend on enterprise manager to show dependencies within the database.
is there any elegant way of going about this ? we also tried transfer manager in DTS but it also gave the same error. moreover can the sysdepends table be rebuilt from scratch ?
Development Vs Enterprise | Performance
Nov 10, 2004We're trying to work out why the same SQL Script takes much longer to run within the Enterprise environment compared to the Development?
What makes matters worse is the development version is on a standard desktop (P4 1.8 256MB RAM) compared to the Enterprise version which sits on a dual Xeon with 1Gig of RAM.
Is is related to the SQL product or am I missing something here? :confused:
Books On Sql Server Development
Apr 7, 2008Hi,
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...
Development Issues With SSIS
Oct 26, 2006We have been facing some delevelopment issues with SSIS. These are as follows:
We want to execute some tasks in a particular package depending on a condition. Example: If record count is more than 0 then go to next task else stop the package.
We tried to write a script, in which we evaluate the value of the variable. This variable is populated with the record count value.
We cannot find any particular function which can exit the package successfully. We can fail the Task, but that means the package is failed. wo dont want to fail the package.
In short we want to conditionally execute some tasks in a package. Something like an "If container" similar to "For container".
We have one main package from which we execute 5 other packages. We want to assign values for connection information and variables in this main package only. The other 5 packages should pick values from this main package.
We are scheduling our package from Windows Scheduled Tasks. When the package is run in this manner, it doesnt read values of variables and connections from configuration file. It uses the values that were provided during development which are embedded in the code.
Thanks
Anup
BI Development Studio Install
Jan 24, 2008I am running SQL Server 2005 SP2 in Vista. I have Developer editions of everything. I am trying to get BI Development Studio and Analysis Services loaded.
I don't seem to have BI Development Studio loaded. When I go to Control Panel/SQL Server install it says it is already loaded, it needs to be modified. When I try to modify it, it isn't there.
Do I need to run this from the command line with SKUUPGRADE=1 ? Modify the registry?
Second question. Can I get Analysis Services projects loaded into my regular 2005 Visual Studio? How do I install Analysis Services into Visual Studio? Or is it always completely separate, just looks like Visual Studio but can't be accessed from there?
Thanks...Marv
Development Environment Setup
Apr 16, 2008
Hi,
I am looking for advice with setting up a 2005 environment for development, debugging and testing using a laptop as the development platform and a desktop pc as the database engine both connected via a LAN. The current configuration is that all the full blown Visual Studio / SQL development software is installed on the development laptop and can go wherever the developer goes, and the Express versions are installed on the desktop pc so that the development database has an unbroken connection with the network. This setup worked well in the past for developing applications that use a typical database interface. The applications could be completely developed and tested before it went live on the corporation€™s full blown production SQL server. Now we want to utilize the Reporting Services/SSIS in our development efforts and I would like to know what parts of the development software (Express vs. Full) should be installed on what unit (laptop vs. desktop) to fully develop and test using Reporting Services before we move to production? And anything else, like what services need to be running on what units etc.
TIA
Jake
Development/Production Databases
Dec 3, 2007
I have a student who has a 100GB database that we need to have a R/W copy of in a Development environment.
It would be okay for the development system to have yesterday's data.
What would be the easiest solution for replicating the data.
Replication?
Log Shipping?
Backup/Restore?
Other Ideas?
Thanks in adavnce for the help.
Cheers,
Casey
Can SCE And SQLE2005 Co-Exist On Development PC?
Feb 14, 2008I'm using visual studio 2005pro. I have SQLE2005 installed but would like to use SQLCE as well. Will they co-exist/play nice on my development machine? Any special install considerations?
View 1 Replies View RelatedSSIS Development Suggestions
Mar 20, 2006I could use some help from those of you who have SSIS deployed in a production environment. The developer creates a SSIS package on a workstation with BIDS. Package accesses a network drive and a SQL database on a development server. The developer can test the SSIS package successfully in BIDS.
The only way to use the ServerStorage protect level is that the developer needs to save the SSIS package directly to the development server (we are storing the package in SQL Server). This is not a problem, but it possesses a problem when we need to migrate the SSIS package to the production server. This is because in development our databases are suffixed with the word test. Also, the SQL Server user id that has access to the tables has a different password in production. We run our SSIS packages with the SQL agent. The SQL agent id has permissions to the network drives; the connection information within the package has permissions to the SQL tables.
How can the DBA, who would ideally does not want to and may not be able to due to audit restrictions, update the server name, user password, and database name without using BIDS? I tried using the configuration file option, but that does not seem to work. It keeps deploying the XML configuration file to my local machine even after successfully migrating the package to SQL Server.
To me, the DBA should simply need to run the deployment wizard and target the production server. At the time of the deployment, the wizard should prompt for items that need to be updated, and the settings should be stored in SQL Server. I know this scenario sounds exactly like those presented in the docs, but I must be doing something wrong.
SSIS Team Development
May 15, 2006In the past I wrote DTS transforms entirely by myself. With SSIS, our team of several developers now wants each member to develop a piece of the same package.
Do SSIS packages support this type of simultaneous multi-developer creation or is it a "one developer at a time" type product?
TIA,
Barkingdog
Website Using LINQ To SQL Development V Live
Feb 8, 2008Hello,
I have my local development evrioment and my live webserver in colo. The two different machinces both have SQL2005 and copies of roughly the same database. I use the one for developement and the other obviously for production. Currently I read in different connection strings from my web.config file for my live version v my development version so I can have different database names and connection strings.
I'm looking at moving to LINQ, but I can't figure out how I'd achive an equivelent flexibility as database names and connection strings seem to be hardcoded in to the class using it's designer. Obviously if modifing this wasn't possible, nobody would be using LINQ, so how do I work around this?
Thanks,
Joel Barsotti
Moving Development Environment From MS SQL To SQL Express
Apr 3, 2008Hi all
I need to move an entire live environment from MS SQL 2000 (because of developing further before uppgrading) to SQL Express but cannot get it to work. Is this possible to do at all?
/Johan