SQL Server 2000
Is there any way to take sample data in my database and create an INSERT INTO script?
I have a commercial application that I would like to include sample data, and instead of restoring a backup like I am doing now, I would like to first run a script that creates the database, stored procedures, etc, then run a script that inserts sample data if the customer so chooses.
I know I can do this manually, but is there any way to create the script based on exisiting data?
TIA
--
Tim Morrison
--------------------------------------------------------------------------------
Vehicle Web Studio - The easiest way to create and maintain your vehicle related website. http://www.vehiclewebstudio.com 4  4269 
Tim,
You can use our free tool, QALite or ObjectScriptr to generate insert
statements. You can download it from site.
--
-oj http://www.rac4sql.net
"Tim Morrison" <sa***@kjmsoftw are.com> wrote in message
news:J%1Lb.7617 23$HS4.6022647@ attbi_s01...
SQL Server 2000
Is there any way to take sample data in my database and create an INSERT INTO
script?
I have a commercial application that I would like to include sample data, and
instead of restoring a backup like I am doing now, I would like to first run a
script that creates the database, stored procedures, etc, then run a script that
inserts sample data if the customer so chooses.
I know I can do this manually, but is there any way to create the script based
on exisiting data?
TIA
--
Tim Morrison
--------------------------------------------------------------------------------
Vehicle Web Studio - The easiest way to create and maintain your vehicle related
website. http://www.vehiclewebstudio.com
"Tim Morrison" <sa***@kjmsoftw are.com> wrote in message news:<J%1Lb.761 723$HS4.6022647 @attbi_s01>... SQL Server 2000
Is there any way to take sample data in my database and create an INSERT
INTO script?
I have a commercial application that I would like to include sample
data, and instead of restoring a backup like I am doing now, I would
like to first run a script that creates the database, stored procedures,
etc, then run a script that inserts sample data if the customer so
chooses.
I know I can do this manually, but is there any way to create the script
based on exisiting data?
TIA
--
Tim Morrison
-------------------------------------------------------------------------
-------
Vehicle Web Studio - The easiest way to create and maintain your vehicle
related website.
http://www.vehiclewebstudio.com
--
You could use BCP/DTS to load the sample data from external files, but
if you want to use pure TSQL, then this is one possibility: http://vyaskn.tripod.com/code.htm#inserts
Simon
Looks like ObjectScriptr is just what im looking for.
Thanks,
Tim Morrison
"oj" <no**********@h ome.com> wrote in message
news:JN7Lb.7819 98$Fm2.760879@a ttbi_s04... Tim,
You can use our free tool, QALite or ObjectScriptr to generate insert
statements. You can download it from site.
--
-oj
http://www.rac4sql.net
"Tim Morrison" <sa***@kjmsoftw are.com> wrote in message
news:J%1Lb.7617 23$HS4.6022647@ attbi_s01...
SQL Server 2000
Is there any way to take sample data in my database and create an INSERT
INTO script?
I have a commercial application that I would like to include sample data,
and instead of restoring a backup like I am doing now, I would like to first
run a script that creates the database, stored procedures, etc, then run a
script that inserts sample data if the customer so chooses.
I know I can do this manually, but is there any way to create the script
based on exisiting data?
TIA
--
Tim Morrison
--------------------------------------------------------------------------
------
Vehicle Web Studio - The easiest way to create and maintain your vehicle
related website.
http://www.vehiclewebstudio.com
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Don |
last post by:
I want the server-side php script to return a browser page that is essentially a copy of the
original client page that contained the <form> which referenced the php script in the first place.
However, the php script will need to change a couple html lines in that returned page. I sure could
you some help on how to go about this.
Thanks in advance,
Don
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
|
by: Joshua Beall |
last post by:
Hi All,
I am working on a registration system, and one of the things I am going to
need to be able to do it setup the database tables for each event that I
have registration for. Normally I would do this by hand, but I am wondering
if there are any code libraries out there that could generate the SQL for
me.
Basically I would have a list of column names and types. I know I could
just foreach() through the list, with a switch to...
|
by: PK |
last post by:
Hello,
I am looking for help on the following. I'm trying to create a custom
browser toolbar button that will do a few things. One that I'm trying
to do at the moment is just simply return the URL of whatever page the
user is visiting.
I wanted to create a Win32 application using VB.NET. If there is a
better way of doing this please let me know. I assume there needs to
be some sort of client side code. I was originally leaning...
|
by: Robin Tucker |
last post by:
Hi there,
I have a database on my test machine that will need to be installed on users
machines. I would like to create the database with the given schema on the
users machine and also with some suitable default values in the tables. I
note that although I can script the schema so that re-creating the structure
of the database is simple on the users machine, I cannot script the contents
of the tables also (automatically). What I would...
|
by: Don Stefani |
last post by:
Hello,
I have a form that I want to submit "onchange", OK I've got that working, but when the
form submits, I want to pass along a value to a CGI script, as if that value was in a
hidden form element.
BUT, I don't want that value to be in the actual HTML form, I want it to be created in my
submit function.
For instance:
| | |
by: |
last post by:
Trying to learn about manipulating collections of objects, and populating
these objects dynamically from datasources. Could someone post a code sample
that shows the following:
Instantiating a collection object -- say, a dictionary.
Populating that collection object with custom objects, say, Person. What I
really want to see is how to populate the properties of those Person objects
from a datasource: instantiate one Person, fill...
|
by: Kris |
last post by:
Problem with getting data out of injected script
template.html contains the following html and is located at
http://example.com/template.html:
<html>
<head>
<title></title>
</head>
<body>
|
by: kret |
last post by:
Hi,
this is my first post so first of all I would like to say hello :)
Now getting to my problem.
In my job I have to create an ActiveX control in .NET 1.1 that can be
lunched from IE.
This part is done but next requirement is that after closing ActiveX I
have to redirect parent page to location X or Y depending on how the
|
by: skyson2ye |
last post by:
Hi, guys:
I have written a piece of code which utilizes Javascript in PHP to create a three level dynamic list box(Country, States/Province, Market). However, I have encountered a strange problem, and I have spent three days trying to debug but to no avail.
Everything is OK when there are only two dependent list boxes, but when adding the third child list box, a problem appears: if I populate the third box only with the value: new...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
