Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying DB to new DB
Message
 
To
20/08/2001 09:53:41
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00546171
Message ID:
00547228
Views:
10
>>Hello,
>>
>>I'm trying to dublicate one database by exporting data into new database.
>>But I'm getting error, that export failed and in log file there written same lines many times:
>>
::Error::
>>Transfer Status: Transferring Data: (Table '[dbo].[theTable]')
>>  Data truncation occurred in table [dbo].[theTable], column 2.
>>What wrong with this table?
>>What I should do?
>>Thanks.
>
>Sounds like the column is not big enough to receive the source data from the original column.
>
>As an alternative, you can use the DTS wizard (Import/Export) to copy all objects from one db to another by selecting "Copy Objects/All Objects". You can save this as a script if you want to run it on a schedule.
>
>HTH

But i was using DTS wizard and it fails! :(
Giedrius
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform