search

chucknorris / roundhouse

RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
http://projectroundhouse.org
917 stars 249 forks source link

Support SQL 2014 and 2016? #322

Closed johnxjcheng closed 5 years ago

johnxjcheng commented 6 years ago

When upgrading the databases that use RoundhouseE, we get this warning: Object RoundhousE.ScriptsRun.text_of_script uses deprecated data type TEXT, IMAGE or NTEXT which will be discontinued for future versions of SQL Server.

Any timeline to support the new SQL version?

erikbra commented 6 years ago

We could probably just change it to VARCHAR(MAX), but I don't know if that would break compatibility with older SQL Server versions. However, it is only a warning that it might be removed in future versions, so there is no acute danger for it to stop working.

Are you experiencing any issues other than the warning?

johnxjcheng commented 6 years ago

No, there is no other warning. If the upgrade can be scheduled in the near future that will be great. Microsoft is stopping the support of SQL Server 2008 soon.

BiggerNoise commented 6 years ago

Just to be clear, when Microsoft stops supporting SQL Server 2008, that doesn't mean that TEXT is going away also.

But, it could at some point in the future and we should update our schema to accommodate this. Thank you for bringing it to our attention, I had no idea that they had deprecated the type. I'm sure that will be a popular decision with their users.

And curiosity question, I see that you're in Plano. Are you the John Cheng that works/worked for MedAssets (or whatever they're called these days)?

johnxjcheng commented 6 years ago

Hi, Andy. This is the John Cheng who worked with you before. Nice to meet you here! I understand the definition of deprecation and appreciate your consideration to address it in the future.

John Cheng

BiggerNoise commented 6 years ago

Good to see you also.

We're trying to get a cross platform .NET core version of RH baked, so @erikbra and I are a bit busy at present, but I hope that we can address this shortly after.

johnxjcheng commented 6 years ago

Appreciate your hard work to benefit the community. Please fix you donation link as well. It shows error: "This recipient is currently unable to receive money."

ferventcoder commented 6 years ago

@BiggerNoise please fix the donation link to some location for you and @erikbra. You are doing amazing work, so make sure that goes to you - I forgot to remove it here when it stopped working over a year or so ago.

LarsAndreasEk commented 3 years ago

Hi,

Any updated plans to change from TEXT to varchar(max) for columns?

Best regards Lars Andreas