SQL Server Import/Export

In Progress

We require an application to allow us to backup and restore portions of our multi-tenanted database.

The database is an ecommerce system used by multiple websites, each with their own set of records. At the topmost level is a Website with a WebsiteID, below this are other tables, for instance Products, Categories, Orders etc (over 50 tables).

We need to be able to define a single Website to be backed up, possibly to a staging database. All related tables must also be included (Orders, Products, Stock etc. etc.). The relationships should be inferred through foreign key relationships, so that if new tables are added these are automatically included in the backup. Likewise, if new columns are added these should also be included in the backup file without the need to change the source code.

When restoring the data back it is assumed that the schema of the table would not have changed since the backup was made – if it has then the backup will not be restored (we will invalidate them).

If the schema has not changed then it should be possible to restore the backup from the staging database, including all of the relationships. The destination Website would be deleted (if it already exists) and replaced with the backup, there is no need to merge the data into an existing Website. It is vital that the relationships are maintained, so if in the backup and Order with and OrderID of 1234 is made, and it has two products with IDs of 345 and 678 then when restored the Order should still have the same two related products, although the IDs will have changed. This functionality will allow us to merge blocks of related data from several databases into another single database, so IDENTITY_INSERT cannot be used.

Skills: .NET, C# Programming, Database Administration, SQL

See more: sql import relationships, sql server import export data, vital source, import/export, import two, Import Export, foreign export, export stock data, sql schema stock data, net import export, net stock system, stock database schema, data export net, foreign key, sql database import export, schema sql, sql server export import database, export sql, sql server merge data, ecommerce added existing website, import export sql database, import export sql server, sql server export sql, set net website server, Net Backup

About the Employer:
( 8 reviews ) Norwich, United Kingdom

Project ID: #3996226

Awarded to:

shadowdancerlv

My experience with SQL Server and the ETL tools available plus my skills with .Net (C# and VB.Net) give me many options to meet your needs. I look forward to my project paid with non U.S currency!

£250 GBP in 7 days
(8 Reviews)
4.7

22 freelancers are bidding on average £200 for this job

RockStone435

I think the most important point is the last paragraph. I dont know why you dont want to have same IDs. For example, if we set identity insert OFF and copy all records, everything will just go fine. Except, there might More

£220 GBP in 20 days
(112 Reviews)
7.2
sandeep25101982

Hi .Net SQL expert here. Please see PMB Thanks

£250 GBP in 15 days
(36 Reviews)
6.5
aarrsoftware

Thanks for posting this project on freelancer.com and giving us an opportunity to bid on it. We are a team of software professionals and designers. Our team members have varied experience of software development from 2 More

£240 GBP in 25 days
(17 Reviews)
5.3
manhpham

Hi. I am very very interested in your post. Please contact me asap. I am online now. Give me your skype please.

£150 GBP in 2 days
(25 Reviews)
4.7
diegogarcia0531

Hi, I can do the job, Please Check PMB

£250 GBP in 15 days
(12 Reviews)
4.5
reechmeraj

Greetings!!! We are glad to bid on your project and would be more happy if get a chance to work on the same. Please see PMB for details

£250 GBP in 20 days
(8 Reviews)
4.0
amfuries

############# ****** WE HAVE DONE THE SIMILAR APPLICATION PLEASE CHECK THE PM ****** #############

£200 GBP in 5 days
(6 Reviews)
3.9
ajay192

As a standard practice in our disaster management and data loss mitigation procedure, we build in codes in our software to periodically - Please see PMB for details.

£450 GBP in 10 days
(1 Review)
3.0
ritskc

Dear Sir / Madam, We have more than 10 years of experience in IT Field and more over We have handled projects in various domains such as Trading, Manufacturing, Health care Management. I was associated with top c More

£200 GBP in 30 days
(2 Reviews)
2.9
geopin

I have lot of excperience with my sql and MS sql; databases

£100 GBP in 7 days
(1 Review)
2.5
hbxfnzwpf

Familar with SQL, in fact our online-game server was based on SQL. Because we usually do the db-merge work, I think I can do this task for you.

£200 GBP in 12 days
(3 Reviews)
1.8
tomywhitevw

Hi, I was working on a project named "SqlDumper" that was used on an ASP.NET web site. Requirements were for it to work in ASP.NET, and tool was used for creating SQL scripts for recreating data. It took foreign ke More

£220 GBP in 7 days
(3 Reviews)
1.8
EV9iR0f2I

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>

£135 GBP in 1 day
(0 Reviews)
0.0
udul1975

I do understand the requirement and can do it easily. I can do the work easily. I am a developer with 15 years of working experience. Thanks

£200 GBP in 15 days
(0 Reviews)
0.0
billfan88

First name: Bill Surname: Fan I have 8+ years of overall software development experience with 3 years of design, development and deployment of enterprise OO application in .NET Platform. I have application developm More

£200 GBP in 5 days
(0 Reviews)
0.0
suresh6150

Dear sir, I would like to offer my services for your company You can see some of my works at http://www.onlinesic.com/onlinesic http://www.ddimnepal.com/ddimnepal http://www.fmis-fame.com http://rsn-offshore.com More

£100 GBP in 7 days
(0 Reviews)
0.0
lulusl

Hi, I am interested to work with you. I am very much interested to do the project. I can be a good choice, please see my profile for details. Thanks.

£200 GBP in 10 days
(0 Reviews)
0.0
sqlmyfood

Microsoft sql server MVP here, easy task for me to do.

£80 GBP in 5 days
(1 Review)
0.0
djjagrut

I can do this project, for more detail visit my website http://thetransporter.in which is developed by our company,

£300 GBP in 20 days
(0 Reviews)
0.0
MartinJesu5

I have the ability to finish quickly

£100 GBP in 2 days
(0 Reviews)
0.0