Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying DB to new DB
Message
 
À
20/08/2001 09:53:41
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Divers
Thread ID:
00546171
Message ID:
00547228
Vues:
16
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform