473,395 Members | 2,713 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

How to transfer from local to remote host a .mdf file and membership ASP DB?

2
I am having so much problems with the deployment of my site from local to remote host. My asp site (c#) has (in the APP_DATA folder) an .mdf db file and membership file as well, and both need to be deployed. Is there any simple strait forward solution to this? Are there any tutorials? I spent 2 days in vain. The available info is disjointed, confusing and make me feel like an... Please guys, any honest answers?

pss: why can not Microsoft make it as "they say" 1 button solution?
My host accepts only mssql and mysql. I created the mssql db with same name- but know what? How to use reg.sql.exe, how to use remote IIS from my local pc, or visual studio- how do they all come together? I'm lost. help, please!
May 14 '12 #1
3 2779
jhardman
3,406 Expert 2GB
a MSSQL db should have two files - .mdf and .ldf I believe. did you get both?

My host says they support MSSQL, but I can't just send my db over to them, I have to set up the db through their interface.

Jared
May 14 '12 #2
lamass
2
yes, I have both files- but do not know how to get them to my remote host. Basically after I create the db at my host how do I transfer my local db to the remote host? It has been such a struggle for such an almost menial task (that should be automatic).
May 14 '12 #3
jhardman
3,406 Expert 2GB
yeah, there is no easy way to do this. MySQL has a handy "export" feature that converts the entire contents of the table into a plain text sql insert statement(s). For MSSQL the only solution I have ever found is to take a backup, then create a blank db in the second location with the same name, then restore the backup (with replace) then re-assign all the users.

Jared
May 14 '12 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Johann Blake | last post by:
I am using the TcpClient to connect to a web site. I then open a NetworkStream and read the contents that are being sent back. The problem is that I have no idea when the remote host is finished...
0
by: Nuno Magalhaes | last post by:
Hello all, I'm capturing the screen to a file (C:\output.wmv) as video source but now I have a big problem: How can I get the output sent to a remote host instead of a file? And, by the way, how...
2
by: Peter White | last post by:
I am trying to transfer a file from a user's local machine (the file is automatically created by a 3rd party tool and stored in the users local settings/temp directory) via a web form to my web...
2
by: Jeff | last post by:
I have an ASP.NET web page accessing a SQL database. I've used VS to build the app and stored it in the eNPTest02 directory of my localhost on my development machine. The database is on the web. ...
0
by: Mike | last post by:
VB .NET 2003, Pocket PC 2003, CF 1.0 SP 2 Only when I use a proxy server, I'm getting this error when attempting to write data to a Stream object from an HTTPWebRequest object....
4
by: techsupport | last post by:
I have some experience with .NET Remoting, as well as ASP.NET 2.0, and have been wanting to remote a custom membership and profile provider. I want to take advantage of the new controls in ASP.NET...
4
by: cpptutor2000 | last post by:
Could some C guru help me please? I am using the following program to open a SSH connection to a remote host and eventually run a program on that remote host. #include <stdio.h> #include...
1
by: dodobird | last post by:
Hello, I am sorry if this is not the correct forum for this post. I am looking for a tool for Windows, that can do file transfer to remote machines ( running windows as well ), and also do remote...
4
by: Vicente García | last post by:
Hello!! sorry for my english, I've made an application that ran correctly for 3 days, It's a service, however in the third day the application failed because of "An existing connection was...
1
by: malooga | last post by:
Hello, I'm having a problem connecting to DB2 on a remote iSeries host from a Linux server, both of which reside on my company's internal network. I'm using the IBM Linux Client V9.1. When I try...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.