Question about Computers & Internet
I am developing an accounting software in SQL Server 2000.
I want to create blank tables, stored procedures, user defined functions in new database which i am using in the last year's database.
I am using VB6.0 as front end tool and SQL Server 2000 as database.
My question is :
How programitically transfer Stored Procedures and UDF from last year's database to new year's database ?
Information : I created new year's database using SQL DMO, I created tables using script and executing it from stored procedure.
But I am not being able to tranfer the last year;s stored proc and udf to new year's database using vb code or vbscript code.
Please guide me through.
my email id is : firstname.lastname@example.org
An easy way to transfer objects (tables, user defined functions, stored procedures, etc.) is to use Enterprise Manager's "Generate SQL" feature. Use this process at your own risk. Doing it wrong could mess up your existing database.
1. In Enterprise Manager, right-click on the old database and choose "All Tasks" then "Generate SQL Script".
2. In the dialog that comes up, click "Show All" then select the checkboxes for "all stored procedures" and "all user defined functions". (You might also want to check some other boxes, depending on your exact situation.)
3. Click the "generate" button and save the script that it creates.
4. Run the script in the NEW database.
If you run the script in your OLD database, it may destroy your objects, and that would be very bad. Make sure you run the script in your NEW database. (While we're on this subject, it's a good time to mention that you should back up your database before you start this process, and you should make changes to a test system before migrating it to production.)
That should move your stored procedures and user defined functions over.
You can use a similar process to move tables, views, users, and other objects over as well.
Posted on Jan 17, 2008
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
Tips for a great answer:
Dec 07, 2017 | The Computers & Internet
May 29, 2015 | Sun MySQL
May 13, 2015 | Microsoft SQL Server 2005 Enterprise...
Nov 28, 2014 | Microsoft SQL Server 2000 Standard Edition...
Nov 06, 2014 | Microsoft SQL Server 2005 Standard Edition
Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
Feb 11, 2008 | Microsoft SQL Server 2000 Standard Edition...
205 people viewed this question
Usually answered in minutes!