|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
|
|
|
|