I need to Transfer my DATABASE using Installer

[urchandru1]

I need to Transfer my DATABASE using Installer

1. I Tried to Restore using RESTORE LDF and MDF file , its working when i install from Server it fails when i install it from Client machine ,since the server path and our local path
2. I Tried with BULK Insert I faced same ISSUE in Copying Data file.
3. I Tried by Generating INSERT Queries for it contains nearly 14,000 lines ., it take huge time (nearly 12 mins) .

IS there Any Solution TO JUST COPY MY SQL DATABASE To CUSTOMERS SQL SERVER.

[GabrielBarbu]

Hi,

Exporting your database is the proper method of moving it to another server. It is normal for the install to take that long considering the size of your database. If you still think you need a faster install then you can try copying the database file(s) and installing them directly via the "Files and Folders" page onto the client's machine. However the process is cumbersome and error-prone since there is no guarantee that the database will be properly installed into the new servers. Simply copying the database file in the proper location may not be enough, registries might need to be added, files edited etc.

Regards,
Gabriel

[jkrobin]

I too tried the steps what urchandru said.,
why its taking this much time ., since SQL query analyser excutes faster .,

here also it takes time before Excuting the Script.,
Status showing "GENERATING ACTIONS TO CONFIGURE DATABASES FOR INSTALL SQL SCRIPT EXEC..."

[urchandru1]

Finally I found the Solution,
I Generated INSERT Query using "Microsoft SQL Server Database Publishing Wizard"
Again I Splited this files with the 1000 Lines

now it takes only 1 minute to install.
before Spliting it takes 12 minutes.