Hi,
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.
Can someone provide a step by step tutorial for this? I'd like to safely update a database that is used for a website without much or any downtime.
View 1 Replies View RelatedThe 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
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 RelatedI 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
I have a production database with a backup job that creates files with thenaming convention dbname_db_200503291800.bak. I want to schedule a restorejob that will retire yesterdays backup. How can I write my restore statementso that it will specify the backup file with yesterdays date.Thanks
View 1 Replies View RelatedWhat's the best way to move database from development to production environment?
View 1 Replies View RelatedHi.
I have a question that I have been thinking about for some time. Have in mind that I'm somewhat a SQL newbe.
I work on a few webapplications that are database driven applications. When we desides to change something in the database, we normaly do the changes on our replicat development database, and after some testing the changes are suppose to be implamented in the live, public database.
Now, what is the best way, or recomended way to do this? Today we bo it manualy. But at one time I experimented with the export/import wizard to se if it was possible. What I want to do is change de design of a tabel, without loosing the original data, and without geting the data from the development database into the live database.
To export an stored proccedure, I usualy just create a SQL-script for the procedurs in question and the runthe script against the public DB using the Query Analyser. But if I do the same procedure on a table, I loss all the data in the database.
Do I make any sense at all?
Any tips/idea/best practise on this subject?
/Johan Christensson
Hi,
We're using SQL Server 2000 as back end in our web project. The problem is we've 3 different copies of same database - one each for Development, Test and Production sitting in 2 different machines.
My question is - is there any tool for comparing the objects (tables, stored procedures, etc) ?
Thanks,
Harish
Hi,
I'm neck-deep in trying to normalize all the info I need into separate tables, but I seem to have hit a wall running.
I was curious as to what the "best" way is to develop a database of concert events would be? What I think I've figured so far would be if I created a table called events...that would be 1 row of data per concert event. Each row could then have a 'event_id' as PK, 'date', and a column with the associated 'band_id' from the bands table. Then anytime the date was accessed (assuming a populated row for that date), a list of concerts for that date would show.
I would also like to use the 'event_id' as an access point for my reviews table...where, quite obviously, I would like to be able to have reviews associated with each event from the calendar as well. Does all this seem right? Or is there a better way (i.e. more efficient, smaller database, and/or use less memory)? How, for example (in short, obviously), does a website like Pollstar.com database their events?
I guess my question with regards to this database is also...within my bands table, should I include their tour dates? Or should I put the band_id in my events table?
I was hoping to get a just a little bit of direction so I don't turn some baby missteps into a long-term project down the wrong road. Any help or response is greatly appreciated. Thanks again!
I have been looking for some documentation that would support or rejectmy opinion on Production -vs- Development naming conventions. Ibelieve that each environment should be housed on separate servers withidentical names, access, users, stored procs....... If you eitheragree or disagree with this methodology, I would appreciate your input.TIA,Bill
View 5 Replies View RelatedHello,
I am trying to refresh a test database with data from a production database. Both database structures are identical, e.g. constraints, stored procs, PK, etc. I am trying to create a package in SSIS that accomplishes this task and I am having extensive problems. The import export wizard is out of the question because the constaints are not carried over, plus when I try to refresh the data using the import export wizard, it fails on 1 specific table because of a column in that table named "Error code". I think "Error code" is a micrsoft keyword, so it fails on this column. Does anyone know a workaround that I can do to accomplish this simple task, that could be completed in minutes using DTS. I understand that SSIS is not as straight forward as DTS, but this task is something that DBA's do on a regular basis and therefore should not be this difficult.
Any help would be appreciated,
David
Hi,
I work with a large team developing ASP.NET application that has a large database with over 50 complex stored procedures. It is proving more and more difficult and time consuming to centralise the development and update of the database changes and I was wondering if there were any best practises/tools that could be recommended. I have looked on the web for good articles and haven't found anything difinitive (except that Team Foundation Server is the way forward)..
A brief background to the current process is that everyone develops on the same database, and then updates the stored procedure scripts in source safe (manually). Then when we do a new release someone builds a script of all the database updates and runs it. There are issues related to developers updating there stored procedures over other peoples and other concurrency.
I am looking to move all the developers to start using local databases so that there work only effects them, but then this brings up problems of keeping all the local databases up to date whenever they get the latest source code. The only way I currently see is to build a database update program, that will run and update to the latest version.
Surely this must be a common issue? Anyone have any good ideas/concepts?
Also our setup is Visual Studio 2005, SQL Server 2005 and Source Safe 2005.
Cheers,
Andrew Thomas
We are using SQL Server 2012 for both production and development server. Currently, i have plan to transfer the full backup of SQL server database to the development server and then restore it on the development server for testing purpose, so we don't want to disturb on the production.
I have successfully backup the database from the production server and transfer to the development server. however, i encounter some difficulties when trying to do restore. my question is:
1. do i need to firstly create an empty database on the development server and then restore it into this empty database? say i create database call "Test2", then i perform a restore into this database.
2. currently, there is already an existing database being restored previously in the development server and this database is actually the older version of the backup that being restored by the previous engineer. should i remove this database first and restore a new one or both of the database can coexist as long as we put different name for the database?
Hi all! I know I might sound stupid, but I have this problem. I have developed my database on my laptop which does not use Active directory. Lets say I access the database with: SPIDERMANDB1 on SQL server, where the name of my laptop is SPIDERMAN, and the database is DB1. Now, I create an SQL script from sql server and make the necessary changes, like changing the computer name to say, SUPERMAN where my deployment server's name is SUPERMAN. But when I run the SQL script on the SUPERMAN server, it gives me an error like: "User or role SUPERMANDB1 does not exist in this database". I have deployed databases in this way on servers without Acive directory, so I'm sure its not a mistake on my side. So how am I supposed to go around this active directory thingi! Please help me out! I'm counting on u guys!
Wes
I want to be able to reproduce my production execution plans on development with copying data.
I have finished a change request from our client. I need to update clients' database with the one in developments.Here is the changes i made to database:Added/Changed some tablesAdded/Changed some stored proceduresAdded data to some dictionary tableThe data in clients' current database MUST be kept. So how can I merge the changed information to clients' database?
View 3 Replies View RelatedHi
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
Hi,
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.
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!
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,
Hi 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
Trying 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 Relatedhi,
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
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
Is there any way to utilize the 05 development tools without remoting into the 05 staging server?
View 4 Replies View RelatedWhen 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?
we 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 ?
We'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:
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...
We 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
I 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
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