I am trying to migrate from SQL SERVER 2012 to 2014 and found out I cannot use .bak files because of different versions. I know how to create a .sql back up file using the SSMS but I can't find a solution using a script or sqlcmd.
-
1It is allowed to restore database from .bak file from loewer version to higher version of sql server. Did you try it, what was the error you get ?Md. Suman Kabir– Md. Suman Kabir2018-02-22 08:46:21 +00:00Commented Feb 22, 2018 at 8:46
Add a comment
|
3 Answers
turns out I could use .bak files to restore databases. The problem was I'm trying to restore the file from a directory that SSMS is not authorized. Was a silly mistake. Sorry.
Comments
If you require to get the data in .sql files then the SQL Server's Generate Scripts wizard is the best option otherwise you can create .bak of your database and restore it on higher version.
1 Comment
Vladislav Borovikov
but first you need to install SSMS... Do you know a way to do it using command line tools only?
Why can't you use SSMS?
Exporting to .sql file has been discussed in How to backup Sql Server to sql file?
Did you consider Linked Servers? You can use 3 and 4 part names to access data from one server to another, for details see How can I connect to an external database from a sql statement or a stored procedure?. Another alternative to access data is trough OPENROWSET, that is also discussed above.
