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 |
|
meareal
Starting Member
21 Posts |
 Posted - 2006-11-01 : 10:30:13
|
| Does anybody know what "free" tool I can use to export data from an MSDE database? I want to import it back to SQL Server |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-11-01 : 10:34:35
|
yes BCP
KH |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-01 : 10:40:38
|
backup/restore?bulk insert?Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
meareal
Starting Member
21 Posts |
Posted - 2006-11-02 : 09:21:19
|
| Thanks guys. Still trying to work out a few things. I ended up with a DBK file. This seems to be a dBase file that I am trying to import into SQL Server... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-02 : 09:38:11
|
| what's dBase has to do with MSDE and sql server??Go with the flow & have fun! Else fight the flow blog thingie: http://weblogs.sqlteam.com/mladenp |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-11-02 : 09:42:40
|
"I ended up with a DBK file."meareal, You did a database backup and named the backup file xxx.DBK is it ? If it is, just use Enterprise Manager (SQL 2000) or SSMS (SQL 2005) to perform the restore and select the file that DBK file.
KH |
|
|
|
|
|
|
Exporting data from MSDE