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 |
|
eem_2055
Yak Posting Veteran
69 Posts |
 Posted - 2007-11-07 : 06:22:04
|
Hey guys!!We'll going to migrate into our new system. Then we'll going to extract data from our old database. My problem now is the fieldnames that the new one is different from the old one. I need to extract the data that we have before into TEXT files using the file format that the new one has. May I know what process that I can do for data extraction into Text files that can be used in the new one.\ |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-11-07 : 07:06:04
|
| Is your old database also SQL Server dataabase? If yes, is it on the same server?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-11-07 : 07:36:43
|
| Yes it's SQL server.Is there anyway to convert our old to new one? But using different fieldnames? |
|
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2007-11-07 : 08:18:18
|
| why cant u take a backup of the old database and restore in new one and then rename the fields.RKNAIR |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-11-07 : 08:27:00
|
| Simplest option would be to use DTS/SSIS. Also you can use BCP/Bulk Insert depending on data size.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-11-08 : 06:31:29
|
acn you help me on using the DTS and transforming it into Text files.quote:
Originally posted by harsh_athalye
Simplest option would be to use DTS/SSIS. Also you can use BCP/Bulk Insert depending on data size.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
|
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2007-11-08 : 07:40:55
|
| DTS has a wizard you could run if you aren't familiar with it - In Enterprise Mangler go to Tools and Data Transformation and then Export Datasteve-----------Don't worry head. The computer will do all the thinking from now on. |
|
|
|
|
|
|
Data Extraction