Several ways to do this, options include using SSIS package, an OPENROWSET from destination, downgraded SQL Server import then upgrade and few more. Without more knowledge of the schema, constraints etc. it is hard to recommend any specific method, but as mentioned earlier, quite few options are available. 😎