TOPLESS LADIES INSIDE - SQL
-
HA HA I LIED Good day to you all and i hope you are well. Not a direct code question guys, just in need of advice. Imagine this scenario if you will, You have a internet server with a SQL Server 2000 database and a client with a MSDE installation. Both are running the same database say MYDATABASE. MYDATABASE on server is very large, say 100mb. The client needs one table from the server to do the work they wish to do on their local machine. They want to just get that one table (and all related obviously) updated on their machine as they don't need the full database as that would take ages (being 100mb). How would you suggest passing that one table to the client, the client app updating the database on the local machine. Then, once they have done their work they re-connect to the internet server pass back the data they have added/updated and the server then updates accordingly. Any help would be greatly appreciated. My thoughts and ideas so far - DTS (not used this before though), dynamically formed SQL (clunky, unreliable). Pleaaaaaseeee Help Many Thanks Harry
-
HA HA I LIED Good day to you all and i hope you are well. Not a direct code question guys, just in need of advice. Imagine this scenario if you will, You have a internet server with a SQL Server 2000 database and a client with a MSDE installation. Both are running the same database say MYDATABASE. MYDATABASE on server is very large, say 100mb. The client needs one table from the server to do the work they wish to do on their local machine. They want to just get that one table (and all related obviously) updated on their machine as they don't need the full database as that would take ages (being 100mb). How would you suggest passing that one table to the client, the client app updating the database on the local machine. Then, once they have done their work they re-connect to the internet server pass back the data they have added/updated and the server then updates accordingly. Any help would be greatly appreciated. My thoughts and ideas so far - DTS (not used this before though), dynamically formed SQL (clunky, unreliable). Pleaaaaaseeee Help Many Thanks Harry
Please refrain from using that kind of title on this forum. If you expect for people to take your post seriously, please post it with a meaningful name. ~Javier Lozano (blog)