coping data in sql server express
-
Hi All, Im using Sql server Express 2005, in the client place. i want to copy the database with all data and put it in my sql server express 2005 in office. so plz help me how can i do this how can i copy entire data from sql server express and put it in another sql server express Thanks for ur valuable help With Regards Amjath
-
Hi All, Im using Sql server Express 2005, in the client place. i want to copy the database with all data and put it in my sql server express 2005 in office. so plz help me how can i do this how can i copy entire data from sql server express and put it in another sql server express Thanks for ur valuable help With Regards Amjath
-
thanks for ur quick and valuable reply. can u plz explain me how to do that. sorry for disturbing u With Regards Amjath
-
thanks for ur quick and valuable reply. can u plz explain me how to do that. sorry for disturbing u With Regards Amjath
-
Just stop MSSQL Service then locate where are files copy them and restart again MSSQL Service In your office open SQL Server Attach Database[^] by findinf file of MDF extension.
I Love SQL
Actually detaching the database would be the first step. In ServerManager just right click on the database, click on tasks and then detach. I would first get the location from the properties of the ldf and mdf before detaching. Copy those files and move them to where you want, reattach on the database detached from and on your other database. The only other issue you might have is table ownership. Occasionally the mapping gets a little off and has to be justified.
_____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at GISDevCafe
-
Actually detaching the database would be the first step. In ServerManager just right click on the database, click on tasks and then detach. I would first get the location from the properties of the ldf and mdf before detaching. Copy those files and move them to where you want, reattach on the database detached from and on your other database. The only other issue you might have is table ownership. Occasionally the mapping gets a little off and has to be justified.
_____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at GISDevCafe