transfer database to new server  
Author Message
jta





PostPosted: 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





PostPosted: 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





PostPosted: 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





PostPosted: Sun Dec 12 21:40:34 CST 2004 Top

SQL Server Developer >> transfer database to new server
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers

--
Andrew J. Kelly SQL MVP




> 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
>