Can Aspnetdb.mdf Be Moved From Development To Production Machine?

May 2, 2007

1.) Can an aspnetdb.mdf database be configured and setup on one server and then be moved to a production server or is there something machine specific that keeps this from being possible? 
2.) Is putting this file in the app_data folder something that is used only for SQL 2005 or SQL express?  I had to set up a connection string in my SQL 2000 installation to get the connection to work.

Thanks for any input!

Colelaus

View 4 Replies


ADVERTISEMENT

Moved Aspnetdb To SQL Server - What Permissions Do I Need To Give The ASP IIS Service Account For That? (Getting: Cannot Open Database Aspnetdb Requested By The Login. The Login Failed.)

May 12, 2008

I am getting the error:
Cannot open database "aspnetdb" requested by the login. The login failed.
When I browse to my ASP.NET 3.5 LINQ web application on the IIS 6.0 server on Server 2003.
I imagine this is because while I granted SQL Server 2005 login and permissions to my database that the application stores its data in, I did NOT grant any rights to the service account the IIS Application Pool uses for its identity to the aspnetdb database on SQL Server which is where all my roles information is stored at.
My question is what are the MINIMUM permissions needed for this database so it can perform its roles related functions?
I'm using Windows Authentications with the SQL Role provider for authorization.
 
Thank you.
 
 
EDIT: I think I only need to open the aspnetdb database and add my login to the aspnet_Roles_FullAccess role.  Is that correct?

View 2 Replies View Related

Connection Pool Leak In Production Machine (in Other Machine It Runs Well)

Nov 16, 2006

Hi to everyone,
I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.   

View 2 Replies View Related

Updating An ASPNETDB On The Production Server

Jan 29, 2007

Group,
 I have an ASP.NET web application using the default ASPNETDB that I did in VWD 2005, and deployed to a production server (IIS).
 I need to make a table addition to the production database (ASPNETDB).  I'm trying to use SQL Management Studio to attache the database, but it keeps saying the database is locked by a process.  I shut down all the services that would likely be using it, but it's still showing locked.  What do I need to shut down to attach the database to make the change?
 Or is there a better way to do it?

View 1 Replies View Related

Transferring Changes From Development To Production

Nov 27, 2000

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 ?

View 1 Replies View Related

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


View 5 Replies View Related

Managing Development & Production Databases

Jun 6, 2000

Hello everyone,

I have a question about how to efficiently develop on a development version of a database and get those changes over to the production database without loosing live data, etc.?

Here is how we are trying it:

1 Export production database to temp database(exact copy)
2 Delete production database
3 Export development database (definition only, no data) to new database with production database's name
4 Export production (temp) database (data only) over to new production shell

We are having truncate errors due to FK constraints.

Is there a better way?

Thanks for all help

Kevin

View 1 Replies View Related

Query Runs On Production And Not On Development?

Jun 30, 2014

I have two servers: one production and one development. There is a third party query that runs on both servers. Yes, the query is poorly tuned - I cannot change it. In production, it runs in 54 minutes. In development, I have tried to let it run for days and it never completes.

Here's what I have tried so far:

Compared the settings of production vs. development. The settings are very similar - the development box is larger, 4 times more memory.

Max degree of parallelism is the same on both boxes.

No compression on both boxes.

The production server is fairly busy, the development server is empty - this is the only process running on it.

Plenty of free disk space.

Updated all statistics on all databases touched by the query on dev.

Indexing is the same on both boxes.

The development box is running MSSQL2012.

The production box is running MSSQL2008R2.

What I've noticed:

The query consumes a massive amount of CPU time.

HUGE number of reads (16 million reads for 10 writes according to sp_WhoIsActive)

Largest wait types are CXPACKET, SOS_SCHEDULER_YIELD and TRACEWRITE respectively.
wait_typesum_wait_time_mspct_wait_timesum_waiting_tasksavg_wait_time_ms
CXPACKET4142765580.7176307423.5
SOS_SCHEDULER_YIELD24146944.7532725530.0
TRACEWRITE19856343.914831338.9

View 9 Replies View Related

How To Manage Development And Production Servers??

Jan 9, 2008

Hi everyone,

I really need your help!! How you manage development server and production server?

My current situation:
Our programmers develop new Stored Procedures on development server. When all testing is completed, we then deploy them to production server.

Challenges:
Programmer (Eric) modified a Stored Procedure (SP_1) on development server. He did not deploy it on production server because SP_1 is not completed yet.

Programmer (John) got request and needed to modify SP_1 on development server

So now there is a problem in SP_1. if John deploy SP_1 on production server, it will overwrite the current version and cause errors.


Anyone can solve this problem? Will it be better if we have another testing server?

many thanks

View 5 Replies View Related

Restore Production Database To Development

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

Refresh Data From Production To Development

Jul 23, 2005

