Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-30 : 08:00:40
|
| eli writes "I develope an asp website on my localhost using sql server database and I have populate it table with data and image and links/path to wordfile, now I want to Upload Sql database to website, how do I do that ?I know how to upload my asp pages, but How can I upload my sql database and keep all the connection between the table and all field trigger in placethanks" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-08-30 : 08:46:15
|
| Uh, Houston, I think we have a problem here. Eli, you don't really upload sql databases, they're pretty much a static item. So you've created some asp pages and uploaded them, great, now you need to decide where you're going to point those pages to. What instance of sql server exists in production that you can run your database on. It sounds like you've got everything pointed at your local computer which is fine for now, but you definitely do not want to do this in a production environment unless you're always going to leave your computer plugged in and on. So, you'd need to move your database to somewhere in your production environment. The easiest way to do this is to create a full backup of it, copy it to your production server and then restore it. I'm not going to get into all the code for doing that in my reply, you should read in Books on Line how to do this. Once you've done that and have it running in production you need to revisit your asp pages. Somewhere in there you would have had to define a connection string which poinsts to your local computer. You'll need to change this connection string to point to your newly created database in production.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
|
|
how do I Upload Sql database to website