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 |
|
t_a_k_2002
Starting Member
1 Post |
 Posted - 2006-03-06 : 03:55:07
|
| hello every body, I am tryin to develop import export utility like that is provided with SQL Server 2000,it would be useful when there will only MSDE is installed. I cant use SQLDMO`s Back up and Restore functionality as it is for local Instances. I tryin to use link server way but struggling use with all databases. I am not able to import data from database to given database.What r other possible ways of doing the above?regardstak |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-06 : 08:54:13
|
| bcp is a good option. It's low-level, easy to use, and supported by every currently available version of MS SQL Server and MSDE. David has a nice GUI app for it here:http://weblogs.sqlteam.com/davidm/archive/2004/03/31/1151.aspxYou can also use the DTS COM library to do all the things that DTS provides, however I don't think the DTS library comes with MSDE, and I'm not 100% sure whether you can redistribute it. |
 |
|
|
|
|
|
Developin Import Export tool