|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 11th, 2004, 02:28 AM
|
||||
|
||||
MS SQL-exporting to remote server?
I know this is not the section for database questions, but i asked over there and i dont think they know.
 ok i made an operational database on my computer and it works with my ColdFusion programming but i just purchased MS SQL server ability from my hosting company and they gave me a URL to which i must export my database to. So how do i export my database to this URL? (ie. export my finished database to "sqdb.hoster.com" thx
|
|
#2
October 11th, 2004, 02:22 PM
|
||||
|
||||
|
I've had this same problem a few times and found that the easiest way is to first export to Access, then import the Access table(s) into the new SQL.
You'll have to fix a few things, but most of your formatting will remain. The only other choice is to build a ColdFusion (or whatever) page that SELECTs and INSERTs all your data automatically through lots and lots of queries. This can get really messy though. Hope that helps.
|
|
#3
October 12th, 2004, 05:34 PM
|
|||
|
|||
|
That's what I've been doing to, to transfer from MS SQL to MySQL. It's worked well, but I haven't tried it with complex tables.
However, with MS SQL to MS SQL, you should be able to restore from backup.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > MS SQL-exporting to remote server? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
