Load Balancing/Load Sharing features in SQL Server 2005/2008

I am looking for best solution to perform incremental data load from MySQL database to SQL Server 2008.  I tried to follow instructions from articles on incremental data load in SSIS  using MD5 hashes but I failed to make connection in Lookup transformation editor between MySQL Id (4 byte unsigned integer) and Id in SQl Server 2008 table which is  bigint. i tried to add  data conversion and convert MySQl Id to string. It works fine when you map this field directly to OLEDB destination but in Lookup component it failed. 

Any input greatly appriciated.

SQL 2005 Standard.

Hi I would like to find the best approach to load balancing some SQL 2005 Servers taking in mind also the future scaling out of tens or hundreds servers.

I found this article: http://goo.gl/zP1R that writes about P2P replication, Table partitioning and Database mirroring but:

- P2P replication is limited to 12 servers
- table partitioning is not related to our case
- From what I know Database mirroring is only a high-availability solution, isn't it ?

What do you think ? Which is the best solution ?

Is SQL 2008 better in this area ? Could I upgrade to better meet these points ?

Thanks!

Hi,

Could anyone tell me the features comparision between sql server 2000, 2005 and 2008 in the table format like below.

sql server 2000   features |    Extra features added/supported in 2005 |   Extra features supported in 2008

Note: Please do not give any links.

Thanks.

package 'microsoft sql management studio package' failed to load

I unstall, reinstall SQL server 2008 r2, i id too a repair in the setup of sql serveur 2008 r2.
I also repair Framework .NET 4.0

ouffff.......
Now i don't know what to do.

Is there someone that can help me ?
Pascal

I need complete tutorial about MSSQL 2008 Database mirroring for load balancing

i want to load balance my SQL workload

all database insert update and delete queries will be mirrored

all select queries will be load balanced

sql servers will run at windows server 2008r2 at different computers (VPS)

Get a peek at the new security features in SQL Server 2005 from a developer's point of view. While there are lots of admin enhancements, there are also plenty of dev-specific security improvements you can take advantage of, such as endpoint authentication and support for the security context of managed code that executes on the server. Here Don Kiely elucidates.

Don Kiely

MSDN Magazine June 2005

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004

i cant install sql server 2005 nor 2008 on my windows 7 os

i read about somthing like adding new account when installing sql 2008 to provision the server or so, but didnt know how,,,

can you plz help me??