|
|
transfer database to new server |
|
Author |
Message |
jta
|
Posted: Sun Dec 12 20:01:19 CST 2004 |
Top |
SQL Server Developer >> transfer database to new server
What is the easiest way to transfer a database over to a new server? I've
used DTS but have to go back and fix the ID fields from decimal to numeric.
That's a pain! I've generated the create table script, created the table on
the new server then transferred data. That was OK, but to do that for twenty
plus tables is a huge pain! Is it possible to generate the create table
script for all tables in one pass? Beyond all these issues, I've user and
permission problems.
What is the easiest way to get all tables, data, and stored procedures over
to the new server?
thanks
SQL Server105
|
|
|
|
|
ijustok
|
Posted: Sun Dec 12 20:01:19 CST 2004 |
Top |
SQL Server Developer >> transfer database to new server
backup database and restore it on new server!
> What is the easiest way to transfer a database over to a new server? I've
> used DTS but have to go back and fix the ID fields from decimal to
numeric.
> That's a pain! I've generated the create table script, created the table
on
> the new server then transferred data. That was OK, but to do that for
twenty
> plus tables is a huge pain! Is it possible to generate the create table
> script for all tables in one pass? Beyond all these issues, I've user and
> permission problems.
>
> What is the easiest way to get all tables, data, and stored procedures
over
> to the new server?
>
> thanks
>
>
|
|
|
|
|
shank
|
Posted: Sun Dec 12 20:35:49 CST 2004 |
Top |
SQL Server Developer >> transfer database to new server
I'm not sure that's possible on a shared SQL server. I have limited access.
Forgot to mention that...
thanks!
> backup database and restore it on new server!
>
>> What is the easiest way to transfer a database over to a new server? I've
>> used DTS but have to go back and fix the ID fields from decimal to
> numeric.
>> That's a pain! I've generated the create table script, created the table
> on
>> the new server then transferred data. That was OK, but to do that for
> twenty
>> plus tables is a huge pain! Is it possible to generate the create table
>> script for all tables in one pass? Beyond all these issues, I've user and
>> permission problems.
>>
>> What is the easiest way to get all tables, data, and stored procedures
> over
>> to the new server?
>>
>> thanks
>>
>>
>
>
|
|
|
|
|
Andrew
|
Posted: Sun Dec 12 21:40:34 CST 2004 |
Top |
|
|
|
|
|