Hi,
Anybody have an idea of copying data from tables of a database to another
database. It should be a choice to select all tables, single table or
several tables.
For them knowing Oracle it is possible to do it with 'exp', where you can
choose to script the database with or without data. So I am trying to get
alike to MSSQL. The job is to unload data from a database with one
structure to another database with another structure.
Thanks in advance
Best regards
Tom Frank
4  35416 
"Tom Frank" <to****@hotmail .com> wrote in message
news:40******** *************@d read12.news.tel e.dk... Hi,
Anybody have an idea of copying data from tables of a database to another
database. It should be a choice to select all tables, single table or
several tables.
For them knowing Oracle it is possible to do it with 'exp', where you can
choose to script the database with or without data. So I am trying to get
alike to MSSQL. The job is to unload data from a database with one
structure to another database with another structure.
Thanks in advance
Best regards
Tom Frank
If both databases are on the same server, then INSERT ... SELECT ... is
fastest:
INSERT INTO dbo.ThisTable
(col1, col2, ...)
SELECT col1, col2, ...
FROM ThatDatabase.db o.ThatTable
If the databases are on different servers, then you can check out bcp.exe or
DTS. bcp.exe dumps/loads table data (or the results of a query) to/from a
flat file; DTS is an ETL tool, which is useful for more complex operations,
but the Import and Export Data wizard can quickly create a basic package for
copying data.
Simon
"Tom Frank" <to****@hotmail .com> wrote in message news:<40******* **************@ dread12.news.te le.dk>... Hi,
Anybody have an idea of copying data from tables of a database to another
database. It should be a choice to select all tables, single table or
several tables.
For them knowing Oracle it is possible to do it with 'exp', where you can
choose to script the database with or without data. So I am trying to get
alike to MSSQL. The job is to unload data from a database with one
structure to another database with another structure.
Thanks in advance
Best regards
Tom Frank
Hi, use SQL-Scripter to copy your data. http://www.sqlscripter.com
Best regards,
Thomas
Hello,
I am trying to convert a single code page MS Server database into a unicode
database, using the unicode data types,NCHAR, NVARCHAR, NTEXT. The problem
is that in the original database, indexes and constraints have been defined
on the tables whose configuration needs to be changed. As a result, the
ALTER TABLE command fails. Are there any other alternative solutions?
It would be great if you could help!
Thanks,
Sheetal.
Hello,
I am trying to convert a single code page MS Server database into a unicode
database, using the unicode data types,NCHAR, NVARCHAR, NTEXT. The problem
is that in the original database, indexes and constraints have been defined
on the tables whose configuration needs to be changed. As a result, the
ALTER TABLE command fails. Are there any other alternative solutions?
It would be great if you could help!
Thanks,
Sheetal.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: mark4 |
last post by:
Hello,
Are there any utilities to help me extract Content from HTML ?
I'd like to store this data in a database.
The HTML consists of about 10,000 files with a total size of
about 160 Mb. Each file is a thread from a message forum. Each
thread has several contributions. The threads are in linear
order of date posted with filenames such as 000125633.html. The
|
by: caine |
last post by:
I want to extract web data from a news feed page
http://everling.nierchi.net/mmubulletins.php.
Just want to extract necessary info between open n closing tags of
<title>, <categoryand <link>. Whenever I initiated the extraction,
first news title is always "MMU Bulletin Board RSS Feed" with the
proper bulletin's link stored, but not the correct news title being
stored.
Necessary info only appears within <itemand </itemwhich consists...
|
by: napolpie |
last post by:
DISCUSSION IN
USER nappie writes:
Hello, I'm Peter and I'm new in python codying and I'm using parsying
to extract data from one meteo Arpege file. This file is long file and
it's composed by word and number arguments like this: GRILLE EURAT5
Coin Nord-Ouest : 46.50/ 0.50 Coin Sud-E
Hello,
I'm Peter and I'm new in python codying and I'm using parsying to
extract data from one meteo Arpege file.
|
by: edwire |
last post by:
I'm trying to extract data from 3 textboxes to another line in the same page using the onblur command.
My client inputs their 5 digit zipcode and OnBlur fills the city and state from a database without refreshing.
I want to be able to extract or grab the info from the textboxes: zipcode, city, and state and place it at the top of the form at the same time when OnBlur is executed, in other words I want Onbllur to execute the auto fill in...
|
by: tim999 |
last post by:
Dear all,
I have a question regarding indexes on a data extract database we have - MSSQL2000.
Each night a scheduled job:
1. Deletes the indexes
2. Truncates the table data (empties the tables of all data)
3. Imports the latest data from a UNIX database
4. Recreates the indexes.
| | |
by: clai83 |
last post by:
mysql and mysqli functions always return strings values, and I understand that I can set the type of the data via the settype function AFTER I extract the data, but is there a way with PHP to extract the data as it is specified in the mysql database? (i.e if the type is an integer then PHP will insert the integer value in the result set).
The reason I ask is I want to create a function to verify the integrity of the database before I process...
|
by: =?Utf-8?B?aWxy?= |
last post by:
Hi
This is probably fairly simple but I am newish at programming and was
wondering if someone can give me some advice on handling the following.
I have an array with a large number of elements in it. 0-9 are related
data, 10-19, 20-29 are related and so on. What is the best way of extracting
groups of elements from the array into another array where each element is
the related data or to extract say elements 0,1,5 from the first...
|
by: veer |
last post by:
Hi
i am making a program in which i want to extract data from html file .
Actually there are two dates on html file i want to extract these dates but the main probleum is that these dates are different on each file. A word "AKTIVA" is always comes before these dates.
i made this by seaching the activa word but after this i am not getting any idea how these dates can be accessed.
i use one another method by transfering the whole data of...
|
by: SteveB |
last post by:
I have posted this question in the Visual Basic 2005 and Visual
Basic .Net 2005 discussion groups, also.
Hi. I am developing an application/web page with VB.Net that will
populate a SQL database from text extracted from PDF documents.
However, I am having a difficult time finding or developing the
appropriate code to convert the PDF streams into text strings. Has
anyone developed code to convert PDF's to Text?
I was able write a...
|
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: 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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |
