Re: SQL Server 2005 Restore Error

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I think that both your suggested solutions will work, so it's up to you to
decide which one will be best/easiest for you to program.
Depending on which kind of data you want to "replicate" and how big the
amout of data is, you should also look at a way to determine which data has
been changed and then only copy over the changed data.
If you have several users updating the same data, you should also make sure
to handle conflicts correctly. I.e. what happens if two users change the
same record while being offline - which change should then win and should
the other user be notified that his changes has been lost?

If I'm not mistaken, then the SQL Server Express edition only support
replication in the way that it can be a Subscriber to data which means that
it can't replicate data back to the server as you want.

--
Regards
Steen Schlüter Persson (DK)


"Jayakrishnan" <jayakrishnan@xxxxxxxxxxxxxxxx> wrote in message
news:O$erqIQCKHA.1380@xxxxxxxxxxxxxxxxxxxxxxx
You are right jeff. Instead of using replication. We are looking for
alternate solution. We have only sql server express edition in client
machine.

We are planning to run 1... n no of clients. which will not
contact(direct) to server database. It will cause performance issue(onces
in a day this job will run regularly).

Solution 1:
Export data from the client database(Place the exported file to FTP
location.)and import it in server database using SMO. Which might have IO
operation.

Solution 2:
Building sql queries instead of using client database. Move the .sql file
to FTP location. and execute the sql file from server database using SMO.


We are still looking for the best & suitable method to achieve this.

Comments are welcome.

Thanks in Advance.

Jay..


.

Relevant Pages

  • Re: SQL Server 2005 Restore Error
    ... We have only sql server express edition in client machine. ... Export data from the client databaseand import it in server database using SMO. ...
    (microsoft.public.sqlserver.server)
  • Re: Consulting Rates
    ... > What would be a fair hourly rate to charge for a short consulting job using VB.net and SQL 2000 server database. ... you/the client are located, ad infinitum... ...
    (microsoft.public.vb.general.discussion)
  • Re: Recordset Not Updatable
    ... > Server database, ... I was correcting and enhancing the ADP front-end to SQL ... updates by executing individual SQL statements for each control/field that ... But, as Sylvain says, there are many reasons why a recordset is not ...
    (microsoft.public.access.adp.sqlserver)
  • jtds driver and SQL Server performance problem
    ... I am using the opensource jtds driver to retreive information from an SQL ... The java application and the SQL Server database both ... Both tables are fairly large (approx. ...
    (comp.lang.java.databases)
  • Re: Suggestions to reduce memory use when splitting a string
    ... I have written and utility to convert our DOS COBOL data files to a SQL ... Server database. ... We are parsing roughl 81 files and range in size 1 kb to 65 ...
    (microsoft.public.dotnet.languages.vb)