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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-04 : 08:51:11
|
Martijn writes "We have two servers. One of them is a Microsoft SQL server 7.0 (on NT with SP6) The other one is the server on wich the data resides (no-SQL) and is linked through ODBC. Till now we use the import-wizard to import all the data. This is done by deleting all the records in the destination table and then insert the new data.
Now we experience problems when the no-SQL server is down. The SQL-server first deletes all the data and then wants to import the new data. When the no-SQL server is down, this means the import will fail and the SQL-server has no records in the table. Is there a better way to import data, or is there a way to check the no-SQL server before deleting the records in SQL-server?" |
|
|
|
|
|
Import data