| Author |
 Topic  |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
 Posted - 29 April 2004 : 02:36:49
|
Hi, I have sql server developer edition, the one that they ell on microsoft.com for $50. ok... I was wondering if with it I can create a sql db and export my current site's sql db into it and remain the same properties so that when I move to different sql server I could just import and everything would work without changing stuff around like I did before import access into sql. If this is possible, can someone show me the steps on how to create a sql db on my computer and then export the sql db on the server and everything come out alright, or would I still have to do the same stuff when I import it again?
Thanks!
WWS |
coaster crazy |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 29 April 2004 : 18:35:39
|
For the most part yes. You want to connect with an OLEDB connection, not an ODBC connection, and choose to copy objects & data, not copy tables.
Then, in the options of the DTS job you probably want to set the options not to copy users and object permissions (you'll get errors if you don't have identical logins and users on both servers)
To make this happen, open Enterprise Manager and connect to your local server. Under databases, create a new database for your copy. Open DTS (one way is to right-click on the new database and choose all tasks-import). Create an oledb connection to your remote server as the source, selecting your database of course. Then let your local db be the destination. Then copy objects & data, make the option changes, and have some snack if it's a large db.
If you're running the sql agent, you can save this dts job and schedule it to run on a regular schedule.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
 |
|
| |
Topic |
|
|
|
Topic Locked
