I have set up a new computer and i need my database from the old computer to owkr on my new one so that i can continue working on my project.
New computer SQL sever properties:
PRODUCT
Microsoft SQL Server Express Edition
OPERATING SYSTEM
Microsoft Windows NT 6.1 (7600)
PLATFORM
NT INTEL X86
VERSION
9.00.4053.00
Old Computer SQL Server properties:
PRODUCT
Microsoft SQL Server Developer Edition
OPERATING SYSTEM
Microsoft Windows NT 5.1 (2600)
PLATFORM
NT INTEL X86
VERSION
10.0.1600.22
I make a bak file ont the old system and try to make a new db in the new but i get this error message:
"The media family on device 'E:WEBBFININ db bakdbFinin.bak' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)"
I am currently developing a website currently in ASP.NET. I need to give the current ready website to another collaborator to continue with the work. But how do I send the database along with the website?
If this is done, what steps do I need to follow to use the database on the new machine? Do I need to change web.config or what more?
I had developed a program a few years back that stored data in an XML file. Over the years, I had accumulated about 500 or so records in the XML file. I wanted to replicate this program online using SQL as the holder of my data.
So I started developing the program using VB 2005 and ASP using the local SQL server on my computer. The first thing I wrote in my program was a piece that took the data from the XML and copied it into the SQL automatically...which was nice, made it easy. Then I continued to work on the program.
Eventually I copied everything to my online area and started running it, everything seems to be working fine so far but I'm stuck.
Is there a way to take the 500 or so records I have locally in a SQL Database and upload it to the SQL Database with the exact same structure that is online so I don't have to re-enter all these things?
is there any way to copy/transfer files directly from client to ftp server through my web application? user will select files through fileupload control.
I know you can copy a Website intact to the server and have it run normally (security and compilation time aside). What about the projects that are in the solution? [whose dll's are copied to the bin when built]. Is there a way to copy the projects' code files to the server as well?
My goal is to be able to debug [by modifying code in the project if needed] directly on the server without having to install an IDE [or keep building on dev machine and copying over dlls]. I can debug/modify the website files, but not the projects.
t1c1 t1c2 t1c3 1 1 jim 2 2 ruth 3 4 paul 4 8 sam 5 16 NA
Table2 ( Need this)
t2c1 t2c2 t2c3 t2c4 t2c5 10 1 1 jim 2010-02-03 10 2 1 ruth 2010-02-03 10 4 1 paul 2010-02-03 10 8 1 sam 2010-02-03
The tricky part I have to perform is to copy rows( only t1c2 -> t2c2, t1c3->t2c4 columns) untill I see NA(Not applicable string) in t1c3 to Table2 putting (10 in t2c1, 1 in t2c3, current date in t2c5 columns for all rows).
I have been struggling with an issue that sounds like it should be quite common but I can't seem to get the thing working no matter how much I research it!
I am using an AJAX file uploader to upload files (up to 100MB) to the webserver and when the user clicks a button to complete navigate to the next page, I then attempt to move the files off the webserver onto a file server on Page_Load. Both servers are WinServer 2003. There just isn't enough space on the webserver to hold all the uploads once we go live with this solution so I have to get the files off the webserver.
Uploading the file and creating a new subdirectory on the webserver (to hold the file) works no problem at all. When I do the file copy to our file server locally on VS2008, again, no problem. However, when I delopy to the live server and try the same thing, the upload happens ok, but the file copy does not. I get an UnauthorizedAccessException. I don't have access to the webserver myself (but can request it if absolutely necessary) and our file server sits within the same domain (Active Directory).
I do not want to use Impersonation at a high level (web.config), so I tried it programmatically for the purposes of the copy file but it did not work. I used one of our general clerical accounts to pass in the credentials and gave full permission to this account on the file server to create/modify files.
I have just used the Import and Export Wizard to copy my production SQL Server database, which uses Membership and Roles. I used the option to copy all the data from existing tables and views and did not modify the mapping in any way. Things do not seem to have gone well.....
My source database has a bunch of views with names like vw_aspnet_Applications,vw_aspnet_MembershipUsers, etc. The copy database has these listed as tables!I wondered if running aspnet_regsql.exe might fix things. I needed to run this anyway to create all the missing stored procedures for Membership, etc. However, it failed with the error:Setup failed.Exception:An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 2714 and the SqlException message is: There is already an object named 'vw_aspnet_Applications' in the database.Creating the vw_aspnet_Applications view...I am a bit lost. All I want to do is to create a total clone of my production database for test purposes. Where do I go from here?
I have created roles and users using ASP.NET configurations for login validations, it works fine if I run my application within project but when I publish my site and try to run from my Inetpub it giving this error. I tried all shorts of solutions posted in website but nothing worked for me.
"Failed to generate a user instance of SQL Server due to a failure in copying database files. The connection will be closed"
<identity impersonate="true" userName="webserverloginname" password="webserverpassword" /> sername1= username of the system password1 = passowrd of the system username2= username of the the database password2 = passowrd of the database
client system which access the database server aswell as web server
In machine XPSP2, I tried to install SQL SErver 2005 express edition (downloaded from the microsoft site) - after mode selction form (Windows/SQL server authentication) - system restarted, automatically.Again restarted, Again restarted,Again restarted,Again restarted,a 1000 times or more.finally I unplugged the system from the UPS
Currently, I am storing images and video clips in my database as a varbinary(max).
The problem is that when my front-end goes to retrieve and play the video, it takes an excessive amount of time to download.
For example, I have a video file: test.avi (5mb). If I attempt to read from database and play avi, it takes about 40 seconds. If I attempt to play this test.avi from the filesystem, it takes about 10 seconds to load.
I have investigated compression/decompression, but those seem to be as time-consuming as just loading up the raw data from the database.
Should I scrap storing video clips in the database, and go for a file system approach. I would really like to keep everything clean, secure, and organized. Which is why I am storing images, video clips, etc. in database.
i have a datable and like this i have searched a datarow from the datable on the basis of some primary now i want to add that searched row to another datatable.
DataTable findRows = (DataTable)ViewState["dt"]; List<int> selectedList=(List<int>)ViewState["selectedList"]; DataTable temp = new DataTable(); foreach (int id in selectedList) { DataRow dr=findRows.Rows.Find(id); }
now i want it to add to datatable temp how can i achieve this?
which edition of sql server are best for me Developer edition or express editon for development purpose.i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.
i need to copy the one gridview cellvalue to another gridview eg: gridview1:
a b c 1 s 2 2 v 3 3 d 4
The Second Gridview Value Should Be
a g h 1 1 2 2 2 3 3 3
but i am getting the last value 3 in each row. My Coding
ArrayList da1 = new ArrayList(); ArrayList da2 = new ArrayList(); int a1 = 0; int a2 = 0; int id=0; foreach (GridViewRow row2 in grv2.Rows) { foreach (GridViewRow row1 in grv1.Rows) { a1 = int.Parse(row1.Cells[3].Text); da1.Add(a1); da2.Add(a2); foreach (int ir in da1) { if (id < ir) { row2.Cells[1].Text = row1.Cells[1].Text; } } } }
I had an ASP.net project and I've copied and pasted the source files to another computer, but when I try and run them on this computers localhost:
Error Summary HTTP Error 500.19 - Internal Server Error The requested page cannot be accessed because the related configuration data for the page is invalid. Detailed Error Information Module IIS Web Core Notification BeginRequest Handler Not yet determined Error Code 0x80070021 Config Error This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"), or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false". Config File \?C:inetpubwwwrootmyprojmyprojweb.config Requested URL http://localhost:80/myproj/myproj/default.aspx Physical Path C:inetpubwwwrootmyprojmyprojdefault.aspx Logon Method Not yet determined Logon User Not yet determined Config Source 96: </modules> 97: <handlers> 98: <remove name="WebServiceHandlerFactory-Integrated"/>
I wanted to transfer the website I was creating on my PC to the laptop so I can show it to other people, but when I try to start the copied website I get the following error: "Make sure that the class defined in this code file matches the 'inherits' attribute, and that it extends the correct base class (e.g. Page or UserControl)." File is: MasterPage.master.cs and the Line is: 1.
As the website on my laptop is the exact copy of the website on my PC I don't understand what the problem is and why did it happen.
Am I doing something wrong? Is there any other way of transferring website from one PC to another. I have to add that the website is running on localhost.
I am adapting a script I used for copying a CD on a local machine to work on a website. It works only if the CD to copy is physically in the server. This is not ideal as I would like the CD for copying to be in the client CD. So what would be an effective way to have the app point to the client CD drive instead of the server CD drive?
I have two data tables and I need to compare the dataRows and insert all the unequals into a table. See the codes below. Goal: if the checkbox is true I loop through the ItemData table and store that data into x.Data. Next I look for all records that has row("ItemRandomize") = True and finally I add those records to xData table. There is an if statement in my for loop that checks for duplicate records -- This is were the application fails. How to compare both tables and store the unmatched rows. [Code]....
I was looking for any way to create web page,so that user wont be able to copy content from my web page. i.e. User wont be able to select the any text present on the webpage. Let's assume i am working on asp.net
i want to copy the entire folder along with its contents from the client machine to the server where the application is deployed. i am using asp.net 3.5.