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 |
|
Tartakovsky
Starting Member
6 Posts |
 Posted - 2005-08-01 : 08:16:39
|
| i want to select various fields from a table in the database in my local SQL server and insert that record into a table in a database in pervasive SQL V8 on another server. Can someone help me with this? All i've managed so far is to export an entire table from SQL server to pervasive SQL |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-01 : 08:30:32
|
| Import/Export wizard or DTS will do thisMadhivananFailing to plan is Planning to fail |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-01 : 09:12:48
|
| linked servers?====================================================Regards,Sean RoussyGENERAL ADVICE FOR EVERYONE: Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
|
|
|
passing record from MS SQL server to Pervasive SQL