Mpearson
-
Total Posts
:
6
-
Reward points
:
0
- Joined: Sep 05 '02
-
Status: offline
|
Moving the forums
Tue. Apr 1, '03 3:20 PM
( permalink)
I am looking to change service providers and I would rather not lose all my messages/configs etc. How does one go about moving the SQL side of this?
|
|
|
|
Bruce Lee
-
Total Posts
:
76
-
Reward points
:
0
- Joined: Jun 15 '02
-
Status: offline
|
RE: Moving the forums
Tue. Apr 1, '03 3:25 PM
( permalink)
You can use DTS to export the data to another database on your new host. For more information on DTS, please see SQL Books Online and search for DTS.
Bruce Lee
ASPPlayground.NET Custom Software Developer
|
|
|
|
Mpearson
-
Total Posts
:
6
-
Reward points
:
0
- Joined: Sep 05 '02
-
Status: offline
|
RE: Moving the forums
Tue. Apr 1, '03 4:02 PM
( permalink)
SQL Books online? got a URL?
|
|
|
|
Bruce Lee
-
Total Posts
:
76
-
Reward points
:
0
- Joined: Jun 15 '02
-
Status: offline
|
RE: Moving the forums
Tue. Apr 1, '03 4:29 PM
( permalink)
" SQL server books online" is the help file that comes with SQL server package. You can access it by clicking on the ? button in Enterprise Manager.
Bruce Lee
ASPPlayground.NET Custom Software Developer
|
|
|
|
Mpearson
-
Total Posts
:
6
-
Reward points
:
0
- Joined: Sep 05 '02
-
Status: offline
|
RE: Moving the forums
Tue. Apr 1, '03 7:12 PM
( permalink)
Ok but now i am getting errors.. I ran the full-install SQL scripts on the new SQL server to make sure the stored procedues etc got installed, then I tried to pop the data from the tables over from the old site. I get 11 tables that fail due to duplicate index or something like that.. thoughts?
|
|
|
|
Bruce Lee
-
Total Posts
:
76
-
Reward points
:
0
- Joined: Jun 15 '02
-
Status: offline
|
RE: Moving the forums
Wed. Apr 2, '03 4:26 PM
( permalink)
The answer is available inside the privae forum.
Bruce Lee
ASPPlayground.NET Custom Software Developer
|
|
|
|