Member Avatar for stoneferry

Or should I say just making sure all columns are created and proper.

I have 6 databases I need to keep maintained to a similar level, all standalone.

What is the best way to keep the schemas up to date without resorting to manually updating...? Obviously I cannot use DROP table or CREATE table based scripts. Data replication is not required.

Cheers

  • 2 Contributors
  • 1 Reply
  • 76 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by cutepinkbunnies
Member Avatar for cutepinkbunnies

You could configure and adjust SSIS packages every time you add a table, for all 6 databases...or you could replicate (most practical solution IMO).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.