|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#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
