|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
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
April 30th, 2004, 08:45 AM
|
|||
|
|||
Copy data from SQL server 1 to SQL server 2?
Hi folks,
I am new with MS SQL, please help me out. I have set up two MS SQL servers. I have tested data with one server, and I would like to copy the data (only two rows under one table) at server #1 to the other server. Please show me how to do it? Thanks, Vu
|
|
#2
May 3rd, 2004, 01:04 PM
|
|||
|
|||
|
You could do this by right-clicking on the table in Server #1 and choosing All Tasks --> Export Data. This will bring up your DTS wizard, which will (should) automatically fill in your data SOURCE (server #1) and then you'll be asked to fill in information for the DESTINATION (server #2). Continue through the wizard, it is pretty self explanatory.
Hope that helps.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Copy data from SQL server 1 to SQL server 2? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
