| |

VerySource

 Forgot password?
 Register
Search
View: 997|Reply: 5

How to solve the timeout problem when the field type is changed from ntext to text

[Copy link]

1

Threads

2

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-10-19 12:00:01
| Show all posts |Read mode
Change the field type from ntext to text. I have now converted all the tables with less data, but the ones with large data are wrong.
Reply

Use magic Report

0

Threads

114

Posts

69.00

Credits

Newbie

Rank: 1

Credits
69.00

 China

Post time: 2020-10-19 12:15:01
| Show all posts
What conversion statement do you use?
Reply

Use magic Report

0

Threads

14

Posts

13.00

Credits

Newbie

Rank: 1

Credits
13.00

 China

Post time: 2020-10-19 12:30:01
| Show all posts
Try it like this:
Convert fields while copying with DTS
Modify the field type of the destination table in the "Column Mapping and Conversion" step
Reply

Use magic Report

1

Threads

2

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

 Author| Post time: 2020-10-19 12:45:01
| Show all posts
Useless statement conversion directly modified in the database
Reply

Use magic Report

1

Threads

4

Posts

4.00

Credits

Newbie

Rank: 1

Credits
4.00

 China

Post time: 2020-10-19 15:00:01
| Show all posts
Conversion prompt error


"Dv_bbs1" table
-The table cannot be modified.
The timeout period has expired. The timeout period elapsed before the operation was completed or the server did not respond.
Reply

Use magic Report

0

Threads

1

Posts

2.00

Credits

Newbie

Rank: 1

Credits
2.00

 China

Post time: 2020-10-19 22:30:10
| Show all posts
You can click the option when you open it, there is a connection time setting, the default is 15 seconds
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list