I have created a database using 2014 Express on my local machine. I now need to move that database to our company's server which will be using full blown 2014 Standard.
I would like to know the mechanics of doing this. I see there is an export and restore in SQL Management studio but it looks like there are two additional tools separate of SQL Management Studio that installed with SQL MS; Deployment Wizard and a Project
Conversion Wizard.
What is the proper and most efficient way to move this entire database from my local machine to the server?
It seems that this should be a fairly routine occurrence but I could not find a KB article or paper on it, but the MS document and forum library is vast, so I might be over looking it.
Thanks in advance.
Go to the complete details ...