Hi all, I've been assigned a task of refreshing data from theproduction env to development env.what i got is a backup file of a db in the prod env, i now need tomake that into the development env.I can restore it to the dev env no problem, but the warnings i got arethat the tables owner in prod and dev env need to be different, thatis, owner is A in prod env and owner is B in dev env.So I need to:1) restore the db in dev env2) change table owner from A to B3) change related triggers4) change related viewsCan anyone suggest me an approach that is most efficient?Thanks a lot.

View 2 Replies View Related

Development - Production Data Access

Aug 10, 2005

Hello All,I have been searching for a published document for Best Practicesconcerning access levels based on roles. Should developers have morethan (if at all) select level access to production data? If Iunderstand (from multiple postings) that it is best to have:1. Development (developers have extensive access levels)2. Test (developers have restriced access levels)and3. Production (developers have none or select level access)Our environment and budget only allows for items 1 and 3.If any body could point me to a document from a 'reputable' source, Iwould greatly appreciate it.TIABill

View 3 Replies View Related

Move Database From Development To Production

Nov 2, 2006

What's the best way to move database from development to production environment?

View 1 Replies View Related

Deploying Development Packages To Production

Aug 24, 2007



We have a system here where we develop SSIS packages on a development server. I am trying to figure out the cleanest way to promote these changes to a production server where stored procedures/tables that are used in the package are not deployed yet.

When I switch the connection in the package to the production server there are alot of objects in the package that are "invalidated" because they are trying to verify existence of tables/columns. One example is outputing the results of a query to a text file. The text file destination gets a red X on it because it cant grab the columns from the source query (because that stored procedure doesnt exist yet)

Is there a best practices or something on how to deploy packages to a production system? I have tried turning off "ValidateExternalMetaData" with no success.


Thanks!

View 3 Replies View Related

Datatype Problem: Development Vs Production Servers

Feb 25, 2006

This is driving me nuts: On my development machine the code runs fine
but generates an error on the production server. Both are running SQL
Server 2000 and ASP.NET 1.1

The datatype of the field in question is datetime.
The webform has a calendar for a user to select and automatically
insert the date into the textbox. The update command in the webform is:

 cmdInsert.Parameters.Add("@citation_date", CDate(txtDate.Text))

This works without a hitch on my development system, but on the production server it generates the following error:
Cast from string "19-12-1997" to type 'Date' is not valid.

WHY?

View 3 Replies View Related

Comparing Development, Test & Production Database

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

Database Environment Naming Production -vs- Development

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

Refreshing A Development Database With Production Data

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

Import Excel Into SQL 2005 Working In Development But Not In Production

Jul 26, 2007

I have a simple code that uses a the file upload control to read an excel sheet and upload the data into a SQL 2005db.
I'm using Visual Web Developer and Sql's express edition to test it.  It works fine when I test.  However, when I push it up to the production server and try it via the any other pc it does not.  The page loads fine.  However, when it starts to upload it errors out.
Any reason why?  I've never seen this happen.
Here's the code.  Thanks in advance. Protected Sub BtnUpload2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BtnUpload2.Click
UploadTextDocument()
End Sub

Private Sub UploadTextDocument()
Dim location As String = FileUpload1.PostedFile.FileName.ToString
' Connection String to Excel Workbook
Try
Dim excelConnectionString As String = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0", location)
' Create Connection to Excel Workbook
Using connection As Data.OleDb.OleDbConnection = New Data.OleDb.OleDbConnection(excelConnectionString)
Dim command As Data.OleDb.OleDbCommand = New Data.OleDb.OleDbCommand("Select BuilderID,SeriesID,OptionLevel,CommunityID,PhaseID,PlanID,ElevationID,OptionID,CurrentSalesPrice,LocalComments,Active,DateAdded,DateAvailable,DateInactive,SalesPriceEffective,SalesPriceExpires,PreviousSalesPrice,CutOffNotBefore,CutOffNotAfter FROM [Data$]", connection)
connection.Open()
' Create DbDataReader to Data Worksheet
Using dr As Data.Common.DbDataReader = command.ExecuteReader()
' SQL Server Connection String
Dim connectionString As String = ConfigurationManager.ConnectionStrings("HbAdminMaintenance").ConnectionString
' Bulk Copy to SQL Server
Using bulkCopy As SqlBulkCopy = New SqlBulkCopy(connectionString)
bulkCopy.DestinationTableName = "ExcelData"
bulkCopy.WriteToServer(dr)
End Using
End Using
connection.Close()
End Using
LBError.Text = "The spreadsheet was successfully uploaded."
Catch
LBError.Text = "There was an error. Check the spreadsheet for correct format."
End Try
End Sub 
 

View 14 Replies View Related

Diagrams On Development Machine

Feb 15, 2008

When 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?

View 1 Replies View Related

Data Source Deployment Best Practises Supporting Development, Test, And Production Environments

Feb 4, 2008

We are setting up a new Reporting Services 2005 enterprise reporting tier that will support multiple developers, applications, and end users. We will have mirrored environments including development, test, and production each with their own database cluster, and reporting server.

