Click here to Skip to main content
11,478,174 members (69,542 online)
Rate this: bad
Please Sign up or sign in to vote.
Hi All,

Can anyone tell me how to copy local database on remote server(Client).
I am using sql server 2005.
I have created database on local server but not able to export it. I do not get "Export" option in task.
What to do?
Posted 27-Nov-12 19:38pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

1. Backup locally and restore on server
2. Make dump and execute it on server. Right click on database -> Tasks -> Generate scripts
if you want data to copy as well then need to specify "Types of data to script" option as Data and Schema
Sweetynewb at 28-Nov-12 1:47am
I have generated script file which include-table creation and stored procedures
but "generate script" does not give data stored in tables?
What should i do?
Nelly2k at 28-Nov-12 1:49am
Sorry, type of the script: Data and schema, this case data will be included in dump

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 219
1 F-ES Sitecore 170
2 Sascha Lefèvre 170
3 Frankie-C 110
4 OriginalGriff 95
0 Sergey Alexandrovich Kryukov 7,675
1 OriginalGriff 7,321
2 Sascha Lefèvre 3,034
3 Maciej Los 2,491
4 Richard Deeming 2,325

Advertise | Privacy | Mobile
Web01 | 2.8.150520.1 | Last Updated 28 Nov 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100