Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying DB to new DB
Message
From
22/08/2001 10:12:24
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00546171
Message ID:
00547246
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! :(

Is the source DB a SQL Server database? If it is, you can also backup / restore to and from a disk file. But if it is a SQL db it doesn't make much sense that copying objects gives this error message.
Previous
Reply
Map
View

Click here to load this message in the networking platform