Re: Replication/synchronization in a SQL Server 2K db

From: Val Mazur (group51a_at_hotmail.com)
Date: 03/06/04 

Date: Fri, 5 Mar 2004 22:31:40 -0500

Hi,

1. Yes, you could replicate database. See next KBs about it

http://support.microsoft.com/default.aspx?scid=kb;en-us;321822&Product=sql

http://support.microsoft.com/default.aspx?scid=kb;en-us;324992&Product=sql

http://support.microsoft.com/default.aspx?scid=kb;en-us;190797&Product=sql

2.Yes, you can modify structure of the tables. You could do this using ALTER
TABLE or other DDL statement. You could simply execute them using Execute
method of ADO Connection

MyADOConnection.Execute "ALTER TABLE ...."

Another way to alter database is to use SQL DMO COM library from VB. 

-- 
Val Mazur
Microsoft MVP
"Oscar" <oku@xs4all.nl> wrote in message 
news:40475b4b$0$115$e4fe514c@dreader10.news.xs4all.nl...
>I am considering to port a VB-Access to a VB MS SQL Server 2K. The main
> reason for this is to achieve a robust database application that can be
> accessed by more than 10 users and also from the internet. One of the main
> goals is also replication/synchronisation facilities. Does SQL server 2K
> feature database replication/synchronisation abilities such as remote 
> users
> who can connect by a laptop around the internet in order to synchronise 
> the
> data ?
>
> Another issue is the possibility to edit the database structure (adding 
> and
> editing tables and fields by VB code). Is that possible within a VB-MS SQL
> server 2K environment ?
>
> regards,
> Oscar
>
>

Relevant Pages

  • Re: Restoring database with different COLLATION
    ... > How I can modify the COLLATION of the database after restoring it? ... as SQL Server 2000 supports different collations and sort orders for each ... ALTER DATABASE db_name ... ALTER COLUMN VARCHAR ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL Server Role Security
    ... Columnist, SQL Server Professional ... create/alter table structures in a particular database. ... them rights to alter the database itself just rights to alter the structures ... permissions on a table in the development database the design option is ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server Role Security
    ... Columnist, SQL Server Professional ... create/alter table structures in a particular database. ... them rights to alter the database itself just rights to alter the structures ... DevAdmin is a Windows 2K Group containing the developers. ...
    (microsoft.public.sqlserver.security)
  • Re: How to Rename Database Files
    ... Earlier in the thread I told the original poster he could use ALTER ... DATABASE to change the logical file names. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)