Click here to Skip to main content
12,358,497 members (62,124 online)
Rate this:
 
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 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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 28 Nov 2012
Copyright © CodeProject, 1999-2016
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