Import database from local system to server system

[pavanip]

Hi,

I have a problem with database.For my application i am using .net and sql server 2000. i am having database for my application in my local system.if i shutdown the system database is not working.i tried to import database from local system to server system.but it is not woking properly.is there any solution to import database.Please help me.

Thanks
pavani

[ck9663]

Your post is too generic.

But yes, there's a way. You have to install SQL Server on that server machine, backup your local database and restore it on the server machine.

You might also need to change your connection string to point your app to your server machine.

-- CK

[pavanip]

ok.thank you.I got the solution to my problem by using the following steps.

Sql Enterprise Manager,Right Click On Database SELECT Properties->Datafiles(Tab)->See th location of ur database and go to that location and find .ldf and .mdf files there now stop sql server running on ur machine and copy those files(.ldf,.mdf) now start ur Sql Server now go to ur actual server(Destination) system ,now create a folder any where on that Suppose on D:\\Database now paste these(.ldf,.mdf)files there and open Sql Enterprise Manager on that system and select Databases folder right clck on that All Tasks->Attach Database->click brose button(...)->select the mdf file(D:\\Database\\xxx.mdf) and say ok.