Copying tables between two databases

I am trying to copy the chart of accounts from Fabrikam to a newly created
company. I am running SQL 2005 and Dynamics GP 9.0.
I am following the steps from article 866332 in the knowledge base. This
process has the user copying some database tables from one database to
another database.
I perform the steps but when I try to execute the process, I get the following
errors:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Error)
Messages
* Error 0xc0202049: Data Flow Task: Failure inserting into the
read-only column "DEX_ROW_ID".
(SQL Server Import and Export Wizard)
* Error 0xc0202045: Data Flow Task: Column metadata validation
failed.
(SQL Server Import and Export Wizard)
* Error 0xc004706b: Data Flow Task: "component "Destination -
GL00100" (139)" failed validation and returned validation status
"VS_ISBROKEN".
(SQL Server Import and Export Wizard)
* Error 0xc004700c: Data Flow Task: One or more component failed
validation.
(SQL Server Import and Export Wizard)
* Error 0xc0024107: Data Flow Task: There were errors during task
validation.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [FS].[dbo].[GL00100] (Stopped)
- Copying to [FS].[dbo].[GL00102] (Stopped)
- Copying to [FS].[dbo].[GL00103] (Stopped)
- Copying to [FS].[dbo].[GL00104] (Stopped)
- Copying to [FS].[dbo].[GL00105] (Stopped)
- Copying to [FS].[dbo].[GL40200] (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
Any idea what the problem is?
Thanks.
Jerry Flatto
On Mar 24, 2:04 am, Jerry Flatto
<JerryFla...@.discussions.microsoft.com> wrote:
> I am trying to copy the chart of accounts from Fabrikam to a newly created
> company. I am running SQL 2005 and Dynamics GP 9.0.
> I am following the steps from article 866332 in the knowledge base. This
> process has the user copying some database tables from one database to
> another database.
> I perform the steps but when I try to execute the process, I get the following
> errors:
> Operation stopped...
> - Initializing Data Flow Task (Success)
> - Initializing Connections (Success)
> - Setting SQL Command (Success)
> - Setting Source Connection (Success)
> - Setting Destination Connection (Success)
> - Validating (Error)
> Messages
> * Error 0xc0202049: Data Flow Task: Failure inserting into the
> read-only column "DEX_ROW_ID".
> (SQL Server Import and Export Wizard)
> * Error 0xc0202045: Data Flow Task: Column metadata validation
> failed.
> (SQL Server Import and Export Wizard)
> * Error 0xc004706b: Data Flow Task: "component "Destination -
> GL00100" (139)" failed validation and returned validation status
> "VS_ISBROKEN".
> (SQL Server Import and Export Wizard)
> * Error 0xc004700c: Data Flow Task: One or more component failed
> validation.
> (SQL Server Import and Export Wizard)
> * Error 0xc0024107: Data Flow Task: There were errors during task
> validation.
> (SQL Server Import and Export Wizard)
> - Prepare for Execute (Stopped)
> - Pre-execute (Stopped)
> - Executing (Success)
> - Copying to [FS].[dbo].[GL00100] (Stopped)
> - Copying to [FS].[dbo].[GL00102] (Stopped)
> - Copying to [FS].[dbo].[GL00103] (Stopped)
> - Copying to [FS].[dbo].[GL00104] (Stopped)
> - Copying to [FS].[dbo].[GL00105] (Stopped)
> - Copying to [FS].[dbo].[GL40200] (Stopped)
> - Post-execute (Stopped)
> - Cleanup (Stopped)
> Any idea what the problem is?
> Thanks.
> Jerry Flatto
DEX_ROW_ID seems to be timestamp column which can not be imported

Copying tables between two databases

I am trying to copy the chart of accounts from Fabrikam to a newly created
company. I am running SQL 2005 and Dynamics GP 9.0.
I am following the steps from article 866332 in the knowledge base. This
process has the user copying some database tables from one database to
another database.
I perform the steps but when I try to execute the process, I get the followi
ng
errors:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Error)
Messages
* Error 0xc0202049: Data Flow Task: Failure inserting into the
read-only column "DEX_ROW_ID".
(SQL Server Import and Export Wizard)
* Error 0xc0202045: Data Flow Task: Column metadata validation
failed.
(SQL Server Import and Export Wizard)
* Error 0xc004706b: Data Flow Task: "component "Destination -
GL00100" (139)" failed validation and returned validation status
"VS_ISBROKEN".
(SQL Server Import and Export Wizard)
* Error 0xc004700c: Data Flow Task: One or more component failed
validation.
(SQL Server Import and Export Wizard)
* Error 0xc0024107: Data Flow Task: There were errors during task
validation.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [FS].[dbo].[GL00100] (Stopped)
- Copying to [FS].[dbo].[GL00102] (Stopped)
- Copying to [FS].[dbo].[GL00103] (Stopped)
- Copying to [FS].[dbo].[GL00104] (Stopped)
- Copying to [FS].[dbo].[GL00105] (Stopped)
- Copying to [FS].[dbo].[GL40200] (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
Any idea what the problem is?
Thanks.
Jerry FlattoOn Mar 24, 2:04 am, Jerry Flatto
<JerryFla...@.discussions.microsoft.com> wrote:
> I am trying to copy the chart of accounts from Fabrikam to a newly create
d
> company. I am running SQL 2005 and Dynamics GP 9.0.
> I am following the steps from article 866332 in the knowledge base. This
> process has the user copying some database tables from one database to
> another database.
> I perform the steps but when I try to execute the process, I get the follo
wing
> errors:
> Operation stopped...
> - Initializing Data Flow Task (Success)
> - Initializing Connections (Success)
> - Setting SQL Command (Success)
> - Setting Source Connection (Success)
> - Setting Destination Connection (Success)
> - Validating (Error)
> Messages
> * Error 0xc0202049: Data Flow Task: Failure inserting into the
> read-only column "DEX_ROW_ID".
> (SQL Server Import and Export Wizard)
> * Error 0xc0202045: Data Flow Task: Column metadata validation
> failed.
> (SQL Server Import and Export Wizard)
> * Error 0xc004706b: Data Flow Task: "component "Destination -
> GL00100" (139)" failed validation and returned validation status
> "VS_ISBROKEN".
> (SQL Server Import and Export Wizard)
> * Error 0xc004700c: Data Flow Task: One or more component failed
> validation.
> (SQL Server Import and Export Wizard)
> * Error 0xc0024107: Data Flow Task: There were errors during task
> validation.
> (SQL Server Import and Export Wizard)
> - Prepare for Execute (Stopped)
> - Pre-execute (Stopped)
> - Executing (Success)
> - Copying to [FS].[dbo].[GL00100] (Stopped)
> - Copying to [FS].[dbo].[GL00102] (Stopped)
> - Copying to [FS].[dbo].[GL00103] (Stopped)
> - Copying to [FS].[dbo].[GL00104] (Stopped)
> - Copying to [FS].[dbo].[GL00105] (Stopped)
> - Copying to [FS].[dbo].[GL40200] (Stopped)
> - Post-execute (Stopped)
> - Cleanup (Stopped)
> Any idea what the problem is?
> Thanks.
> Jerry Flatto
DEX_ROW_ID seems to be timestamp column which can not be imported

Copying tables between two databases

I am trying to copy the chart of accounts from Fabrikam to a newly created
company. I am running SQL 2005 and Dynamics GP 9.0.
I am following the steps from article 866332 in the knowledge base. This
process has the user copying some database tables from one database to
another database.
I perform the steps but when I try to execute the process, I get the following
errors:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Error)
Messages
* Error 0xc0202049: Data Flow Task: Failure inserting into the
read-only column "DEX_ROW_ID".
(SQL Server Import and Export Wizard)
* Error 0xc0202045: Data Flow Task: Column metadata validation
failed.
(SQL Server Import and Export Wizard)
* Error 0xc004706b: Data Flow Task: "component "Destination -
GL00100" (139)" failed validation and returned validation status
"VS_ISBROKEN".
(SQL Server Import and Export Wizard)
* Error 0xc004700c: Data Flow Task: One or more component failed
validation.
(SQL Server Import and Export Wizard)
* Error 0xc0024107: Data Flow Task: There were errors during task
validation.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [FS].[dbo].[GL00100] (Stopped)
- Copying to [FS].[dbo].[GL00102] (Stopped)
- Copying to [FS].[dbo].[GL00103] (Stopped)
- Copying to [FS].[dbo].[GL00104] (Stopped)
- Copying to [FS].[dbo].[GL00105] (Stopped)
- Copying to [FS].[dbo].[GL40200] (Stopped)
- Post-execute (Stopped)
- Cleanup (Stopped)
Any idea what the problem is?
Thanks.
Jerry FlattoOn Mar 24, 2:04 am, Jerry Flatto
<JerryFla...@.discussions.microsoft.com> wrote:
> I am trying to copy the chart of accounts from Fabrikam to a newly created
> company. I am running SQL 2005 and Dynamics GP 9.0.
> I am following the steps from article 866332 in the knowledge base. This
> process has the user copying some database tables from one database to
> another database.
> I perform the steps but when I try to execute the process, I get the following
> errors:
> Operation stopped...
> - Initializing Data Flow Task (Success)
> - Initializing Connections (Success)
> - Setting SQL Command (Success)
> - Setting Source Connection (Success)
> - Setting Destination Connection (Success)
> - Validating (Error)
> Messages
> * Error 0xc0202049: Data Flow Task: Failure inserting into the
> read-only column "DEX_ROW_ID".
> (SQL Server Import and Export Wizard)
> * Error 0xc0202045: Data Flow Task: Column metadata validation
> failed.
> (SQL Server Import and Export Wizard)
> * Error 0xc004706b: Data Flow Task: "component "Destination -
> GL00100" (139)" failed validation and returned validation status
> "VS_ISBROKEN".
> (SQL Server Import and Export Wizard)
> * Error 0xc004700c: Data Flow Task: One or more component failed
> validation.
> (SQL Server Import and Export Wizard)
> * Error 0xc0024107: Data Flow Task: There were errors during task
> validation.
> (SQL Server Import and Export Wizard)
> - Prepare for Execute (Stopped)
> - Pre-execute (Stopped)
> - Executing (Success)
> - Copying to [FS].[dbo].[GL00100] (Stopped)
> - Copying to [FS].[dbo].[GL00102] (Stopped)
> - Copying to [FS].[dbo].[GL00103] (Stopped)
> - Copying to [FS].[dbo].[GL00104] (Stopped)
> - Copying to [FS].[dbo].[GL00105] (Stopped)
> - Copying to [FS].[dbo].[GL40200] (Stopped)
> - Post-execute (Stopped)
> - Cleanup (Stopped)
> Any idea what the problem is?
> Thanks.
> Jerry Flatto
DEX_ROW_ID seems to be timestamp column which can not be importedsql

