Re: transfer database to new server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 12/13/04 

Date: Sun, 12 Dec 2004 22:40:34 -0500

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
"shank" <shank@tampabay.rr.com> wrote in message 
news:unmBjML4EHA.2016@TK2MSFTNGP15.phx.gbl...
> 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
>

Relevant Pages

  • Re: SQL Server does not exist error
    ... I clicked on Connect to a Database and then expanded ... I then expanded SQL Servers ... try to expand the latter, I get the SQL Server Login screen. ...
    (microsoft.public.vb.database)
  • Re: Copying Databases
    ... The win2k server is ... Copy Database Wizard in EM is quite nice. ... You can transfer logins using DTS ... For jobs and other things, ...
    (microsoft.public.sqlserver.server)
  • Re: Rolling out structural changes to a distributed SQL environment
    ... We pop a job on all the destination SQL servers that execute a payload. ... > script that pushes a job and set of scripts out to each server. ... this is a poor man's solution in the absence of a fancy tool. ...
    (microsoft.public.sqlserver.replication)
  • Need assistance settings up replication publisher/subscriber on two SQL over WAN
    ... Two SQL Servers, each in different geographic ... the locationB sql server. ... with that once I get the simple replication to work on a sample ... would just like to create a very simple database to test the concept ...
    (microsoft.public.sqlserver.replication)
  • Need Feedback on Trans. Replication w/ Remote Distributor
    ... I have been asked to set up replication between two SQL servers on our ... We have a SQL server that currently serves as the backend ... create an initial snapshot yet, and am trying to figure out how to configure ...
    (microsoft.public.sqlserver.replication)