I have SQL Server management Studio 18. I have built a database therein.
I need to be able to move that database, named MATERIALSSQL to a different version of SQL.
I do NOT know the version of the receiving software.
Should I export? If so, how is it done? I have tried Tasks>Export Data. No matter which Datasource I select, I get the following error:
"The operation could not be completed. Additional information: - "
I have made a .bak backup file, but am not sure this will work. I need to get the database onto a thumb drive and to another computer by Monday.
I could use all the help I can get. 30 years experience with Access, practically none with SQL.
Thank you in advance.