Copying my existing database to another server

Hi

I am running my sql 2000 database server and I just want to copy that database and paste or put on another server which has also run same version of sql 2000 database. I tried to copy and paste the ldf & mdf extensioned files which are located in "C:\Program Files\Microsoft SQL Server\MSSQL\Data" into my 2 server, but when I open up the enterprise manager, I cant see the new database. So this way dont work, I tried to do something with export and import wizard but it just creates another database and copies the data in that database in the same server. I want to copy that data and put onto another system, please guide me. I'm confused, Thanks a lot

Use the copy database wizard-http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_onmigwiz_0z50.asp|||

That's it,

Thanks thanks thanks :)

|||One thing to keep in mind: Copy Database Wizard is only available in SQL2005, and the destination data source must be SQL2005. For SQL2000 you can use Backup/Restore to move databases. You may take a look at:Copying Databases to Other Servers|||Actually, it's available in SQL Server 2000 as well, see the link in my first post.|||Thanks Mudface, you teach me a lotsql

Copying MSDE database into SQL 2005

I have a legasy database developed for SQL 2000 running in MSDE. I've tried COPY DATABASE into SQL 2005 (Developer edition, to see if I can get it to work right before specing out a new server), but the user accounts don't copy and I also suspect my settings for security and permissions aren't right.

