Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replication of a table with more than 255 columns
Message
De
26/03/2001 11:15:14
Guy Barrette
Lasalle, Québec, Canada
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Réplication
Titre:
Replication of a table with more than 255 columns
Divers
Thread ID:
00488593
Message ID:
00488593
Vues:
37
Hello,

I have a table with 650 fields that I need to replicate.
SQL Server 2000 replication limits you to table with 255 fields or less.

What would be my options here ?
1-Push all records with a DTS (too long)
2-Break the table into smaller ones (too much code changes)
3-Push the changes with a DTS (too much code changes)

Any other options ?


Thanks
Guy Barrette, MCSD
============
Blog http://weblogs.asp.net/guybarrette
Microsoft Regional Director, Montreal, Canada www.microsoft.com/rd
MVP, ASP.NET http://mvp.support.microsoft.com/
President, Montreal Visual Studio User Group www.guvsm.net
INETA Regional Rep for Quebec www.ineta.org
UniversalThread Magazine Columnist (.NET Books Review Column) www.utmag.com
Tech Chair French Track, DevTeach 2004 & 2005 www.devteach.com
Business Architect, Microsoft Team - Nurun Inc www.nurun.com
XBox Live Gamer Tag: Slomo QC CA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform