Re: tried dts copy of tables stored procedures etc and it fails exery time
From: Andrew J. Kelly (ajkellynospam_at_attbi.com)
Date: 04/29/03
- Next message: Michael Fong: "Re: How do I let users create databases and only let them delete their own?"
- Previous message: mike: "Which users are connected?"
- In reply to: johnechavez_at_earthlink.net: "tried dts copy of tables stored procedures etc and it fails exery time"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 29 Apr 2003 17:57:00 -0400
Here are some links that will help. If you want to copy the entire db and
all its objects I would just either restore a full backup or use
sp_attachdb. Both are outlined in the links below:
http://www.support.microsoft.com/?id=274463 Copy DB
Wizard issues
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
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
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
-- Andrew J. Kelly SQL Server MVP <johnechavez@earthlink.net> wrote in message news:3uwra.45271$ey1.4241482@newsread1.prod.itd.earthlink.net... > tried dts copy of tables stored procedures etc and it fails exery time > in one way or a nother ,looks like i can get most of the data across to the > new database, but it still fails with the defaults.... > , i don't have much expierience with sql 7 data base minuplation, can > someone help.. > > > > >
- Next message: Michael Fong: "Re: How do I let users create databases and only let them delete their own?"
- Previous message: mike: "Which users are connected?"
- In reply to: johnechavez_at_earthlink.net: "tried dts copy of tables stored procedures etc and it fails exery time"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
