Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replication of a table with more than 255 columns
Message
De
30/03/2001 12:26:13
 
 
À
26/03/2001 11:15:14
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Réplication
Divers
Thread ID:
00488593
Message ID:
00490367
Vues:
8
You could

1) Break the table up into smaller tables, with none of these new tables having the same name as the old table.
2) Create a SQL Server view that joins these tables back together. Name this view the same as the old table.

Code that accessed the old table shouldn't have to be changed.
This might also improve performance, since when you select specific fields from a view, it will only hit the tables it needs to.

Of course, I'm not sure where the code you indicate would have to be changed is located. :)

>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
Insanity: Doing the same thing over and over and expecting different results.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform