when I trying to deploy it gives me this error. t...
# orm-help
d
when I trying to deploy it gives me this error. this userID field is something very critical
r
Hey @Dulara Malindu Colombage 👋 There shouldn't be any breaking changes to upgrade. What have you added to the
userID
field while upgrading?
d
OMG!. nopz. I didn’t add anything. but noticed prisma introspect generated new data model has changed it’s field type from ID to string automatically
here is the change
r
I would then suggest to take a backup via
prisma export
then apply the changes and then import your data again via
prisma import
as described here.
d
I have a large number of data on my database. nearly 7GB. is it ok?
Or can I re change the modified string field to ID type back before deployment? will it give us future issues?
r
Yes you can change to ID (don't add the
@id
directive as that should be only on the primary key). Bug I would still suggest taking a backup first before deploying.
d
I will try deploying without @id directive.
by backup you mean prisma export and prisma import no?
r
Just
prisma export
for now so that restoring is possible in case of an error.