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 - 2001-12-16 : 11:53:26
|
| George writes "I use Microsoft SQL Server as my database.I alsohave written Stored Procedures.How do I upload thisinformation (tables + Stored Procedures,etc) tomy host server. Is it only enough to upload the .MDF fileThanks,George" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2001-12-16 : 18:33:32
|
| There are a few ways, depending on how your host wants to do it, and what they will allow you to do.1. Upload the MDF and LDF files. Then they will need to be "attached" either in Enterprise manager or using the sp_attach_db stored proc. If you are on an ISP's server, chances are you won't have access to this, you will need them to do it.2. Backup you database and have the ISP restore it on their server.3. Use DTS to transfer your objects and data across, this is probably your easiest option as you won't require intervention from the ISP.Hope that helpsDamian |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-17 : 00:02:43
|
| A fourth option is to generate SQL scripts for your database objects and then run the scripts on the destination SQL Server. NOTE that this does NOT transfer data, but only the schema.-------------------It's a SQL thing... |
|
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2001-12-17 : 00:33:20
|
| If you want to send data also as SQL scripts, check out the stored procedure I wrote, that can script your existing data in the form of INSERT statements :-) Here's the link: http://vyaskn.tripod.com/code.htm#inserts--HTH,VyasSQL Server FAQ, articles, code samples,best practices, interview questions and much more @http://vyaskn.tripod.com |
|
|
|
|
|
|
|
|
Uploading SQL Server Database to the Host Server