I can set SQL server security to mixed mode, and the legasy system front end Access projects to connect using Windows authentication only, but then I'm unable to control access and set roles. I need to be able to connect as a particular user in order to admin the legasy system.

Is there a fairly uncomplicated way to copy user accounts and set SQL Server options to assign roles/permissions for an MSDE legasy system copy to SQL 2005?

These articles should shed a little light on the issues:

http://www.sqlservercentral.com/columnists/cBunch/movingyouruserswiththeirdatabases.asp Moving Users
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://support.microsoft.com/kb/274188 Troubleshooting Orphan Logins
http://www.support.microsoft.com/?id=240872Resolve Permission Issues -Database Is Moved Between SQL Servers

Copying dBs

I am running SQL 2000 (using replication) & Win
2000.
We are getting a new production sever and would like to
know the best practice for moving all the SQL data from
the Old Server to the New Server. There are a few
questions the concern me.
- Will I have to setup replication on the new server?
- Will all the dB defaults be preserved?
Larry,
if the server names are the same, and you have backups of all databases, then you should be able torestore them on the new production server. If you're doing transactional replication, then make sure the distribution database is synchronized with the prod
uction database. If the server names are different, then I'd script out the publications and recreate on the new server. Provided no subscribers are allowed to do any data changes during this time, you should be able to add the subscriptions without apply
ing the data snapshot (@.sync_type ='none').
HTH,
Paul Ibison
|||In the long run you would be best to drop the subscriptions and publications
on the current production server. Back it up and restore it to the new
publisher.
Recreate the publications from scripts and then do create a nosync
subscription to your existing subscriber.
"larry" <anonymous@.discussions.microsoft.com> wrote in message
news:238c01c427b5$7a2e6040$a501280a@.phx.gbl...
> I am running SQL 2000 (using replication) & Win
> 2000.
> We are getting a new production sever and would like to
> know the best practice for moving all the SQL data from
> the Old Server to the New Server. There are a few
> questions the concern me.
> - Will I have to setup replication on the new server?
> - Will all the dB defaults be preserved?
>

Copying databases to other servers (Backup and Restore - Detach/Attach)

I want to copy a database from one server to another so that they are
identical and I have a few questions. Also I am running the 'Simple
Recovery Model' and therefore my transaction log is minimal.
BACKUP AND RESTORE: If I perform a backup and restore will user access
rights be backed up? What if the user doesn't exist on the new server?
Should I create it manually? Lastly, in the simple recovery model do
I need to backup the transaction log?
MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
implications of stopping SQL server and manually copying the data and
log file? I could then attach it to the new server? Would this work?
DATACHING AND REATTACHING: I could detach the database, copy it to the
new server and then attach it to the original and new servers? Would
this work?
EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
tables, but this procedure would take the longest.
All your questions are answered in the following Knowledge Base article:
314546 - HOW TO Move Databases Between Computers That Are Running SQL
Server:
http://support.microsoft.com/default...;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
<war_wheelan@.yahoo.com> wrote in message
news:1114097392.448483.201600@.f14g2000cwb.googlegr oups.com...
>I want to copy a database from one server to another so that they are
> identical and I have a few questions. Also I am running the 'Simple
> Recovery Model' and therefore my transaction log is minimal.
> BACKUP AND RESTORE: If I perform a backup and restore will user access
> rights be backed up? What if the user doesn't exist on the new server?
> Should I create it manually? Lastly, in the simple recovery model do
> I need to backup the transaction log?
> MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
> implications of stopping SQL server and manually copying the data and
> log file? I could then attach it to the new server? Would this work?
> DATACHING AND REATTACHING: I could detach the database, copy it to the
> new server and then attach it to the original and new servers? Would
> this work?
> EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
> tables, but this procedure would take the longest.
>

