hi viewers pls helpme...
how to move/copy a database from one sqlserver to another sqlserver,
if u have any idea pls post..
thanks in advance..
hi viewers pls helpme...
how to move/copy a database from one sqlserver to another sqlserver,
if u have any idea pls post..
thanks in advance..
In Ms'SQL Enterprise Manager, u have a tool to export all the database into a file and then after that u can import the same file into another sql server, U'll have something i like Tools -> Export Database or something, im not sure about the flow, but pls find out in then enterprise manager, u'll surely find it
All the metadata,tables, sequences everything will be exported
As i dont have the SQL server on my machine i could not tell u the exact steps, but u can, coz i knew i have done it once
Let me know your questions
Thank You
hello mohan..
i did it successfully with the option restore database...
tanx for ur help
heelo
There are currently 1 users browsing this thread. (0 members and 1 guests)