LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 06-05-2011, 03:56 AM   #1
ankit.pandey3
LQ Newbie
 
Registered: May 2011
Posts: 27

Rep: Reputation: Disabled
How to import a SQL Server 2005 database from my system to remote Ubuntu using putty


Hi friends,
I have a database in SQL Server 2005 in my local Windows System and I want to import this database to my linux (ubuntu) server remotely using putty.
I am new in linux.
Please explain step by step...
Thanks in advance
 
Old 06-05-2011, 04:10 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974
what does it mean to import a database into an operating system?? Are you planning on using another database under linux, e.g. postgresql or mysql?? Well firstly dump the database to a suitable ANSI compatible format under windows, and then copy the resulting dump across and then import it into whatever system you're using. None of this has anything really to do with putty though. You may want to copy the file across using winscp though. If you can provide more specific details when you have specific blockers to deal with I'm sure we'll be able to help.

There are, of course, plenty of guides already around that I really hope you've already found... e.g. http://wiki.postgresql.org/wiki/Conv..._to_PostgreSQL

Last edited by acid_kewpie; 06-05-2011 at 04:11 AM.
 
Old 06-05-2011, 04:22 AM   #3
ankit.pandey3
LQ Newbie
 
Registered: May 2011
Posts: 27

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by acid_kewpie View Post
what does it mean to import a database into an operating system?? Are you planning on using another database under linux, e.g. postgresql or mysql?? Well firstly dump the database to a suitable ANSI compatible format under windows, and then copy the resulting dump across and then import it into whatever system you're using. None of this has anything really to do with putty though. You may want to copy the file across using winscp though. If you can provide more specific details when you have specific blockers to deal with I'm sure we'll be able to help.

There are, of course, plenty of guides already around that I really hope you've already found... e.g. http://wiki.postgresql.org/wiki/Conv..._to_PostgreSQL
I mean to say, I have a jar file in which user fill information which i have to save in database. It works properly in windows but I don't know how to do it in Linux(Ubuntu). I already uploaded my jar file in linux server but i don't know what i should do for database....
 
Old 06-05-2011, 04:24 AM   #4
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974
well that wasn't at all what you said... well you first find out what this jar file supports. where did it come from? Do you have support for it? You can't necessarily just point it at a different type of database and have it magically work, it depends how it was written.
 
Old 06-05-2011, 04:28 AM   #5
ankit.pandey3
LQ Newbie
 
Registered: May 2011
Posts: 27

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by acid_kewpie View Post
well that wasn't at all what you said... well you first find out what this jar file supports. where did it come from? Do you have support for it? You can't necessarily just point it at a different type of database and have it magically work, it depends how it was written.
This jar file supports Sql Server 2005 in windows and contains swing and using JDBC-ODBC for Connectivity. What you need to know?? Please tell me....
 
Old 06-05-2011, 12:53 PM   #6
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,961

Rep: Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693
Quote:
Originally Posted by ankit.pandey3 View Post
I mean to say, I have a jar file in which user fill information which i have to save in database. It works properly in windows but I don't know how to do it in Linux(Ubuntu). I already uploaded my jar file in linux server but i don't know what i should do for database....
Dump the database somehow. This is a Windows SQL server database, so use whatever tools that you get with Windows SQL server. You can usually do a database dump/export to a file. Create your blank database in Linux, and import the data.

Can't give you 'step by step' instructions, since you don't say which database you're using on Linux. Also, there's no need for us to do that...since if you tried Google, you could find MANY guides already, that tell you this, for all sorts of different databases (MySQL, Postgresql, Oracle, etc...).

EDIT: Follow-ups posted during reply. If the jar file is a Java program written to make ODBC calls to MS SQL, then you have two choices. Keep the database on MSSQL, or move it to Linux, and rewrite the Java code to use Oracle/MySQL/whatever.

Last edited by TB0ne; 06-05-2011 at 12:56 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
any tool for managing remote ms sql server from ubuntu/ meabi Linux - Software 1 01-30-2011 11:39 PM
Accessing MS SQL Server 2005 standards with C programming gopalkc Linux - Newbie 2 10-14-2010 01:52 PM
SQL update statement to SQL SERVER 2005 scheidel21 Programming 2 11-05-2009 07:30 PM
Database Capability vs MS SQL 2005 Noneed Toknow Linux - Newbie 2 10-19-2007 01:36 AM
Database Capability vs MS SQL 2005 Noneed Toknow Linux - General 2 10-18-2007 10:44 AM


All times are GMT -5. The time now is 10:36 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration