Server Tables
Posted on Friday, April 6, 2007 in ww2
Server Tables
How to Merge ASPX Membership API Tables W/ Existing Client/Server System Logins?
To whom this may concern,
I have written an ASP.NET extranet for a VB.NET client/server app. It is basically a stripped down version of the client/server app.
I want to use the ASPX Membership API for authorization and authentication. I have opted to place the Membership tables in the client/server application's database. However, I want to automatically update the Membership tables w/ the client/server app's logins, which are stored in different tables, and I can't find a way to update automatically.
I'll need an administration tool to merge the two tables, whether in the extranet or client/server app. Now I could have the tool synchronize whenever it's loaded, or have a button do so, but I'm not sure which is better for usage and performance.
I don't want to synchronize when either app is loaded, as that will hamper performance. Is there a way to schedule a routine merge?
SQL Server 2005.
You could try log shipping to synchronize the tables.
But frankly, I'd just use a SQL Agent Job or triggers on the tables to keep them synchronized. The performance hit will be very negligible.
 |
Vintage Cut Glass Crystal Table Server Dinner Bell | US $19.99 | 12h 3m |
 |
TIFFANY CO STERLING CAKE SERVER FELT COVERBOX BAG PERFECT FOR ANY TABLE | US $105.99 | 18h 22m |
 |
SEI Sofa Server Snack Tray Marble Top Table OC1108 | US $119.99 | 3d 14h 15m |
 |
VINTAGE ANCHOR HOCKING FIRE KING PHILBE SAPPHIRE BLUE TABLE SERVER PIE PLATE | US $14.99 | 1d 3h 11m |
 |
WEXFORD 5 pc TABLE SERVERS SET by ANCHOR HOCKING NIB VINTAGE GREAT CONDITION | US $19.99 | 1d 18h 17m |
 |
ANCHOR HOCKING FIRE KING TAB HANDLES HOT PLATE TABLE SERVER | US $.99 | 1d 20h 10m |
 |
Wood Picnic Table Comployment Server | US $15.99 | 1d 20h 40m |
 |
Shannon Crystal Cake Stand Glass Dome 4 in 1 Server NEW Dress Your Holiday Table | US $49.96 | 1d 21h 16m |
 |
Antique English Oak Barley Twist Tea Trolley Rolling Server Cart Table | US $375.00 | 1d 22h 11m |
 |
MEADOWBROOK HEATHER Pie Server Table Spoon Serving Fork Oneida Rogers 1936 | US $19.00 | 1d 22h 44m |
 |
ALWAYS WILDWOOD Jelly Server Sugar Spoon Serving Fork Pierced Table Spoon 1958 | US $11.00 | 1d 23h 38m |
 |
SALAD DRESSING PITCHER W SEASONING POUCH CORK TABLE SERVER NEW NR | US $.99 | 2d 1h 12m |
 |
Antique English Oak Barley Twist Tea Trolley Rolling Server Cart Table | US $350.00 | 2d 3h 48m |
 |
FRED Table Saw Novelty Cake Food Knife Server | US $7.50 | 24d 20h 1m |
 |
Full Oak Dining Room set table with inserts 6 chairs china cabinet and server | US $659.00 | 2d 13h 25m |
 |
Antique Dining room set 6 chairs table buffet china cabinet server 1930 walnut | US $2,200.00 | 2d 21h 1m |
 |
FIre King Crystal Table Server w tab handles | US $9.00 | 3d 11h 2m |
 |
FIre King SAPPHIRE BLUE Table Server | US $12.10 | 3d 11h 2m |
 |
16 Monogram Lazy Susan M Table Top Great for Center Piece or Server Dinner | US $21.95 | 5d 20h 35m |
 |
SMALL TABLE TOP BENCH SERVER FOOT STOOL WHATEVER | US $20.00 | 3d 12h 7m |
 |
Smuckers Jam Jelly table server with 2 spoons New | US $6.99 | 3d 12h 35m |
 |
VINTAGE FURNITURE OLD WOOD BUFFET SERVER CABINET TABLE HUTCH BOTTOM | US $85.00 | 3d 13h 3m |
 |
Pottery Barn Oil Rubbed BRONZE Christmas Table Silver Serving Server Set NEW | US $18.99 | 3d 13h 29m |
 |
Coffee Serving thermos Large server pitcher Table Carafe | US $29.99 | 3d 13h 40m |
 |
FIREKING HOT PLATE TRIVET TABLE SERVER | US $10.00 | 3d 15h 34m |
 |
Fire King Tab Handled Glass Trivet Table Server | US $7.99 | 3d 17h 25m |
 |
