MS SQL - Program to Copy Views into Tables Between 2 Databases Nightly


We have two MS SQL 2008, databases. They are unlinked and on two separate servers. Due to security restrictions beyond my control - this situation exists.

Database "A" (Restricted) - contains many VIEWS that have the data we need. There are no tables. The vendor only provides us with selected datasets as VIEWS. We cannot change this. Every night this database schema and contents is updated at close of business, so we need to run a script/application to move the latest nightly copy into Database "B" that we can manipulate for reporting.

We need the data within these VIEWS moves into Database "B" (unrestricted, our server), and placed into matching TABLES with the same naming conventions and data types (referential integrity not required).

We're looking for a VB script / application that can be placed on our Windows machine and run nightly by scheduler. It should...

- Clear out Database "B".

- Copy the latest VIEW "schema" from Database "A" into matching TABLES in Database "B".

- Copy the contents from VIEWS in Database "A" and place into new matching TABLES in Database "B".

- Done.

It must also have the following functionality...

- If the process is successful, send a text email with the results of the activity, "Copy Successful, # tables copied, # records" (something like that).

- If the process fails, send a text email with failure notice.

- The connection parameters for both databases (username, password, host, port, database, etc), should be editable either from an text config type file or within a user interface (whatever is cheapest, easiest).

- The notification email address for success or failure, also editable in the same text config file or user interface

The deliverable would be a working application along with the source code - but ideally we would like to continue working with you longer term as our needs for this may change in the future.

Skills: Database Administration, SQL, Visual Basic

See more: copy views databases, sql database business, my sql databases, activity connection, clear copy, to copy, sql views, SQL Server Reporting, Sql reporting, sql business, night view, MS sql, move sql, databases, database copy script, scheduler program, copy email address, schema sql, copy tables, sql move data, script text manipulate, script views, program email notification, unrestricted, scheduler application

About the Employer:
( 16 reviews ) Allentown, United States

Project ID: #4309622

32 freelancers are bidding on average $171 for this job


I have done a couple of applications kind of similar to this one. Please check PM for more details.

$200 USD in 4 days
(9 Reviews)

Hi! I can help you provide a windows desktop application.

$200 USD in 7 days
(104 Reviews)

Hello. Please check PM. Thanks.

$200 USD in 3 days
(7 Reviews)

I can do well, please see PMB for details

$85 USD in 5 days
(23 Reviews)

please refer to my private message

$200 USD in 5 days
(19 Reviews)

Hi, I can think of an easy and elegant way to do this. Please see PM for details.

$200 USD in 3 days
(14 Reviews)

Hi, Please check PMb.

$200 USD in 7 days
(18 Reviews)

I have 7+ experience in and SQL programming. Let me know if you are interested to work with me, so that we can discuss the further details. -Amit

$60 USD in 3 days
(15 Reviews)

Expert in VB & MSSQL. Ready to start.

$180 USD in 3 days
(25 Reviews)

Hi Please see PMB for more details. Best, Sandeep

$150 USD in 1 day
(5 Reviews)

Dear Sir, I am ready to work with you, I will promise that you won't disappoint my work, 100% satisfaction, please see PM

$190 USD in 5 days
(5 Reviews)

Hello. I'm an experienced developer with multiple Microsoft certifications (MCP, MCT, MCAD, MCSD, MCDBA). I own a deep experience on .NET development and Microsoft database systems. I'm also a writer contributor with More

$170 USD in 3 days
(3 Reviews)

Hi, Please check private message. thanks.

$150 USD in 2 days
(8 Reviews)

I have been using MS SQL from the first version and VS since version 6.0 Have written may apps that synchronize between two databases. Let me help you out with your application.

$150 USD in 3 days
(2 Reviews)

I'm able to do this work. Please Check PMB

$55 USD in 3 days
(7 Reviews)

Hello, I am interested to do this job. Thanks

$100 USD in 7 days
(11 Reviews)

I am a professional web application developer working on Microsoft technologies since 2000 i have the following skills . Working upon ASP.Net, C#, DotNetNuke, SQL Server,css , jquery , javascript , html5 ,Photoshop More

$50 USD in 3 days
(4 Reviews)

Hello. I'm free to work on this tonight (NY Time), and hopefully have it done for you asap. I would use (hopefully) CLR inside of MSSQL 2005 or greater and VB.NET from Visual Studio 2010. I would schedule it usin More

$250 USD in 3 days
(2 Reviews)

Hi I can help you get it done by automating it using sql scripts and batch files. Let me know if you find my profile interesting. Thanks

$100 USD in 4 days
(0 Reviews)

My experience in developing .net database applications give me good experience how to deal with databases especially that i am responsible on copy data from online one to local different schema. also i can give you fu More

$140 USD in 3 days
(0 Reviews)