We have multiple report developers who share a single Visual Studio solution which is saved in SourceSafe and is setup to have separate report projects for each business unit in the orgainzation. Each report project is mapped to a specific deployment folder matching the business unit. Using the Visual Studio Configuration Manager, we can simply flip to the envirnoment we want to deploy to and the reports are published to the correct environment and folder structure.

My problem lies with the common data sources. We are using a single master Common Data Sources folder to hold all of the data sources. The trick is that each and every reporting folder seems to have to have it's own copy of the data source in visual studio. There does not seem to be an easy way to change the data sources for the reports when you publish to various environment, i.e. development, test, production etc.

Ideally, we would have a single project for the common data sources that all reporting projects and associated folders would map to, and we would have a way to associate the appropriate data source for each environment when we deploy.

I'm looling for best practices on how to setup data sources for development and deployment in an enterprise environment that uses Visual Studio to develop and publish reports. We have 3 environments, and 6 data sources per environment and about 20 reporting folder / project in Visual Studio. That's 360 changes that have to be manged when deploying reports. Is there a best practices way to do this?

There has got to be a better way? Can anyone give me some insite into how to set this up?

Thanks!

View 8 Replies View Related

RS - Multiple Development Environments On One Machine

Jul 23, 2005

We have multiple development environments on one machine for our VisualStudio .net projects.These are web applications so we have organized them by IP Address andHost Headers.When I installed Reporting Services, it installed into my default website (localhost) and that is fine.However, we want to be able to create our reports in our different .netprojects. The only projects that will allow me to create reports arethe projects using the default website.When I right click to create a new project, the Business Intelligenceprojects (reports) type is not there.Can I do this? If so, how do I configure it?

View 1 Replies View Related

Install DTS Packages On Development Machine

Nov 22, 2006

I would like to install the components I need to develop a SSIS custom component. Is there an SDK or install option for just the visual studio components?

View 1 Replies View Related

SQL Server 2005 - Backup For Development Machine

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

Copy Local Sql 05 DB To Production Machine

Dec 13, 2007

Hi SQL folks,
I've googled for this the whole yesterday and I couldn't find a complete solution.
I'm having a sql2005 database in my development machine and I need to copy all the content "Tables, Diagrams, PK columns and other data" to the remote production machine.
Using the Import/Export method didn't copied the relationships between tables, also it turned the PKs into just a standard columns
Can anyone help?

View 1 Replies View Related

I Changed My Windows Password And Now I Cannot Connect To SQL Server On My Development Machine

Jun 11, 2007

I changed the login password on my computer today, and now I cannot connect to the SQL Server instance I have on that same machine. I am using Windows Authentication. I would think that, if I can log on to my computer, I would be able to connect to the database, since I have been "authenticated" by windows but, that does not appear to be the case. Can anyone offer any advice? Thanks in advance for any help you can provide. 

View 4 Replies View Related

Move Sql Database From Development Machine To Server With Active Directory

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

Deployment - Cannot Acquire Connection In Production Machine

Nov 22, 2007



Hi
i can install and run my package in my development system work fine.

The same package when i was installing in the production system error

error: the acquire connection method call to the connection manager "con name" failed with error code
0xc0202009

I used sql server authentication and

tried the protection level
both encrypted password protected and sensitive with user key


Ezhil

View 4 Replies View Related

Packege Fails After Moving To Production Machine...

Oct 2, 2007

Hi everybody.
I have such problem:
After I move my integration services packege to another machine it failed. I tried to recreate connection manager, but result is the same. If I create a simple SQL task in that package and try to execute it - it fails with info:

SSIS package "Main_Package.dtsx" starting.

Error: 0xC00291EC at Execute SQL Task, Execute SQL Task: Failed to acquire connection "SRV-DSA3.TIA_EXTRACTS_OriginalData.sa". Connection may not be configured correctly or you may not have the right permissions on this connection.

Task failed: Execute SQL Task

SSIS package "Main_Package.dtsx" finished: Success.


But when I create it(SQL task) in the new package - it works perfectly. Maybe somebody could help solving this problem.

Thanks for any information.

View 4 Replies View Related

How Can I Migrate All Objects Alogwith All Constraints,SP,Triggers Etc From Development Instance To Production Instance

Jun 13, 2006

Hi fellows,

I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied.

can any body help me how can I solve this problem by copying all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance.

This is Sql server 2000 Cluster environment.

thanks in advance for any help

rahman

View 5 Replies View Related

SQL Server 2008 :: Import Table Data From Production To Development Server

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

Integration Services :: Deploying SSIS Project On Local Development Machine Failed With Error 27203

Nov 26, 2015

When deploying a project from within a SSIS project in Visual Studio 2012 to SQL Server 2012 Integration services server I get the follwoing error message:

Failed to deploy project. For more information, query the operation_messages view for the operation identifier '10'.  (Microsoft SQL Server, Error: 27203)

For the given operation id there is no entry in view catalog.operation_messages.

View 3 Replies View Related

Development Server Database Refresh From Production Server

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







Copyrights 2005-15 www.BigResource.com, All rights reserved