need simple SQL statement to copy table in classic asp
Budget $10-30 USD
Simple SQL Statement needed for Classic ASP routine
There are two nearly identical databases
DBOrig and DBCopy
Both databases (which happen to be on different IP addresses but within the same network) contain the same table definition/structure for the table TEST
I need a simple SQL statement or two that will copy all the records from [login to view URL] to DBCOPY.test. Ideally, it should be an ‘append’ or ‘insert’ Snippet of subroutine is below. It is NOT an option to list all the field names (over 100 fieldnames)
‘===================================================================
sub CopyData(TableName)
dim rsCopy, objCopy, SQLCopy, Connect1
dim rsOrig, objOrig, SQLOrig, Connect2
' Routine copies the entire table from rsOrig to rsCopy
Connect1="UID=********;PWD=*********;Driver={ODBC Driver 17 for SQL Server};Server=192.168.101.x\SQLExpress;Database=SF-Master;"
Connect2="UID=********;PWD=*********;Driver={ODBC Driver 17 for SQL Server};Server=192.168.101.y\SQLExpress;Database=SF-Master;"
set objOrig = [login to view URL]("[login to view URL]")
[login to view URL] Connect2
set RsOrig = [login to view URL]("[login to view URL]")
SQLOrig = "Select * from Test"
[login to view URL] SQLCopy, objCopy, adOpenForwardOnly, adLockOptimistic
set objCopy = [login to view URL]("[login to view URL]")
[login to view URL] Connect1
set RsCopy = [login to view URL]("[login to view URL]")
?????? SQLCopy = "INSERT INTO (" & TableName & ") SELECT " & TableName & "." & FROM " & TableName * DELETE FROM " & table
[login to view URL] SQLCopy, objCopy, adOpenForwardOnly, adLockOptimistic
End sub
10 freelances font une offre moyenne de 28 $ pour ce travail
Hi I have 15+ years of experience. I will write the script to copy the data from one table to another in different server. Look forward to hear from you. Regards
Hi, I am interested to your project, since I have great experience in classic asp with more than 15 years experience. Your requirement is clear, but classic asp is limited doing some queries. can be done with loopin Plus
Hi there, I have go through your job description. I am really excited with this job. I am an experience T-SQL developer with more than 9 years experience. I am able to done any kind of project using this skill. I hav Plus
I can develop required SQL query in a most qualitative way because I am highly qualified SQL developer with a long term professional experience.
Hello, good day. I reviewed your requirements and ready write sql query which will copy data from one table to another. I have 5 years of experience in database development. Let's discuss in details Thanks Faisal
Hi There, *** I have gone through the requirement and can complete the project efficiently *** Check below link on my profile for reviews and portfolio items; https://www.freelancer.com/u/deeptimayipadhi I have 9 Plus
Hello I have lopot of experience in classic Asp. And this can done in asp and sp. I'm interested in this task. Hoping to hear from you soon. Thanks
Having 7+ year working experience in Software Development.I always provide quality solutions to complex business problems within scope, budget and tight schedules. Possess excellent knowledge of Web Applications . Deve Plus
Hi there, I am interested to do this task as it matches my skills. You'll get quality work in affordable price. Just send the message to discuss details. Have great day.
Hi, I am Mohammed Ahsan. I have 4+ years of experience in C#, ASP.NET, MVC, VBSCRIPT and VB6 I have worked for Hospital and Laboratory management system. I am best fit for your task. I will provide you quality work as Plus
