Re: Membership download

Thanks for this response. I accept that Membership Databases cannot be transferred.
It is very unfortunate.

JRL

"Charles Wang[MSFT]" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in message news:uuwcDLDiIHA.6264@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Jrl,
SSIS task does not include the property for ALTER AUTHORIZATION ON SCHEMA.
That is just one way for your manually resolving conflictions.
Backup/restore is a common way for data transfer, however it still does not
include transferring logins. Before SSIS task, we often recommend customers
referring to this KB article to perform the whole process:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

With SSIS transfer object task, if your destination server has no logins,
user roles etc same as your source server, you can perform a straight
transfer; otherwise you need to first manually resolve the confliction or
just transfer database objects without users, logins, roles etc. If you are
familiar with .NET development, you may consider using SMO assemblies to
develop an application for transferring data between databases. This can
give you some custom functions. By this method, you can implement
confliction revolving logic in your custom functions. For example, you can
check logins on your source server and destination server, for those logins
not existed on your destination server, you can directly transfer the
logins; for those same logins, do not transfer them, but after the transfer
completes, apply the related permissions to those same logins on the new
database.
You may refer to:
Transfer Class
http://technet.microsoft.com/es-es/library/microsoft.sqlserver.management.sm
o.transfer.aspx

Regarding this issue, I think that we can make a conclusion now. Actually
there is no straight way to fully satisfy your requirements in a SSIS task;
however you can develop an .NET application by using SMO assemblies for
resolving the complex requirements.

If you have any other questions or concerns, please feel free to let me
know.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================






.

Relevant Pages

  • Re: Membership download
    ... SSIS task does not include the property for ALTER AUTHORIZATION ON SCHEMA. ... With SSIS transfer object task, if your destination server has no logins, ... confliction revolving logic in your custom functions. ...
    (microsoft.public.sqlserver.dts)
  • Re: object level permissions being lost when migrating
    ... I first transferred the logins from the 2000 server to the 2005 server via ... I then restored the databases and re-synched the users via the ... Errors After Restoring Dump ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Logins do not have database access
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... created all user logins before restoring the databases. ... A few users are SQL Server logins. ...
    (microsoft.public.sqlserver.security)
  • Re: sql 2008 evaluation edition upgrade
    ... your databases that's why I told you about BACKUP command. ... If you want to transfer your Logins, you can use some scripts or SSIS' s ... restore logins. ...
    (microsoft.public.sqlserver.setup)
  • db_owners unable to see login list
    ... add new users to their databases, despite the fact that logins exist ... for these users on the server. ... look at the logins, the complete list is not presented to them. ... assign them to server-level security roles, ...
    (comp.databases.ms-sqlserver)
Loading