How to do database migration in Sql server?
i need basic and step by step instruction.....
Please help me
Thanks in advance
The easiest method is to use Generate Scripts under the database task menu. If the database is huge you'd want to generate a schema only copy first then import the data. Otherwise you can import the data and schema at the same time.