Good morning,

We are still having issues with this... we created a self signed certificate and when we go to import it into configuration manager, the application just closes and exits......

• This reply was modified 4 months, 3 weeks ago by  amy26.

Now I got a PFX certificate file and when I go into SQL Configuration Manager and try to import it, it spins for a bit and then crashes the program.......

• This reply was modified 5 months ago by  amy26.

Ok I apologize I seem to be having issues communicating on the forums.

My first question is why SQL Server won't recognize the DoD certificate that I'm trying to import... I...

Thank you.

Ok thank you for the correction.

So, can I accomplish what I want to do by simply creating the new table with the varbinary(max) field set without the filestream and inserting...

I understand it is storing links to the files and they are stored on the filesystem as part of the filestream filegroup.  I understand that the APIs and UI interface...

It is an EC2 in AWS.  SQL Server 2022 Standard Edition.

Could it be the file type of the certificate?  In configuration manager it expects the files to be PFX, PEM...

• This reply was modified 5 months ago by  amy26.

Thanks Ratbak, yes that is basically it in a nutshell.  The developers have analyzed the code and moving to oracle doesn't impose much of a challenge supposedly.

I did use Steve's...

Ken,

Not sure why it won't let me quote anyone... how are you guys putting the quotes in the responses?

Moving to Oracle actually won't require much code change as long as...

Perry,

Sorry but you said "developer will work".  Now I'm totally confused again... I have read things... nothing says ANYTHING about how to migrate this data.  It tells me how to...

So, just to be clear... if I create a brand new table with a varbinary(max) column and then insert the data from the filestream table into that table, I can...

Thanks Steve,

Forgive my ignorance... but the filestream datatype is varbinary... if I create another table with a varchar(max) data type and insert the data into the new table ... how...

Reply to Ratbak:  How does this work with keeping the primary key references?  If I just export the files, how do I know what their primary key values were?

• This reply was modified 5 months ago by  amy26.

The customer does not want to spend money on code changes really.... so I have to keep everything basically the same but get rid of filestream and move to either...

Thank you, I read all that... it didn't really tell me how to do what I wanted. 🙂   I also can't figure out why the .pathname method throws an error...