We have a database with test data in it the Dev environment we used to develop. and another DB in production, I want to refresh only the schema from production to Dev environment, but I need all the data that is in Dev environment.
Is there a way to copy the database schema alone from Production and refresh the schema in Dev without losing the Dev environment data?.
Any help gratefully received.
You could try using schema compare from SQL Server Data tools.