DataBase Development Server
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
ADVERTISEMENT
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
Aug 19, 2015
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?
View 6 Replies
View Related
Dec 23, 2004
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
View 4 Replies
View Related
Jul 16, 2007
I want to be able to reproduce my production execution plans on development with copying data.
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
May 11, 2007
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 Related
May 19, 2004
The 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
View 1 Replies
View Related
Dec 20, 2007
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.
View 2 Replies
View Related
Jul 23, 2005
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 Related
Nov 2, 2006
What's the best way to move database from development to production environment?
View 1 Replies
View Related
Feb 7, 2006
Hi.
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
View 1 Replies
View Related
Aug 2, 2001
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
View 2 Replies
View Related
May 2, 2008
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!
View 4 Replies
View Related
Jul 23, 2005
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 Related
Jan 17, 2007
Hello,
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
View 1 Replies
View Related
Jan 2, 2008
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
View 5 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
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
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
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
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
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
Aug 17, 2007
Hi,
Im fairly new to this so apologies if Ive put this in the wrong place.
I have just rented out server for a new asp.net site. Ive been developing the site on my local machine and the database in Sql Enterprise. Ive recently put a copy of the site on the live server and got everything configured.
However everytime I make a change to my local database, or add values into my look up tables I have to go do the same on the live server and its proving a bit of a pain in the ass, so Im guessing there has got to be a much smarter way of doing this. I dont want (if possible) to open up the live sql server to allow remote connections, but if thats what neccesary so be it.
So my question is basically what are my options for keeping my live server up to date with my development server. As I add new features on my local server, should i be saving sql scripts of all the changes I make?
All opinions much appreciated.
C
View 4 Replies
View Related
Sep 22, 2006
Hello,I am working with VS2005pro and sql server 2005 (tables, SP). Nothing online yet but it should be soon for tests, and it will be for me the first time with sql server...I have a very basic question about the way we can keep on adding tables, stored procedures... when the application is already online.I'll try to explain: once online my users will enter data in the database (good point!). But on my side I have to keep on developing new features (new tables, new stored procedures...) and why not add new rows in tables, and I would like to add them to this database on the server once I have finished my development.So what's the best way to work ? Do I need to work online directly on my .mdf database (which I wouldn't like to do) ? Or do I keep on developing on my own computer, on a development database, and then is there a way to update/synchronize with the database on the server in order to add the newly created tables and SP ?Thank for you help.
View 1 Replies
View Related
Jul 23, 2007
Hi,
I need help finding a good back up solution for SQL Server 2005. I am hosting several databases in a shared environment and do not have admin rights to detach & copy & reattach the database file. I can have the hoster back up the file, but that is a manual process and I have had other issues with it in the past (access rights, cost, etc.). I have also tried creating a new business intelligence project, but have found it difficult to do a complete exact copy (while maintaining primary key values) as I run into many concurrency violations. This is especially true in databases that use the standard asp.net membership services tables.
Is there a way to get an exact duplicate of the structure & data of a sql server 2005 database without having to create a new Business Intelligence Project? Or is there an easy way to do this within BI that doesn't require a table-by-table setup? The primary purpose of this backup for me is for use on my development machine. Backup for data security/recovery is handled by the ISP.
Thanks in advance for your help!
View 5 Replies
View Related
Aug 13, 2007
What is the usual way to develop ASP.NET websites locally using a database and then migrate everything to the real webserver?
Here's what I'm doing now -- tell me what I should be doing instead (I'm a newbie developer).
I'm using Visual Studio 2005 Standard with a SQL Server 2005 database, to develop a small C# ASP.NET website. I'm the only developer.
View 3 Replies
View Related
