Database Administrator - MsSQL - Replication
Budget: $10 – $100 AUD
A Microsoft SQL Server expert is sought for assistance in setting up replication between two databases.
The database is for a project that is still in the development stage.
There are two parts to the project:
WSD.db - this is to support the web based application
LBD.db - this is to support the mobile application
There are only a few tables that are common between the databases
userCredentials
userData
(a couple of others that will be discussed in private)
These tables have been created in both DBs during development for testing and development of the respective applications.
I have attempted to set up replication (WSD being the publisher and LBD as the subscriber) but then ran into issues with userCredential.tbl due to foreign keys.
When removing the replication, this has caused issues with replication info not being purged from the system (Replication) DB.
Your task:
1. Clean out any ghost entries from System DB left over from past replication attempts
2. Setup replication of the required tables.
3. Ensure that the keys are in place and happy.
To complete this task, you can either RDC into the server or connect remotely with SQL Management Studio - however, you'll need to share your screen while you're working.
In your bid:
i. Write 'July' on the first line
ii. Provide an estimate of how long to complete the task
iii. Whether your bid amount is a set price or per hour
iv. Whether you're interested in ad-hoc SQL maintenance tasks.
The database is for a project that is still in the development stage.
There are two parts to the project:
WSD.db - this is to support the web based application
LBD.db - this is to support the mobile application
There are only a few tables that are common between the databases
userCredentials
userData
(a couple of others that will be discussed in private)
These tables have been created in both DBs during development for testing and development of the respective applications.
I have attempted to set up replication (WSD being the publisher and LBD as the subscriber) but then ran into issues with userCredential.tbl due to foreign keys.
When removing the replication, this has caused issues with replication info not being purged from the system (Replication) DB.
Your task:
1. Clean out any ghost entries from System DB left over from past replication attempts
2. Setup replication of the required tables.
3. Ensure that the keys are in place and happy.
To complete this task, you can either RDC into the server or connect remotely with SQL Management Studio - however, you'll need to share your screen while you're working.
In your bid:
i. Write 'July' on the first line
ii. Provide an estimate of how long to complete the task
iii. Whether your bid amount is a set price or per hour
iv. Whether you're interested in ad-hoc SQL maintenance tasks.