Copying databases to other servers (Backup and Restore - Detach/Attach)

I want to copy a database from one server to another so that they are
identical and I have a few questions. Also I am running the 'Simple
Recovery Model' and therefore my transaction log is minimal.
BACKUP AND RESTORE: If I perform a backup and restore will user access
rights be backed up? What if the user doesn't exist on the new server?
Should I create it manually? Lastly, in the simple recovery model do
I need to backup the transaction log?
MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
implications of stopping SQL server and manually copying the data and
log file? I could then attach it to the new server' Would this work?
DATACHING AND REATTACHING: I could detach the database, copy it to the
new server and then attach it to the original and new servers? Would
this work?
EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
tables, but this procedure would take the longest.All your questions are answered in the following Knowledge Base article:
314546 - HOW TO Move Databases Between Computers That Are Running SQL
Server:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546
--
Jacco Schalkwijk
SQL Server MVP
<war_wheelan@.yahoo.com> wrote in message
news:1114097392.448483.201600@.f14g2000cwb.googlegroups.com...
>I want to copy a database from one server to another so that they are
> identical and I have a few questions. Also I am running the 'Simple
> Recovery Model' and therefore my transaction log is minimal.
> BACKUP AND RESTORE: If I perform a backup and restore will user access
> rights be backed up? What if the user doesn't exist on the new server?
> Should I create it manually? Lastly, in the simple recovery model do
> I need to backup the transaction log?
> MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
> implications of stopping SQL server and manually copying the data and
> log file? I could then attach it to the new server' Would this work?
> DATACHING AND REATTACHING: I could detach the database, copy it to the
> new server and then attach it to the original and new servers? Would
> this work?
> EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
> tables, but this procedure would take the longest.
>|||Hi,
Using all the below approches you can copy the database to second server.
But the 3rd approch may fail ( MANUALLY COPY THE *.MDF AND *.LDF FILES) if
you have not detached the files. So it is always recomended to detach the
file and copy to destination.
If the first server is production you could use BACK DATABASE, Copy the
Backup file to second server and Restore it (RESTORE DATABASE). All the Login
user chains can be created/established using the the system stored proc
sp_change_users_login
(See books online for usage and various parameters).
If the system is not production then you can detach the database , copy the
MDF and LDF to second server , Attach the database and use system stored proc
sp_change_users_login to syncronize the logins and users.
Third approach (Export and import) may not be a solution if you have miore
tables and data. This is really time consuming.
Thanks
Hari
SQL Server MVP
"war_wheelan@.yahoo.com" wrote:
> I want to copy a database from one server to another so that they are
> identical and I have a few questions. Also I am running the 'Simple
> Recovery Model' and therefore my transaction log is minimal.
> BACKUP AND RESTORE: If I perform a backup and restore will user access
> rights be backed up? What if the user doesn't exist on the new server?
> Should I create it manually? Lastly, in the simple recovery model do
> I need to backup the transaction log?
> MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
> implications of stopping SQL server and manually copying the data and
> log file? I could then attach it to the new server' Would this work?
> DATACHING AND REATTACHING: I could detach the database, copy it to the
> new server and then attach it to the original and new servers? Would
> this work?
> EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
> tables, but this procedure would take the longest.
>|||HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
AMB
"war_wheelan@.yahoo.com" wrote:
> I want to copy a database from one server to another so that they are
> identical and I have a few questions. Also I am running the 'Simple
> Recovery Model' and therefore my transaction log is minimal.
> BACKUP AND RESTORE: If I perform a backup and restore will user access
> rights be backed up? What if the user doesn't exist on the new server?
> Should I create it manually? Lastly, in the simple recovery model do
> I need to backup the transaction log?
> MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
> implications of stopping SQL server and manually copying the data and
> log file? I could then attach it to the new server' Would this work?
> DATACHING AND REATTACHING: I could detach the database, copy it to the
> new server and then attach it to the original and new servers? Would
> this work?
> EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
> tables, but this procedure would take the longest.
>

Copying databases to other servers (Backup and Restore - Detach/Attach)

