Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replication of a table with more than 255 columns
Message
From
26/03/2001 11:15:14
Guy Barrette
Lasalle, Quebec, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Replication
Title:
Replication of a table with more than 255 columns
Miscellaneous
Thread ID:
00488593
Message ID:
00488593
Views:
36
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
Next
Reply
Map
View

Click here to load this message in the networking platform