First a little background.
Production server is SQL Server 2000. Various clients will be installing a desktop version of our web application. The desktop app will be running SQL Server 2005 Express (MSDE replacement, correct?). When the client downloads the package, the installer will import their data from the SQL Server 2000 production database into the SQL Server 2005 database. The production database contains numerous clients, so it doesn't make sense to migrate ALL of the data, only the data that belongs to the client.
My question is what method(s) would allow this to be done? The databases will NOT be connected to one another so using DTS packages is not an option.
After doing some research I came to the conclusion that the only way I could see this working, would be to output each tables data (just the data that belongs to the particular client) into its own text file and then import them individually on the SQL Server 2005 side.
Does anyone have any other ideas?
Kevin - I have the same dilemma currently and wondered if you had found a solution to this?
No comments:
Post a Comment