I want to copy a database from one server to another so that they are
identical and I have a few questions. Also I am running the 'Simple
Recovery Model' and therefore my transaction log is minimal.
BACKUP AND RESTORE: If I perform a backup and restore will user access
rights be backed up? What if the user doesn't exist on the new server?
Should I create it manually? Lastly, in the simple recovery model do
I need to backup the transaction log?
MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
implications of stopping SQL server and manually copying the data and
log file? I could then attach it to the new server' Would this work?
DATACHING AND REATTACHING: I could detach the database, copy it to the
new server and then attach it to the original and new servers? Would
this work?
EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
tables, but this procedure would take the longest.All your questions are answered in the following Knowledge Base article:
314546 - HOW TO Move Databases Between Computers That Are Running SQL
Server:
http://support.microsoft.com/defaul...b;en-us;Q314546
Jacco Schalkwijk
SQL Server MVP
<war_wheelan@.yahoo.com> wrote in message
news:1114097392.448483.201600@.f14g2000cwb.googlegroups.com...
>I want to copy a database from one server to another so that they are
> identical and I have a few questions. Also I am running the 'Simple
> Recovery Model' and therefore my transaction log is minimal.
> BACKUP AND RESTORE: If I perform a backup and restore will user access
> rights be backed up? What if the user doesn't exist on the new server?
> Should I create it manually? Lastly, in the simple recovery model do
> I need to backup the transaction log?
> MANUALLY COPY THE *.MDF AND *.LDF FILES: What would be the
> implications of stopping SQL server and manually copying the data and
> log file? I could then attach it to the new server' Would this work?
> DATACHING AND REATTACHING: I could detach the database, copy it to the
> new server and then attach it to the original and new servers? Would
> this work?
> EXPORTING DB TO NEW SERVER: I could do an export of the db 500+
> tables, but this procedure would take the longest.
>

