Membership download

I'm fairly new to using SSIS, but I have learned how to download the contents of a custom database to a local development server (both with SQL 2005). Now I am trying to learn how to download a copy of the membership (all the tables related to applications, logins, roles, profiles).

At first I tried using the wizard to transfer these tables, but it resulted in an error related to foreign keys:
[Execute SQL Task] Error: Executing the query "TRUNCATE TABLE [aspnetdb].[dbo].[aspnet_Roles] " failed with the following error: "Cannot truncate table 'aspnetdb.dbo.aspnet_Roles' because it is being referenced by a FOREIGN KEY constraint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

So then I tried using the tranfer logins task. I thought it might transfer the login accounts, but after setting it up and running it (successfully), I notice that there are no data flow items, and the results are [Transfer Logins Task] Information: "There are no logins transferred.".

I would like to completely overwrite my local aspnetdb database with all the membership data that has been collected on a webserver.

Can you give me a procedure for this, or a link to instructions?

(SSIS is using VS2005. If coding is involved, my preferred environment is VS2008 and C#).

Many thanks for any help or instruction you can offer.

.

Relevant Pages

  • Re: WINSSH.EXE and WINSRT.EXE SQL Virus
    ... | SQL v7 or SQL 2000. ... * propagates to machines vulnerable to the following exploiting RPC/RPCSS DCOM and LSASS ... You need to downlaad the following tool to all infected computers and download the needed ... This will bring up the initial menu of choices and should be executed in Normal Mode. ...
    (microsoft.public.security.virus)
  • RE: Error installing (KB 921896)
    ... wonder if there is a way to wipe the download from my system and start over. ... Installation status: Failed ... This service pack upgrades all Microsoft SQL Server 2005 Express Edition ...
    (microsoft.public.windowsupdate)
  • Re: Services not listed on Configuration Manager screen?
    ... That's a very odd version! ... I don't remember under which build number SP2 was originally released as, ... there you should be able to find a download. ... Links for SQL Server Books Online: ...
    (comp.databases.ms-sqlserver)
  • Re: 932557 64 bit Error Code: 0xA97 Update is not allowed to down
    ... The Windows Update has been trying to update this one since before the fourth ... is inaccessible to me through SQL Manager. ... I think the reason the update is not allowed to download is ... Sequence 2940 vs AcceptRate 2513. ...
    (microsoft.public.windowsupdate)
Quantcast