Wednesday, November 21, 2012

Enterprise Manager

How to copy a database using Enterprise Manager

[] = information
() = example text

Enterprise Manager > [find your database] > right-click [on your database] > All Tasks > Export Data > Next > Next >

Server: [the destination server (mssql.myserver.com) >
[select radio button] Use SQL Server Authentication >
Username: [the username for the destination database (dbm.mydb.com)] >
Password: [the password for the destination database (mypassword)] >

Next > Select "Copy objects and data between SQL Server databases" > Next >

Deselect "Use default options"
Click "Options" button
Deselect "Copy database users and database roles"
Deselect "Copy object-level permissions"

OK > Next > Next > Finish

{ "loggedin": false, "owner": false, "avatar": "", "render": "nothing", "trackingID": "UA-36983794-1", "description": "", "page": { "blogIds": [ 347 ] }, "domain": "holtstrom.com", "base": "\/michael", "url": "https:\/\/holtstrom.com\/michael\/", "frameworkFiles": "https:\/\/holtstrom.com\/michael\/_framework\/_files.4\/", "commonFiles": "https:\/\/holtstrom.com\/michael\/_common\/_files.3\/", "mediaFiles": "https:\/\/holtstrom.com\/michael\/media\/_files.3\/", "tmdbUrl": "http:\/\/www.themoviedb.org\/", "tmdbPoster": "http:\/\/image.tmdb.org\/t\/p\/w342" }