Click here to Skip to main content
Rate this: bad
good
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 18:38pm

1 solution

Rate this: bad
good
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
  Permalink  
v2
Comments
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 OriginalGriff 410
1 Gihan Liyanage 338
2 ChauhanAjay 180
3 Vinay Mistry 160
4 Sergey Alexandrovich Kryukov 138
0 Sergey Alexandrovich Kryukov 9,011
1 OriginalGriff 7,941
2 CPallini 2,603
3 Richard MacCutchan 2,121
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web03 | 2.8.140827.1 | Last Updated 28 Nov 2012
Copyright © CodeProject, 1999-2014
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