Copying Databases From Server to Another

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks
hi,
"Shash Goyal" <Shash703@.gmail.com> ha scritto nel messaggio
news:uEjQ2LwtEHA.2808@.TK2MSFTNGP14.phx.gbl
> What is the best and safest way to copy about 55 Databases from a
> server running win2k to a new server running Win Server 2003 Ent. Ed.
> What are the different options do i have? Can I copy all the current
> Db plans, jobs, and Logins? What is a good practice for doing this?
> The win2k server is in production right now. Do i have to shut it
> down?
> Please Help. Thanks
wow... a massive task, isn't it? =;-D
I'd suggest, if available, the Copy database wizard, available in Enterprise
Manager, for SQL Server instances, which takes care to move logins and msdb
objects too...
but... if you are on MSDE, you do not have access to it... an all becomes
trickier...
you can perhaps full backup and restore on the new server users databases...
this will not move the logins...
you could then script the logins out and recreate them on the destination
server... keep in mind you will require some login/user sync, as better
explained in
http://www.sqlservercentral.com/colu...okenlogins.asp
as regard msdb objects... script them out too, and recreate tem form their
DDL sql scripts in the destination server...
you are not required to shut down the original server, this way... nor if
you can use Copy database EM wizard... you are required to temporary have
you server down, in someway, if you detach/reattach your user databases...
but I'd prefer the full backup/restore method in this particular scenario..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you Andrea!!!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2tpjc9F2386efU1@.uni-berlin.de...
> hi,
> "Shash Goyal" <Shash703@.gmail.com> ha scritto nel messaggio
> news:uEjQ2LwtEHA.2808@.TK2MSFTNGP14.phx.gbl
> wow... a massive task, isn't it? =;-D
> I'd suggest, if available, the Copy database wizard, available in
Enterprise
> Manager, for SQL Server instances, which takes care to move logins and
msdb
> objects too...
> but... if you are on MSDE, you do not have access to it... an all becomes
> trickier...
> you can perhaps full backup and restore on the new server users
databases...
> this will not move the logins...
> you could then script the logins out and recreate them on the destination
> server... keep in mind you will require some login/user sync, as better
> explained in
> http://www.sqlservercentral.com/colu...okenlogins.asp
> as regard msdb objects... script them out too, and recreate tem form their
> DDL sql scripts in the destination server...
> you are not required to shut down the original server, this way... nor if
> you can use Copy database EM wizard... you are required to temporary have
> you server down, in someway, if you detach/reattach your user databases...
> but I'd prefer the full backup/restore method in this particular
scenario..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Copying Databases

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks
> What is the best and safest way to copy about 55 Databases from a server
> running win2k to a new server running Win Server 2003 Ent. Ed. What are
> the different options do i have? Can I copy all the current Db plans,
jobs,
> and Logins? What is a good practice for doing this? The win2k server is
in
> production right now. Do i have to shut it down?
Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
Transfer Logins task. For jobs and other things, you can backup and restore
the Msdb database.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||It might be worth mentioning that for SQL Server logins, a new SID is generated by CDW. I would
consider skipping that step and handle logins using sp_help_revlogin (search KB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message
news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> jobs,
> in
> Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
> Transfer Logins task. For jobs and other things, you can backup and restore
> the Msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
|||Thank you all
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OKvNRYztEHA.1048@.tk2msftngp13.phx.gbl...
> It might be worth mentioning that for SQL Server logins, a new SID is
generated by CDW. I would
> consider skipping that step and handle logins using sp_help_revlogin
(search KB).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message[vbcol=seagreen]
> news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
server[vbcol=seagreen]
are[vbcol=seagreen]
is[vbcol=seagreen]
DTS[vbcol=seagreen]
restore
>

Copying Databases

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks> What is the best and safest way to copy about 55 Databases from a server
> running win2k to a new server running Win Server 2003 Ent. Ed. What are
> the different options do i have? Can I copy all the current Db plans,
jobs,
> and Logins? What is a good practice for doing this? The win2k server is
in
> production right now. Do i have to shut it down?
Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
Transfer Logins task. For jobs and other things, you can backup and restore
the Msdb database.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||It might be worth mentioning that for SQL Server logins, a new SID is generated by CDW. I would
consider skipping that step and handle logins using sp_help_revlogin (search KB).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message
news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> > What is the best and safest way to copy about 55 Databases from a server
> > running win2k to a new server running Win Server 2003 Ent. Ed. What are
> > the different options do i have? Can I copy all the current Db plans,
> jobs,
> > and Logins? What is a good practice for doing this? The win2k server is
> in
> > production right now. Do i have to shut it down?
> Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
> Transfer Logins task. For jobs and other things, you can backup and restore
> the Msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>|||Thank you all
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OKvNRYztEHA.1048@.tk2msftngp13.phx.gbl...
> It might be worth mentioning that for SQL Server logins, a new SID is
generated by CDW. I would
> consider skipping that step and handle logins using sp_help_revlogin
(search KB).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message
> news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> > > What is the best and safest way to copy about 55 Databases from a
server
> > > running win2k to a new server running Win Server 2003 Ent. Ed. What
are
> > > the different options do i have? Can I copy all the current Db plans,
> > jobs,
> > > and Logins? What is a good practice for doing this? The win2k server
is
> > in
> > > production right now. Do i have to shut it down?
> >
> > Copy Database Wizard in EM is quite nice. You can transfer logins using
DTS
> > Transfer Logins task. For jobs and other things, you can backup and
restore
> > the Msdb database.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > www.SolidQualityLearning.com
> >
> >
>

Copying Databases

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks> What is the best and safest way to copy about 55 Databases from a server
> running win2k to a new server running Win Server 2003 Ent. Ed. What are
> the different options do i have? Can I copy all the current Db plans,
jobs,
> and Logins? What is a good practice for doing this? The win2k server is
in
> production right now. Do i have to shut it down?
Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
Transfer Logins task. For jobs and other things, you can backup and restore
the Msdb database.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||It might be worth mentioning that for SQL Server logins, a new SID is genera
ted by CDW. I would
consider skipping that step and handle logins using sp_help_revlogin (search
KB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in m
essage
news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> jobs,
> in
> Copy Database Wizard in EM is quite nice. You can transfer logins using DT
S
> Transfer Logins task. For jobs and other things, you can backup and restor
e
> the Msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>|||Thank you all
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OKvNRYztEHA.1048@.tk2msftngp13.phx.gbl...
> It might be worth mentioning that for SQL Server logins, a new SID is
generated by CDW. I would
> consider skipping that step and handle logins using sp_help_revlogin
(search KB).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message
> news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
server[vbcol=seagreen]
are[vbcol=seagreen]
is[vbcol=seagreen]
DTS[vbcol=seagreen]
restore[vbcol=seagreen]
>

copying Data Base from one sever to another

Hi,
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. On
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy a
newer one over from the Prod. server. The tape drive on the production server
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod server
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
GregHi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server. On
> the test server I have a duplicate sql 2000 with a copy of the database from
> the production server. Which all are working fine. Both systems have a tape
> drive. It's a very old D.B. copy on the test server so I would like to copy a
> newer one over from the Prod. server. The tape drive on the production server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg

copying Data Base from one sever to another

Hi,
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. O
n
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy
a
newer one over from the Prod. server. The tape drive on the production serve
r
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod serve
r
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
GregHi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:

> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
On
> the test server I have a duplicate sql 2000 with a copy of the database fr
om
> the production server. Which all are working fine. Both systems have a tap
e
> drive. It's a very old D.B. copy on the test server so I would like to cop
y a
> newer one over from the Prod. server. The tape drive on the production ser
ver
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod ser
ver
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg

copying Data Base from one sever to another

Hi,
Hope I explain this clearly. I'm a newbie to sql. I currently have 2
servers running sql 2000. One is a Production and the other a test server. On
the test server I have a duplicate sql 2000 with a copy of the database from
the production server. Which all are working fine. Both systems have a tape
drive. It's a very old D.B. copy on the test server so I would like to copy a
newer one over from the Prod. server. The tape drive on the production server
is a newer drive than the one on the test server. So I'm unable to restore
from the Prod. to the test server via tape. I would not like to stop sql
running on the prod. server. Is the a way to load the tape in the Prod server
and restore it to the test server? -- I only need the D.B. copyed. I would
not want to detach the D.B.
Greg
Hi
This sounds like an access issue rather than anything else! If you have disk
space on the production server for a backup to disk, you may then be able to
either use a network share/FTP... etc to move it to the production system.
Failing that maybe a removable disk (but then there is a risk when
introducing new hardware!).
HTH
John
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:ECC06AC5-7FB7-423E-A023-71A3F0D8C102@.microsoft.com...
> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server.
> On
> the test server I have a duplicate sql 2000 with a copy of the database
> from
> the production server. Which all are working fine. Both systems have a
> tape
> drive. It's a very old D.B. copy on the test server so I would like to
> copy a
> newer one over from the Prod. server. The tape drive on the production
> server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod
> server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg
|||Depends what you have available.
Can you transfer anything between the prod and test server? If not then
obviously you can't refresh.
If you can transfer data then backup the prod database copy the backup to
the test server (via tape if necessary) and restore it.
If you can't do that much then you probably need to spend some time getting
into a situation where you can.
"Greg" wrote:

> Hi,
> Hope I explain this clearly. I'm a newbie to sql. I currently have 2
> servers running sql 2000. One is a Production and the other a test server. On
> the test server I have a duplicate sql 2000 with a copy of the database from
> the production server. Which all are working fine. Both systems have a tape
> drive. It's a very old D.B. copy on the test server so I would like to copy a
> newer one over from the Prod. server. The tape drive on the production server
> is a newer drive than the one on the test server. So I'm unable to restore
> from the Prod. to the test server via tape. I would not like to stop sql
> running on the prod. server. Is the a way to load the tape in the Prod server
> and restore it to the test server? -- I only need the D.B. copyed. I would
> not want to detach the D.B.
> Greg

copying a DB from one server to another

Hi

I have a PC with MSDE2000 and need to copy the data to another PC running SQL2005.

I have registered the MSDE server on my SQL2005 PC and can see the tables etc.

Can this be done automatically, say every day?

Is there a way of mirroring the DB?

Cheers

Eugene

Hello,

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx. You can find more info from this about copying the database from MSDE to SQL2005.

Thanks

|||

If your SQL Server 2005 machine is running Standard Edition or higher, you can create a package in SQL Server Integration Services to automate moving data. You can schedule running the package using SQL Server Agent.

Database replication (publisher/subscriber) requires higher SKUs (Workgroup and up) for the publisher. SQL Server 2005 Express can be a subscriber though. You can see a comparison of features here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Hope this helps,
Steve

|||

Hi Steve

I Am using 2005 Std, I have also just installed SP1

I was hoping to use the mirroring function but it looks like it only works with sql 2005 DB! The same is true of Log shipping I think?

So is there any samples of how you use this integration service?

I am not that familiar with SQL as a whole and it would be good if there we're simple ways around the problems.

I would of thought there is an easy way to automatically copy a DB to another Server , like wizards....

Any Help Would be Appreciated

Cheers

Eugene

Copying a database to another server

Im running SQL Server 2005 Express with SQL Server Management studio installed on my laptop. After updating my database, how do I copy the entire contents to the main server in the office, which is running windows server 2003 and SQL Server 2000 Developer Edition.
And is it possible to do it all from my laptop?

right click the database an you will see a context menu. on one of the sub menus here you will see generate script. In the wizard, one of the options is to specify sql 200 compatible

After running the script on the office server, right click on the database, select export, follow the steps in the wizard to export the data.

Copy Stored Procedures from one server to another

I am moving a database from SQL Server 2005 to SQL Server 2005 Express
running on a laptop for a demo. I have the database tables and data copied,
but am unable to copy the stored procedures. How do I do this?
Thanks,
Mike Ober.You can either use dts and the copy objects or use
a script like this:
generate script for stored procedures in dependency order
http://www.eggheadcafe.com/articles/20030609.asp
--
Robbe Morris - 2004-2006 Microsoft MVP C#
I've mapped the database to .NET class properties and methods to
implement an multi-layered object oriented environment for your
data access layer. Thus, you should rarely ever have to type the words
SqlCommand, SqlDataAdapter, or SqlConnection again.
http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>running on a laptop for a demo. I have the database tables and data
>copied, but am unable to copy the stored procedures. How do I do this?
> Thanks,
> Mike Ober.
>|||The fastest way would be to detach the database copy the mdf and ldf files
to the laptop and attach them there.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>running on a laptop for a demo. I have the database tables and data
>copied, but am unable to copy the stored procedures. How do I do this?
> Thanks,
> Mike Ober.
>|||Hi,
Take a look into the below URL; this talks about lots of options.
http://www.karaszi.com/SQLServer/info_generate_script.asp
Thanks
Hari
"Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>running on a laptop for a demo. I have the database tables and data
>copied, but am unable to copy the stored procedures. How do I do this?
> Thanks,
> Mike Ober.
>|||Hi
Open them in enterprise manager then "cut and paste" them to notepad
files.
Hope this helps
The Grand Master Programmer
Hari Prasad wrote:
> Hi,
> Take a look into the below URL; this talks about lots of options.
> http://www.karaszi.com/SQLServer/info_generate_script.asp
> Thanks
> Hari
>
> "Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
> news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
> >I am moving a database from SQL Server 2005 to SQL Server 2005 Express
> >running on a laptop for a demo. I have the database tables and data
> >copied, but am unable to copy the stored procedures. How do I do this?
> >
> > Thanks,
> > Mike Ober.
> >
> >|||That worked - I had to delete and recreate the service account on the
laptop, but that wasn't a big deal.
Thanks,
Mike.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:%23CJI9xn5GHA.2524@.TK2MSFTNGP06.phx.gbl...
> The fastest way would be to detach the database copy the mdf and ldf files
> to the laptop and attach them there.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
> news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>>running on a laptop for a demo. I have the database tables and data
>>copied, but am unable to copy the stored procedures. How do I do this?
>> Thanks,
>> Mike Ober.
>>
>|||Robbe,
Thanks for the link to the adonet source code generator.
Mike Ober.
"Robbe Morris [C# MVP]" <joeblow@.joe.com> wrote in message
news:%23Ay1FQn5GHA.2292@.TK2MSFTNGP04.phx.gbl...
> You can either use dts and the copy objects or use
> a script like this:
> generate script for stored procedures in dependency order
> http://www.eggheadcafe.com/articles/20030609.asp
> --
> Robbe Morris - 2004-2006 Microsoft MVP C#
> I've mapped the database to .NET class properties and methods to
> implement an multi-layered object oriented environment for your
> data access layer. Thus, you should rarely ever have to type the words
> SqlCommand, SqlDataAdapter, or SqlConnection again.
> http://www.eggheadcafe.com/articles/adonet_source_code_generator.asp
>
>
> "Michael D. Ober" <obermd.@..alum.mit.edu.nospam> wrote in message
> news:uLhtJJn5GHA.3808@.TK2MSFTNGP06.phx.gbl...
>>I am moving a database from SQL Server 2005 to SQL Server 2005 Express
>>running on a laptop for a demo. I have the database tables and data
>>copied, but am unable to copy the stored procedures. How do I do this?
>> Thanks,
>> Mike Ober.
>>
>

Copy SQL Users from a server to another

Hi,
We are using a SQL 2000 Std Server on a Windows 2000
Server. I just install a new Server running with Windows
2003 Standart and i installed SQL 2000 Std on it.
When i go into Enterprise Manager, On Security folder and
Logins tabs, i saw all the users that needs access to wich
DB etc.
I want to copy all this security information to my new SQL
Server... how did i do that?
thanks!Hi,
Have a look into the below link.
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
MCDBA
"GuillauG" <Guillaume.Genest@.qc.teknion.com> wrote in message
news:2b4501c42875$89e027b0$a601280a@.phx.gbl...
> Hi,
> We are using a SQL 2000 Std Server on a Windows 2000
> Server. I just install a new Server running with Windows
> 2003 Standart and i installed SQL 2000 Std on it.
> When i go into Enterprise Manager, On Security folder and
> Logins tabs, i saw all the users that needs access to wich
> DB etc.
> I want to copy all this security information to my new SQL
> Server... how did i do that?
> thanks!|||Hi,
Thank, from your link i find this link:
http://www.databasejournal.com/feat...l/article.php/2
228611
Really easier for me than using sp_ function.
But after i follow the instruction on this web site i got
an "Unspecified error" while running the task. But all my
users seems to have been copied...
Someone know why i get this error?
Thanks!
>--Original Message--
>Hi,
>Have a look into the below link.
>http://www.databasejournal.com/feat...ql/article.php/
2228611
>Thanks
>Hari
>MCDBA
>
>"GuillauG" <Guillaume.Genest@.qc.teknion.com> wrote in
message
>news:2b4501c42875$89e027b0$a601280a@.phx.gbl...
and[vbcol=seagreen]
wich[vbcol=seagreen]
SQL[vbcol=seagreen]
>
>.
>|||Hi Guillaume,
You can transfer logins and passwords between instances following the
suggestions mentioned below:
246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
http://support.microsoft.com/?id=246133
If there is any thing unclear, please feel free to let me know.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||I already saw that article, but when i want to copy users
from one Server to another i got an "Unspecified error"
while running the task. But all the users seems to have
been copied...
any suggestion?

>--Original Message--
>Hi Guillaume,
>You can transfer logins and passwords between instances
following the
>suggestions mentioned below:
>246133 HOW TO: Transfer Logins and Passwords Between
Instances of SQL Server
>http://support.microsoft.com/?id=246133
>If there is any thing unclear, please feel free to let me
know.
>Regards,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Hi Guillaume,
Please check the following article to see if it is able to fix your
problem.
305365 PRB: DTS Package Fails with "Unspecified Error" Error Message When
You
http://support.microsoft.com/?id=305365
If not, please provide the detailed repro steps so that I can reproduce
this problem on my side and perform further research.
Thank you,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.|||Thanks a lot. This is exactly my problems...
how bizzarre that they don't edit this error message to
give us something more specific :P

>--Original Message--
>Hi Guillaume,
>Please check the following article to see if it is able
to fix your
>problem.
>305365 PRB: DTS Package Fails with "Unspecified Error"
Error Message When
>You
>http://support.microsoft.com/?id=305365
>If not, please provide the detailed repro steps so that I
can reproduce
>this problem on my side and perform further research.
>Thank you,
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>