NICE VINTAGE STAINLESS STEEL CONDIMENT SERVER WITH SPOONS TABLE PARTY LOOK | US $7.95 | 3d 18h 25m |
 |
Cecilware S S Table Top Soup Stew Server 7Gal Restaurant Catering Food Service | US $179.75 | 3d 19h 21m |
 |
Rogers Bros Silverplate Oval Meat Serving Tray Platter Large Dining Table Server | US $24.00 | 3d 21h |
 |
SOUTHERN SPLENDOR Cake Pie Server Table Serving Spoon Rogers 1940 Silverplate | US $19.00 | 3d 22h 52m |
 |
WEDGEWOOD ARTIC Oven to Table 12 Cina Stoneware Oval Server Platter NEW England | US $14.99 | 3d 23h 3m |
 |
Bernhardt Oak Dining Set Table 6 Chairs Lighted China Buffet Server NICE | US $995.00 | 3d 23h 6m |
 |
PRECIOUS MIRROR Cake Pie Server 2 Table Serving Spoons Rogers 1954 Silverplate | US $19.00 | 3d 23h 38m |
 |
Unique Glass Water Pitcher 10 Beverage Table Server VGC | US $15.00 | 4d 8m |
 |
Anchor Hocking Ivory White Handled Table Server Fire King Oven Glass 8 round | US $15.00 | 4d 1h 28m |
 |
Renwall server 54 and table D51 both flawed | US $.99 | 4d 2h 54m |
 |
Fine Solid Walnut carved server table 1900 1950 | US $499.00 | 4d 14h 42m |
 |
Antique Identified Silver Servers Styles for Table Reference Book many photos | US $9.95 | 4d 17h 12m |
 |
SHABBY Elegant WHITE Folding TV TRAY Server STAND Table | US $5.87 | 4d 20h 18m |
 |
NordicWare Soufflé casserole dish with insulating table server in original box | US $9.99 | 5d 2h 11m |
 |
OSP 20 Space Shock Mount Amp Rack Computer Server ATA Flight Road Case w Table | US $499.99 | 13d 18h 38m |
 |
sligh vintage country french hall console foyer sofa table server sideboard | US $389.00 | 5d 13h 22m |
 |
GEORGES BRIARD MID CENTURY RETRO FORBIDDEN FRUIT TABLE or BUFFET SERVER | US $23.50 | 3d 22h 2m |
 |
Lenox HOLIDAY GATHERINGS 5Pc Hostess Serving Set Knife Server Pierced Table Meat | US $94.49 | 17d 1h 17m |
 |
Vintage Glass Colony Crafts Table Delights Oil and Vinegar Servers | US $1.99 | 3d 22h 41m |
 |
VINTAGE SALT AND PEPPER SPICE TABLE SERVER | US $12.50 | 5d 16h 27m |
 |
Laptop Table Sofa Server Side Table HandCrafted | US $76.00 | 28d 1h 46m |
 |
antique quartersawn oak table six chairs server sideboard claw feet nice set | US $2,700.00 | 5d 22h 29m |
 |
NEW Traex 48 Oz White Syrup Pourer Table Server | US $11.85 | 17d 16h 35m |
 |
Fire King Oven Glass Table Server Hot Plate | US $7.99 | 6d 58m |
 |
Pewterex Fish 2 Shell Serving Dish Beautiful Item Makes Nice Table Server WW | US $34.90 | 29d 17h 37m |
 |
Enamelware Orange Rd Pan Lid Table Trivet Server Retro | US $14.44 | 29d 12h 33m |
 |
Vintage Fire King 2 quart Casserole Dish with Lid and Table Server | US $13.99 | 29d 11h 20m |
 |
Reed Barton Francis Table Server Spoon 1154031000 | US $338.95 | 29d 8h 2m |
 |
Royal Tahiti 28 Lazy Susan Round Swivel Patio Table Server TT LS 001 28 | US $59.99 | 29d 7h 12m |
 |
MID CENTURY BENT RATTAN SERVER COUCH TABLE 50X15X29 | US $298.99 | 29d 1h 26m |
 |
Southern Enterprises Sofa Server Accent Table Espresso | US $99.99 | 28d 23h 18m |
 |
Southern Enterprises Sofa Server Accent Table Marble | US $119.99 | 28d 23h 18m |
 |
Cherry drop leaf table with server and hutch | US $1,099.00 | 28d 16h 41m |
 |
Oak Cherry Custom Mid Century Sideboard Table Server Chest Buffet | US $1,999.99 | 28d 16h 40m |
Tables Creation in SQL Server 2000
Be the first to comment.